###### # mysql-connector-java-5.1.18-bin.jar ################################################################################ Test of Kill Query statement vs StreamingResultset: mode KILL_WHILE_READING testBug_.main: PID is 11800 Starting query [select sleep(1) from information_schema.plugins] testBug.slave: Running KILL QUERY 11800 a query returned a row, we're trying to get another... testBug_.slave: interruptor thread done. a query returned a row, we're trying to get another... Iterating over streaming RS got an exception: java.sql.SQLException: Query execution was interrupted Closing RS (some rather old Connector/J implementations would hang in SocketIO here, see bug#64204 ) ... Closing streaming RS got an exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 15 019 milliseconds ago. The last packet sent successfully to the server was 22 554 milliseconds ago. Attempting 2nd query :select '* * * second query intended to fail * * *' Querying thread got exception when exec query :java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@26a1ab54 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@26a1ab54 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:934) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2747) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1911) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1644) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1441) at tests.MySqlKillExecTest.testKillquery(MySqlKillExecTest.java:142) at tests.MySqlKillExecTest.main(MySqlKillExecTest.java:53) Interruptor executor shut down ###### # mysql-connector-java-5.1.34-bin.jar ################################################################################ Test of Kill Query statement vs StreamingResultset: mode KILL_WHILE_READING testBug_.main: PID is 11802 Starting query [select sleep(1) from information_schema.plugins] testBug.slave: Running KILL QUERY 11802 a query returned a row, we're trying to get another... testBug_.slave: interruptor thread done. a query returned a row, we're trying to get another... Iterating over streaming RS got an exception: com.mysql.jdbc.exceptions.jdbc4.MySQLQueryInterruptedException: Query execution was interrupted Closing RS (some rather old Connector/J implementations would hang in SocketIO here, see bug#64204 ) ... Closing streaming RS got an exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 15 023 milliseconds ago. The last packet sent successfully to the server was 22 535 milliseconds ago. Attempting 2nd query :select '* * * second query intended to fail * * *' Querying thread got exception when exec query :java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@6e5e91e4 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@6e5e91e4 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:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3099) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2354) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1530) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1378) at tests.MySqlKillExecTest.testKillquery(MySqlKillExecTest.java:142) at tests.MySqlKillExecTest.main(MySqlKillExecTest.java:53) Interruptor executor shut down ###### # mysql-connector-java-5.1.35-bin.jar ################################################################################ Test of Kill Query statement vs StreamingResultset: mode KILL_WHILE_READING testBug_.main: PID is 11804 Starting query [select sleep(1) from information_schema.plugins] testBug.slave: Running KILL QUERY 11804 a query returned a row, we're trying to get another... testBug_.slave: interruptor thread done. a query returned a row, we're trying to get another... Iterating over streaming RS got an exception: com.mysql.jdbc.exceptions.jdbc4.MySQLQueryInterruptedException: Query execution was interrupted Closing RS (some rather old Connector/J implementations would hang in SocketIO here, see bug#64204 ) ... ... successfully closed a streaming RS Attempting 2nd query :select '* * * second query intended to fail * * *' 2nd query result = * * * second query intended to fail * * * 2nd query finished Interruptor executor shut down ###### # mysql-connector-java-5.1.40-bin.jar ################################################################################ Test of Kill Query statement vs StreamingResultset: mode KILL_WHILE_CLOSING testBug_.main: PID is 11806 Starting query [select sleep(1) from information_schema.plugins] testBug.slave: Running KILL QUERY 11806 a query returned a row and now we're going to close the recordset afterwards testBug_.slave: interruptor thread done. Closing RS (some rather old Connector/J implementations would hang in SocketIO here, see bug#64204 ) ... Closing streaming RS got an exception: com.mysql.jdbc.exceptions.jdbc4.MySQLQueryInterruptedException: Query execution was interrupted Attempting 2nd query :select '* * * second query intended to fail * * *' Querying thread got exception when exec query :java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@30946e09 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@30946e09 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:868) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:864) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3211) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2443) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1453) at com.mysql.jdbc.StatementImpl.setupStreamingTimeout(StatementImpl.java:720) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1302) at tests.MySqlKillExecTest.testKillquery(MySqlKillExecTest.java:142) at tests.MySqlKillExecTest.main(MySqlKillExecTest.java:53) Interruptor executor shut down ###### # mysql-connector-java-5.1.18-bin.jar ################################################################################ Test of Kill Query statement vs StreamingResultset: mode KILL_WHILE_CLOSING_WITH_CLOBBER testBug_.main: PID is 11810 Starting query [select sleep(1) from information_schema.plugins] testBug.slave: Running KILL QUERY 11810 a query returned a row and now we're going to close the recordset afterwards testBug_.slave: interruptor thread done. Closing RS (some rather old Connector/J implementations would hang in SocketIO here, see bug#64204 ) ... Closing streaming RS got an exception: java.sql.SQLException: Query execution was interrupted Attempting 2nd query :select '* * * second query intended to fail * * *' 2nd query result = * * * second query intended to fail * * * 2nd query finished Interruptor executor shut down