[
https://issues.apache.org/jira/browse/TRAFODION-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16105309#comment-16105309
]
ASF GitHub Bot commented on TRAFODION-2696:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1189
[TRAFODION-2696] control query cancel qid fails with error 8031 somet…
…imes
With this change, ssmp will not be stopped when the query
is stuck at the time of close for more than 5 minutes. The ssmp is forced
to dump core only.
Fix for executor/TEST106 failure caused by PR 1188
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-2695
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1189.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1189
----
----
> 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)
