You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2017/07/15 03:04:01 UTC

[jira] [Assigned] (TRAFODION-2688) Need a way to find queries that are stuck in compilation via RMS

     [ https://issues.apache.org/jira/browse/TRAFODION-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Selvaganesan Govindarajan reassigned TRAFODION-2688:
----------------------------------------------------

    Assignee: Selvaganesan Govindarajan

> Need a way to find queries that are stuck in compilation via RMS
> ----------------------------------------------------------------
>
>                 Key: TRAFODION-2688
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2688
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-exe
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Selvaganesan Govindarajan
>
> When a query is stuck in compilation, there is no way to find it easily. The mxosrvr remains in connected state forever. Connection idle timer doesn't kick in. The query timeout can't cancel this query because the query hasn't start executing. There is a need to find the process id of the mxosrvr(master) process that is stuck in compilation via RMS. Then the mxosrvr process can be killed.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)