java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock.

incubator-sqoop-user | alo alt | 5 years 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

    Re: Sqoop and Teradata

    incubator-sqoop-user | 5 years ago | alo alt
    java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock.
  2. 0

    Re: Sqoop and Teradata

    incubator-sqoop-user | 5 years ago | alo alt
    java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock.
  3. 0

    Sqoop and Teradata

    Google Groups | 5 years ago | Srinivas Surasani
    java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock*. com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:223)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sqoop and Teradata

    incubator-sqoop-user | 5 years ago | Srinivas Surasani
    java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock*.
  6. 0

    Sqoop and Teradata

    incubator-sqoop-user | 5 years ago | Srinivas Surasani
    java.io.IOException: java.sql.BatchUpdateException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock*.

    Root Cause Analysis

    1. com.teradata.jdbc.jdbc_4.util.JDBCException

      [Teradata Database] [TeraJDBC 13.00.00.07] [Error 2631] [SQLState 40001] Transaction ABORTed due to DeadLock.

      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException()
    2. com.teradata.jdbc
      TeraLocalPreparedStatement.executeBatch
      1. com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:288)
      2. com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
      3. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:285)
      4. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:176)
      5. com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:108)
      6. com.teradata.jdbc.jdbc_4.statemachine.PreparedBatchStatementController.run(PreparedBatchStatementController.java:59)
      7. com.teradata.jdbc.jdbc_4.Statement.executeStatement(Statement.java:331)
      8. com.teradata.jdbc.jdbc_4.PreparedStatement.executeBatchDMLArray(PreparedStatement.java:138)
      9. com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:299)
      9 frames
    3. com.cloudera.sqoop
      AsyncSqlOutputFormat$AsyncSqlExecThread.run
      1. com.cloudera.sqoop.mapreduce.AsyncSqlOutputFormat$AsyncSqlExecThread.run(AsyncSqlOutputFormat.java:232)
      1 frame