[jira] [Commented] (TRAFODION-1923) executor/TEST106 hangs at drop table at times

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

    [ https://issues.apache.org/jira/browse/TRAFODION-1923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269930#comment-15269930 ] 

ASF GitHub Bot commented on TRAFODION-1923:
-------------------------------------------

GitHub user prashanth-vasudev opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/463

    Fix for TRAFODION-1923

    Basically, we now understand why SQL was not able to close the outstanding scanner , 
    1. because of cancel and the plan involved esps, it was the esps that get killed which did not have an option to close the scanner.
    2. Because of this stale scanner is found in region when drop table is issued.
    3. Chore thread in region is able to clean the stale scanner, however it may kick in at different times. 
    4. A drop table issued in the meantime appears as hung since region observer intercepts  the region close ( due to drop table) and finds a stale scanner.
    5. Fix is to detect this situation in regionobserver and validate if a transaction state object exists for this scanner. If it exists, then the intercept is valid, otherwise let the region close complete.
    
    I have pushed the code and did a PR request so you can review the changes.  However, committers wait till all the regressions in my dev environment complete ( I will send out a message once its done).


You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/prashanth-vasudev/incubator-trafodion trafodion-1923

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/463.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 #463
    
----

----


> executor/TEST106 hangs at drop table at times
> ---------------------------------------------
>
>                 Key: TRAFODION-1923
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1923
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: 2.0-incubating
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Prashanth Vasudev
>            Priority: Critical
>             Fix For: 2.0-incubating
>
>
> executor/TEST106 hangs at
> drop table t106a 
> Currently executor/TEST106 test is not run as part of Daily regression build.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)