[jira] [Commented] (TRAFODION-2696) control query cancel qid fails with error 8031 sometimes

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ 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)