[
https://issues.apache.org/jira/browse/TRAFODION-1923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)