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

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: connectivity-mxosrvr
• External issue URL: https://bugs.launchpad.net/bugs/1443246
• Assignee: Gao Jie
• Reporter: FengQiang
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:16

Description

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?