java.sql.SQLException: Could not retrieve transation read-only status server

GitHub | xmlking | 5 months ago
  1. 0

    GitHub comment 386#233434419

    GitHub | 5 months ago | xmlking
    java.sql.SQLException: Could not retrieve transation read-only status server
  2. 0

    Error: Lock wait timeout exceeded; try restarting transaction

    GitHub | 5 months ago | xmlking
    com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
  3. 0

    SQOOP export fails for BatchUpdateException

    Stack Overflow | 5 months ago | hlagvankar
    java.io.IOException: Can't export data, please check failed map task logs
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    database deadlocks on concurrent deployments

    GitHub | 2 years ago | afischer211
    com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction Error Code: 1213 Call: UPDATE ARTIFACTS SET AGR_NUM_WARN = ?, AGR_NUM_ERR = ? WHERE (CHANNEL_ID = ?) bind => [3 parameters bound] Query: UpdateAllQuery(referenceClass=ArtifactEntity sql="UPDATE ARTIFACTS SET AGR_NUM_WARN = ?, AGR_NUM_ERR = ? WHERE (CHANNEL_ID = ?)")
  6. 0

    Deadlock when creating job instances

    Stack Overflow | 1 year ago | Mickael Marrache
    org.springframework.dao.DataAccessResourceFailureException: Could not obtain last_insert_id(); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction

    7 unregistered visitors
    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.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException

      Lock wait timeout exceeded; try restarting transaction

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
    2. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
      4 frames
    3. MySQL jdbc
      PreparedStatement.execute
      1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
      2. com.mysql.jdbc.Util.getInstance(Util.java:387)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:950)
      4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
      6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
      7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
      8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
      9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
      10. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
      11. com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3597)
      12. com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3572)
      13. com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1117)
      14. com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1137)
      14 frames
    4. snaq.db
      CachedPreparedStatement.execute
      1. snaq.db.CachedPreparedStatement.execute(CachedPreparedStatement.java:327)
      1 frame
    5. com.zendesk.maxwell
      SchemaPosition.run
      1. com.zendesk.maxwell.schema.SchemaPosition.store(SchemaPosition.java:105)
      2. com.zendesk.maxwell.schema.SchemaPosition.work(SchemaPosition.java:77)
      3. com.zendesk.maxwell.RunLoopProcess.runLoop(RunLoopProcess.java:31)
      4. com.zendesk.maxwell.schema.SchemaPosition.run(SchemaPosition.java:63)
      4 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame