Arshad Matin created LENS-778:
---------------------------------
Summary: Killing JDBC Query is not closing the connection
Key: LENS-778
URL: https://issues.apache.org/jira/browse/LENS-778
Project: Apache Lens
Issue Type: Bug
Reporter: Arshad Matin
Use Case
=======
Set max connection pool to 1.
Ran a query and killed it.
Ran another query and it failed throwing following exception
{noformat}
18 Sep 2015 07:18:51 [15e7cb89-5f0c-4741-8da6-69384c94cd01]
[lens-driver-jdbc-2] ERROR org.apache.lens.driver.jdbc.JDBCDriver - Error
executing SQL query: 15e7cb89-5f0c-4741-8da6-69384c94cd01 reason: Streaming
result set com.mysql.jdbc.RowDataDynamic@4651e5c3 is still active. No
statements may be issued when any streaming result sets are open and in use on
a given connection. Ensure that you have called .close() on any active
streaming result sets before attempting more queries.
java.sql.SQLException: Streaming result set
com.mysql.jdbc.RowDataDynamic@4651e5c3 is still active. No statements may be
issued when any streaming result sets are open and in use on a given
connection. Ensure that you have called .close() on any active streaming result
sets before attempting more queries.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:914)
~[mysql-connector-java-5.0.8-bin.jar:na]
at
com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2181)
~[mysql-connector-java-5.0.8-bin.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1542)
~[mysql-connector-java-5.0.8-bin.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
~[mysql-connector-java-5.0.8-bin.jar:na]
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
~[mysql-connector-java-5.0.8-bin.jar:na]
at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
~[mysql-connector-java-5.0.8-bin.jar:na]
at com.mysql.jdbc.Statement.execute(Statement.java:727)
~[mysql-connector-java-5.0.8-bin.jar:na]
at
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:223)
~[c3p0-0.9.5.jar:0.9.5]
at
org.apache.lens.driver.jdbc.JDBCDriver$QueryCallable.call(JDBCDriver.java:327)
[lens-driver-jdbc-2.4.0-inm.jar:2.4.0-inm]
at
org.apache.lens.driver.jdbc.JDBCDriver$QueryCallable.call(JDBCDriver.java:282)
[lens-driver-jdbc-2.4.0-inm.jar:2.4.0-inm]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[na:1.8.0_40]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_40]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_40]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40]
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
