[
https://issues.apache.org/jira/browse/TRAFODION-1162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Smits updated TRAFODION-1162:
------------------------------------
Fix Version/s: (was: 2.1-incubating)
2.2.0
> LP Bug: 1443246 - WRONG QUERY_STATUS/QUERY_SUB_STATUS for canceled queries in
> METRIC_QUERY_TABLE
> ------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1162
> URL: https://issues.apache.org/jira/browse/TRAFODION-1162
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-mxosrvr
> Reporter: FengQiang
> Assignee: Gao Jie
> Priority: Critical
> Fix For: 2.2.0
>
>
> Two scenarios for this issue
> 1. Cancel a running query with sql command control query cancel qid
> "MXID11000013602212294668646838350000000000906U3333300_32053_XX".
> In "_REPOS_".METRIC_QUERY_TABLE, it has value for EXEC_END_UTC_TS. But
> QUERY_STATUS is COMPLETED and no value for QUERY_SUB_STATUS. Should either of
> the status tells that the query was canceled?
> 2. Kill the trafci client while a select query is still running.
> In "_REPOS_".METRIC_QUERY_TABLE, it has value for EXEC_END_UTC_TS. But
> QUERY_STATUS remains 'EXECUTING' and no value for QUERY_SUB_STATUS. Should
> either of the status tells that the query was canceled?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
