org.pentaho.di.core.exception.KettleTransException

There was an error calculating the change data capture date range, it probably involved log table trans_log. Couldn't execute SQL: LOCK TABLE audit.trans_log IN ACCESS EXCLUSIVE MODE An I/O error occured while sending to the backend.

Samebug tips13

Probably there is a bug in TestNG Eclipse plugin (6.8.6.20130607_0745), try an other version (e.g. 6.8.0.20121120_1820)

before running my test in debug mode, i open the debug view, and remove some breakpoints (such as some remaining on NullPointersExceptions, and Sockets)

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web2019

Stack trace

  • org.pentaho.di.core.exception.KettleTransException: There was an error calculating the change data capture date range, it probably involved log table trans_log. Couldn't execute SQL: LOCK TABLE audit.trans_log IN ACCESS EXCLUSIVE MODE An I/O error occured while sending to the backend. at org.pentaho.di.trans.Trans.calculateBatchIdAndDateRange(Trans.java:2059) at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:904) at org.pentaho.di.ui.spoon.trans.TransGraph$26.run(TransGraph.java:3885) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: LOCK TABLE audit.trans_log IN ACCESS EXCLUSIVE MODE An I/O error occured while sending to the backend. at org.pentaho.di.core.database.Database.execStatement(Database.java:1432) at org.pentaho.di.core.database.Database.execStatements(Database.java:1538) at org.pentaho.di.core.database.Database.execStatements(Database.java:1458) at org.pentaho.di.core.database.Database.lockTables(Database.java:3859) at org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchIdUsingLockTables(BaseDatabaseMeta.java:1966) at org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchId(BaseDatabaseMeta.java:2006) at org.pentaho.di.core.database.DatabaseMeta.getNextBatchId(DatabaseMeta.java:2620) at org.pentaho.di.trans.Trans.calculateBatchIdAndDateRange(Trans.java:1896) ... 3 more Caused by: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:364) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) at org.pentaho.di.core.database.Database.execStatement(Database.java:1406) ... 10 more Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush(Unknown Source) at org.postgresql.core.PGStream.flush(PGStream.java:521) at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1141) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254) ... 15 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

ivanszkypeterivanszkypeter
20 times, last one
esaaresaar
Once,
Unknown visitor
Unknown visitorOnce,
PilleoPilleo
Once,
Unknown visitor
Unknown visitorOnce,
217 more bugmates