You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Archana H (JIRA)" <ji...@apache.org> on 2016/07/25 10:23:20 UTC
[jira] [Assigned] (LENS-778) Killing JDBC Query is not closing the
connection
[ 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)