[
https://issues.apache.org/jira/browse/TRAFODION-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16088391#comment-16088391
]
ASF GitHub Bot commented on TRAFODION-2688:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1182
[TRAFODION-2688] Need a way to find queries that are stuck in compila…
…tion via RMS
When a query is stuck in compilation, 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.
To find the queries stuck in compile for more than 30 seconds
cd $TRAF_HOME/export/limited-support-tools/LSO
./offender -s queries_in_compile
This script lists queries that are being compiled for more than the given
number of seconds
CURRENT_TIMESTAMP TIME_IN_SECONDS NODE PID
QUERY_ID `
SOURCE_TEXT
-------------------------- -------------------- ----------- -----------
----------------------------------------------------------------------------
----------------------
2017-07-15 01:54:14.909780 1860 0 5505
MXID11000005505212366841736965000000000000206U3333300_278___SQLCI_DML_LAST__
"select * from partsupp ;
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-2420_7
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1182.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 #1182
----
commit df0be6449e45d5fed13e796402f435460fb40040
Author: selvaganesang <selva.govindara...@esgyn.com>
Date: 2017-07-15T02:57:08Z
[TRAFODION-2688] Need a way to find queries that are stuck in compilation
via RMS
When a query is stuck in compilation, 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.
To find the queries stuck in compile for more than 30 seconds
cd $TRAF_HOME/export/limited-support-tools/LSO
./offender -s queries_in_compile
This script lists queries that are being compiled for more than the given
number of seconds
CURRENT_TIMESTAMP TIME_IN_SECONDS NODE PID
QUERY_ID `
SOURCE_TEXT
-------------------------- -------------------- ----------- -----------
----------------------------------------------------------------------------
----------------------
2017-07-15 01:54:14.909780 1860 0 5505
MXID11000005505212366841736965000000000000206U3333300_278___SQLCI_DML_LAST__
"select * from partsupp ;
----
> 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)
