[ https://issues.apache.org/jira/browse/LENS-778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15350705#comment-15350705 ]
Puneet Gupta commented on LENS-778: ----------------------------------- [~archana.h] can we try reproducing it . Also is the query kill happening cleanly (not exception in logs) ? > 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: Badrinath Kulkarni > 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)