trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From selvaganesang <...@git.apache.org>
Subject [GitHub] incubator-trafodion pull request #1182: [TRAFODION-2688] Need a way to find ...
Date Sat, 15 Jul 2017 03:09:02 GMT
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.govindarajan@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 ;

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message