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.

pentaho.com | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Couldn't execute SQL: LOCK TABLE audit.trans_log IN ACCESS EXCLUSIVE MODE [Archive] - Pentaho Community Forums

    pentaho.com | 1 year ago
    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.
  2. 0

    Couldn't execute SQL: LOCK TABLE audit.trans_log IN ACCESS EXCLUSIVE MODE

    pentaho.com | 8 months ago
    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.
  3. 0

    [PostgreSQL] PSQLException: An I/O error occured while sending to the backend - Grokbase

    grokbase.com | 12 months ago
    org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Mule ESB 3.4.0 CE: Redeliver message through TCP Endpoint upon Socket Exception

    Stack Overflow | 3 years ago | Randy
    java.net.SocketException: Connection reset by peer: socket write error
  6. 0

    Network exception corrected by System.out.println but I dont want to use it

    Stack Overflow | 4 years ago | Andre Friese
    java.net.SocketException: Connection reset by peer: socket write error
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.net.SocketException

    Connection reset by peer: socket write error

    at java.net.SocketOutputStream.socketWrite0()
  2. Java RT
    BufferedOutputStream.flush
    1. java.net.SocketOutputStream.socketWrite0(Native Method)
    2. java.net.SocketOutputStream.socketWrite(Unknown Source)
    3. java.net.SocketOutputStream.write(Unknown Source)
    4. java.io.BufferedOutputStream.flushBuffer(Unknown Source)
    5. java.io.BufferedOutputStream.flush(Unknown Source)
    5 frames
  3. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.PGStream.flush(PGStream.java:521)
    2. org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1141)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:364)
    6 frames
  4. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    1 frame
  5. org.pentaho.di
    TransGraph$26.run
    1. org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
    2. org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
    3. org.pentaho.di.core.database.Database.execStatements(Database.java:1458)
    4. org.pentaho.di.core.database.Database.lockTables(Database.java:3859)
    5. org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchIdUsingLockTables(BaseDatabaseMeta.java:1966)
    6. org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchId(BaseDatabaseMeta.java:2006)
    7. org.pentaho.di.core.database.DatabaseMeta.getNextBatchId(DatabaseMeta.java:2620)
    8. org.pentaho.di.trans.Trans.calculateBatchIdAndDateRange(Trans.java:1896)
    9. org.pentaho.di.trans.Trans.prepareExecution(Trans.java:904)
    10. org.pentaho.di.ui.spoon.trans.TransGraph$26.run(TransGraph.java:3885)
    10 frames
  6. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame