org.quartz.JobPersistenceException: Couldn't acquire next trigger: Deadlock found when trying to get lock; try restarting transaction [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction]

Terracotta | mrtrin | 7 years ago
  1. 0

    TRIGGER_STATE = ERROR

    terracotta.org | 7 months ago
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Deadlock found when trying to get lock; try restarting transaction [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction]
  2. 0

    TRIGGER_STATE = ERROR

    Terracotta | 7 years ago | mrtrin
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Deadlock found when trying to get lock; try restarting transaction [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    [ActiveMQ-dev] [jira] Created: (AMQ-2551) Locking issue with MySQL InnoDB - Grokbase

    grokbase.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
  5. 0

    Inspections updating diff: MySQLTransactionRollbackException: Deadlock found when trying to get lock

    YouTrack | 8 years ago
    org.springframework.jdbc.UncategorizedSQLException: Error executing update with params:[360456, 360514, 360514]; uncategorized SQLException for SQL [INSERT INTO inspection_diff (BUILD_ID, HASH) SELECT max(BUILD_ID), max(HASH) from inspection_results WHERE BUILD_ID IN (?,?) GROUP BY HASH HAVING count(HASH)=1 AND MAX(BUILD_ID)=? ]; SQL state [40001]; error code [1213]; Deadlock found when trying to get lock; try restarting transaction; 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

      Deadlock found when trying to get lock; try restarting transaction

      at sun.reflect.GeneratedConstructorAccessor22.newInstance()
    2. Java RT
      Constructor.newInstance
      1. sun.reflect.GeneratedConstructorAccessor22.newInstance(Unknown Source)
      2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      3. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      3 frames
    3. MySQL jdbc
      PreparedStatement.executeUpdate
      1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
      2. com.mysql.jdbc.Util.getInstance(Util.java:381)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1045)
      4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
      6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
      7. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
      8. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
      9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
      10. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
      11. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
      12. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
      13. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
      13 frames
    4. Commons DBCP
      DelegatingPreparedStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
      1 frame
    5. quartz
      QuartzSchedulerThread.run
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTriggerStateFromOtherState(StdJDBCDelegate.java:1610)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2756)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2732)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3763)
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2728)
      6. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
      6 frames