[ https://issues.apache.org/jira/browse/TRAFODION-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Selvaganesan Govindarajan updated TRAFODION-2696: ------------------------------------------------- Summary: control query cancel qid fails with error 8031 sometimes (was: At time control query cancel qid fails with error 8031) > control query cancel qid fails with error 8031 sometimes > -------------------------------------------------------- > > Key: TRAFODION-2696 > URL: https://issues.apache.org/jira/browse/TRAFODION-2696 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe > Affects Versions: any > Reporter: Selvaganesan Govindarajan > Assignee: Selvaganesan Govindarajan > Fix For: 2.2-incubating > > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)