[TRAFODION-2696] control query cancel qid fails with error 8031 sometimes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.2.0
• Component/s: sql-exe
• Assignee: Selvaganesan Govindarajan
• Reporter: Selvaganesan Govindarajan
• Created: 28/Jul/17 06:34
• Updated: 15/Sep/18 07:32
• Resolved: 12/Oct/17 21:48

Description

At times even the long running query fails with the following error message

• • • ERROR[8031] Server declined cancel request for query ID MXID11000025653212367983150736000000000000206U3333300_106__SQLCI_DML_LAST_. The query is not registered with the cancel broker.

This error can happen if the ssmp process is restarted after the query start executing. When the ssmp is restarted, the posted query started message is lost and hence the query can't be cancelled. However, we can minimize this failure by avoiding ssmp restarts within the engine whereever possible.

Issue Links

• links to: GitHub Pull Request #1189