org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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.

Pentaho BI Platform Tracking | Jens Bleuel | 5 years ago
  1. 0

    How to reproduce: - Have a simple transformation with a Table Input and a Database Lookup step pointing to the same connection (see attached) - Do a preview on Database Lookup step - Stop the transformation The Table Input step errors out: orderdetails.0: Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: orderdetails.0: Couldn't close query: resultset or prepared statements orderdetails.0: Query execution was interrupted pentaho_oltp: Error disconnecting from database: pentaho_oltp: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: org.pentaho.di.core.exception.KettleDatabaseException: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:712) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:681) pentaho_oltp: at org.pentaho.di.core.database.Database.disconnect(Database.java:572) pentaho_oltp: at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275) pentaho_oltp: at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) pentaho_oltp: at java.lang.Thread.run(Unknown Source) pentaho_oltp: Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) pentaho_oltp: at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1655) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:701) pentaho_oltp: ... 5 more

    Pentaho BI Platform Tracking | 5 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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.
  2. 0

    How to reproduce: - Have a simple transformation with a Table Input and a Database Lookup step pointing to the same connection (see attached) - Do a preview on Database Lookup step - Stop the transformation The Table Input step errors out: orderdetails.0: Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: orderdetails.0: Couldn't close query: resultset or prepared statements orderdetails.0: Query execution was interrupted pentaho_oltp: Error disconnecting from database: pentaho_oltp: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: org.pentaho.di.core.exception.KettleDatabaseException: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:712) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:681) pentaho_oltp: at org.pentaho.di.core.database.Database.disconnect(Database.java:572) pentaho_oltp: at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275) pentaho_oltp: at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) pentaho_oltp: at java.lang.Thread.run(Unknown Source) pentaho_oltp: Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) pentaho_oltp: at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1655) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:701) pentaho_oltp: ... 5 more

    Pentaho BI Platform Tracking | 5 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    java MySQL transaction / INSERT IGNORE and ON DUPLICATE KEY UPDATE

    Stack Overflow | 4 years ago | user1652310
    java.sql.SQLException: DUP_PK_KEY

  1. mortalman7 1 times, last 4 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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()
  2. MySQL jdbc
    ConnectionImpl.commit
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
    3. com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
    7. com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1655)
    7 frames
  3. org.pentaho.di
    RunThread.run
    1. org.pentaho.di.core.database.Database.commit(Database.java:701)
    2. org.pentaho.di.core.database.Database.commit(Database.java:681)
    3. org.pentaho.di.core.database.Database.disconnect(Database.java:572)
    4. org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275)
    5. org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    5 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame