drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kunal Khatua (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3021) Exception in a JDBC session causes the client connection to be closed
Date Tue, 12 May 2015 00:26:59 GMT

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

Kunal Khatua commented on DRILL-3021:
-------------------------------------

Exception was reported by Aman during a SqlLine session, when he encountered a CannotPlanException.

For me, concurrent execution of queries results in some queries timing out. For this, the
JDBC client issues query cancel on the statement object.

All queries issued after this on the same session/connection fail with the above CONNECTION
ERROR message.

> Exception in a JDBC session causes the client connection to be closed
> ---------------------------------------------------------------------
>
>                 Key: DRILL-3021
>                 URL: https://issues.apache.org/jira/browse/DRILL-3021
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>    Affects Versions: 1.0.0
>         Environment: RHEL 6.4
>            Reporter: Kunal Khatua
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.0.0
>
>
> When running a lot of queries in a session (one connection), if an exception is encountered
or if the client cancels the query (due to its internal timeout), the following exception
is thrown for subsequent queries being submitted. 
> Error: CONNECTION ERROR: Connection null <--> null (user client) closed unexpectedly.
> 2015-05-10 18:21:33 [pip2] ERROR PipSQuawkling executeQuery - [ 6 / 10_par100 ] CONNECTION
ERROR: Connection null <--> null (user client) closed unexpectedly.
> [Error Id: a57768ad-a6ab-4f83-a1c9-381d127600b3 ]
> java.sql.SQLException: CONNECTION ERROR: Connection null <--> null (user client)
closed unexpectedly.
> [Error Id: a57768ad-a6ab-4f83-a1c9-381d127600b3 ]
>         at org.apache.drill.jdbc.DrillCursor.next(DrillCursor.java:161)
>         at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:167)
>         at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:56)
>         at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
>         at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351)
>         at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:78)
>         at org.apache.drill.jdbc.DrillStatement.executeQuery(DrillStatement.java:81)
>         at PipSQuawkling.executeQuery(PipSQuawkling.java:295)
>         at PipSQuawkling.executeTest(PipSQuawkling.java:148)
>         at PipSQuawkling.run(PipSQuawkling.java:76)
> Caused by: org.apache.drill.common.exceptions.UserException: CONNECTION ERROR: Connection
null <--> null (user client) closed unexpectedly.
> [Error Id: a57768ad-a6ab-4f83-a1c9-381d127600b3 ]
>         at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:495)
>         at org.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener$ChannelClosedListener.operationComplete(QueryResultHandler.java:298)
>         at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
>         at io.netty.util.concurrent.DefaultPromise$LateListeners.run(DefaultPromise.java:845)
>         at io.netty.util.concurrent.DefaultPromise$LateListenerNotifier.run(DefaultPromise.java:873)
>         at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
>         at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
>         at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
>         at java.lang.Thread.run(Thread.java:744)



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

Mime
View raw message