[
https://issues.apache.org/jira/browse/DRILL-2993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14537386#comment-14537386
]
Daniel Barclay (Drill) commented on DRILL-2993:
-----------------------------------------------
Investigation notes:
Reproducible with large (100 MB) CVS file of 100-byte lines (10 or so columns).
Is because throttling isn't disabled when query is canceled (so throttled
messages from canceled query aren't send and apparently block server-to-client
messages for later (hanging) queries).
Fix: Disable throttling when query canceled/closed.
Might be only partial fix--throttling one query's results shouldn't block
another query's results _if_ Drill intends to support having multiple queries
in progress at the same time (multiple Statements/ResultSets open with
interspersed results access (single-threaded)).
> SQLLine hangs when we cancel a query in the middle of displaying results
> ------------------------------------------------------------------------
>
> Key: DRILL-2993
> URL: https://issues.apache.org/jira/browse/DRILL-2993
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Reporter: Rahul Challapalli
> Assignee: Daniel Barclay (Drill)
>
> git.commit.id.abbrev=8c706e6
> The data set contains 1 million records. I cancelled the below query after
> displaying around ~400,000 records. All subsequent queries fail
> {code}
> 0: jdbc:drill:schema=dfs_eea>select * from `mobile.json`;
> .....
> .....
> Cancel after displaying 400,000 records
> 0: jdbc:drill:schema=dfs_eea>use dfs.drillTestDir;
> ....
> This hangs indefinitely
> {code}
> Since the data is large, I did not attach it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
