org.quartz.JobPersistenceException: Couldn't commit jdbc connection. 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]

liferay.com | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Clustering - Quartz - Community Forums | Liferay

    liferay.com | 8 months ago
    org.quartz.JobPersistenceException: Couldn't commit jdbc connection. 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

    Session JDBC, handling of those frequent innodb deadlocks?

    GitHub | 5 months ago | choene
    com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
  3. 0

    Innodb deadlock, not mentioned in ENGINE INNODB STATUS

    Stack Overflow | 1 week ago | Tomasz
    com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
  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

      Deadlock found when trying to get lock; 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
      ConnectionImpl.commit
      1. com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
      2. com.mysql.jdbc.Util.getInstance(Util.java:383)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
      6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
      7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
      8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
      9. com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1751)
      9 frames
    4. org.apache.tomcat
      DelegatingConnection.commit
      1. org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:367)
      2. org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:367)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:497)
      3 frames
    6. Spring Framework
      LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke
      1. org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
      1 frame
    7. com.sun.proxy
      $Proxy4.commit
      1. com.sun.proxy.$Proxy4.commit(Unknown Source)
      1 frame
    8. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:497)
      3 frames
    9. quartz
      AttributeRestoringConnectionInvocationHandler.invoke
      1. org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73)
      1 frame
    10. com.sun.proxy
      $Proxy317.commit
      1. com.sun.proxy.$Proxy317.commit(Unknown Source)
      1 frame
    11. quartz
      JobStoreSupport$ClusterManager.run
      1. org.quartz.impl.jdbcjobstore.JobStoreSupport.commitConnection(JobStoreSupport.java:3672)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3254)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3870)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3907)
      4 frames