org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection Communications link failure during commit(). Transaction resolution unknown.


Solutions on the web

Solution icon of web
via pentaho.com by Unknown author, 8 months ago
Error comitting connection Communications link failure during commit(). Transaction resolution unknown.

Solution icon of pentaho
via Pentaho BI Platform Tracking by Jens Bleuel, 1 year ago
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.

Solution icon of pentaho
via Pentaho BI Platform Tracking by Jens Bleuel, 10 months ago
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:

Solution icon of web
Error comitting connection Communications link failure during commit(). Transaction resolution unknown.

Solution icon of web
via pentaho.com by Unknown author, 1 year ago
Error comitting connection Closed Connection

Solution icon of pentaho
via Pentaho BI Platform Tracking by Rutger Deterd Oude Weme, 1 year ago
Error comitting connection An I/O error occured while sending to the backend.

Solution icon of web
via pentaho.com by Unknown author, 1 year ago
Error comitting connection Unable to get database metadata from this database connection No operations allowed after connection closed.

Stack trace

org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection

Communications link failure during commit(). Transaction resolution unknown.
	at org.pentaho.di.core.database.Database.commit(Database.java:711)
	at org.pentaho.di.core.database.Database.commit(Database.java:680)
	at org.pentaho.di.core.database.Database.disconnect(Database.java:571)
	at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
	at java.lang.Thread.run(Thread.java:636)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
	at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1664)
	at org.pentaho.di.core.database.Database.commit(Database.java:700)
	... 5 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 1 month ago
Once, 4 months ago
3 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
47 more bugmates