You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:15 UTC

[jira] [Created] (TRAFODION-1162) LP Bug: 1443246 - WRONG QUERY_STATUS/QUERY_SUB_STATUS for canceled queries in METRIC_QUERY_TABLE

Alice Chen created TRAFODION-1162:
-------------------------------------

             Summary: 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.0-incubating


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
(v6.3.4#6332)