[DRILL-2628] sqlline hangs and then asserts when trying to execute anything on a dead JDBC connection

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.1.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Victoria Markman
• Created: 30/Mar/15 23:19
• Updated: 05/Jun/15 00:46
• Resolved: 05/Jun/15 00:46

Description

Here is what I'm observing:

1. Start drill
2. Start sqlline
3. Run couple of queries
4. Bounce drill
5. Run in sqlline: "use dfs.temp"
It hangs and after some time throws an exception:

0: jdbc:drill:schema=dfs> use dfs.joins_views;
java.lang.AssertionError
        at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:111)
        at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:49)
        at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
        at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351)
        at net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:338)
        at net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69)
        at sqlline.SqlLine$Commands.execute(SqlLine.java:3755)
        at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
        at sqlline.SqlLine.dispatch(SqlLine.java:889)
        at sqlline.SqlLine.begin(SqlLine.java:763)
        at sqlline.SqlLine.start(SqlLine.java:498)
        at sqlline.SqlLine.main(SqlLine.java:460)

Comment on a dead JDBC connection is a speculation on my part. I don't know what is actually happening.

Issue Links

• relates to: DRILL-2565 Add AlreadyClosedSqlException, some key checks, and test for future DRILL-2489 fix.