[jira] [Commented] (DRILL-3038) Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

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

Khurram Faraaz commented on DRILL-3038:
---------------------------------------

Adding more information about the scenario that leads to these messages.

1.  issue a long running SQL query from sqlline (one that runs for long, for several minutes)
2.  Ctrl-C on sqlline, where the long running query was issued and is running.
3.  issue another SQL query (it can be any query) - this query now HANGS and there is no progress on sqlline prompt or in the drillbit.log
4.  cd /opt/mapr/drill/drill-1.0.0/bin
stop the Drillbit to which you are connected to
5.  ./drillbit.sh stop

Then you will see the messages on sqlline prompt.

> Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.
> -------------------------------------------------------------------------------------
>
>                 Key: DRILL-3038
>                 URL: https://issues.apache.org/jira/browse/DRILL-3038
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.0.0
>            Reporter: Khurram Faraaz
>            Assignee: Chris Westin
>            Priority: Minor
>
> When I stop a Drillbit using drillbit.sh stop on which a SQL query is hung, I see these messages on sqlline prompt
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select count(*) from `twoKeyJsn.json`;
> Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.
> [Error Id: 53fdea70-6bf9-4dd7-914f-8ad1390bcfc9 ] (state=,code=0)
> 0: jdbc:drill:schema=dfs.tmp> +------------+------------+
> . . . . . . . . . . . . . . > 1,803,958 rows selected (37.233 seconds)
> . . . . . . . . . . . . . . > 0: jdbc:drill:schema=dfs.tmp> select count(*) from `twoKeyJsn.json`;
> Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.
> [Error Id: 05f13b36-545b-4428-a547-d70d537643cf ] (state=,code=0)
> 0: jdbc:drill:schema=dfs.tmp> 
> 0: jdbc:drill:schema=dfs.tmp> +------------+------------+
> . . . . . . . . . . . . . . > 1,803,958 rows selected (37.233 seconds)
> . . . . . . . . . . . . . . > 0: jdbc:drill:schema=dfs.tmp> select count(*) from `twoKeyJsn.json`;
> Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.
> [Error Id: 9d546618-7be7-4fa9-8655-37e2725805b0 ] (state=,code=0)
> {code}



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