[jira] [Created] (LENS-778) Killing JDBC Query is not closing the connection

["Arshad Matin (JIRA)" <ji...@apache.org>]

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)