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 | Srinivas Surasani | 5 years ago
  1. 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)
  2. 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*.
  3. 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*.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 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.

    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. 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