[
https://issues.apache.org/jira/browse/LENS-778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Archana H reassigned LENS-778:
------------------------------
Assignee: Archana H (was: Badrinath Kulkarni)
> 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
> Components: driver-jdbc
> Reporter: Arshad Matin
> Assignee: Archana H
> Fix For: 2.6
>
>
> 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)
