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

    TRIGGER_STATE = ERROR

    terracotta.org | 10 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 | 9 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