org.quartz.JobPersistenceException: Couldn't acquire next trigger: transaction rollback: serialization failure

Terracotta Project Issue Tracker | Long Nh | 2 years ago
  1. 0

    I got an exception when trying Quartz (2.2.1) clustering on HSQL DB (2.3.1). Use case: run 6 jobs immediately, repeat after 30 secs with 1 quartz cluster containing 2 instances (configuration is attached). This exception did not happen when running 1 instancess Sep 30 2014 17:01:56.832| [SchedulerService_QuartzSchedulerThread] [ERROR] org.quartz.core.ErrorLogger- An error occurred while scanning for the next triggers to fire. org.quartz.JobPersistenceException: Couldn't acquire next trigger: transaction rollback: serialization failure at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2848) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756) ~[quartz-2.2.1.jar:na] at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272) ~[quartz-2.2.1.jar:na] Caused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) ~[c3p0-0.9.1.1.jar:0.9.1.1] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:2666) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2832) ~[quartz-2.2.1.jar:na] ... 5 common frames omitted

    Terracotta Project Issue Tracker | 2 years ago | Long Nh
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: transaction rollback: serialization failure
  2. 0

    I got an exception when trying Quartz (2.2.1) clustering on HSQL DB (2.3.1). Use case: run 6 jobs immediately, repeat after 30 secs with 1 quartz cluster containing 2 instances (configuration is attached). This exception did not happen when running 1 instancess Sep 30 2014 17:01:56.832| [SchedulerService_QuartzSchedulerThread] [ERROR] org.quartz.core.ErrorLogger- An error occurred while scanning for the next triggers to fire. org.quartz.JobPersistenceException: Couldn't acquire next trigger: transaction rollback: serialization failure at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2848) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756) ~[quartz-2.2.1.jar:na] at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272) ~[quartz-2.2.1.jar:na] Caused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.1.jar:2.3.1] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) ~[c3p0-0.9.1.1.jar:0.9.1.1] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:2666) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2832) ~[quartz-2.2.1.jar:na] ... 5 common frames omitted

    Terracotta Project Issue Tracker | 2 years ago | Long Nh
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: transaction rollback: serialization failure
  3. 0

    Random failure of test MultiNodeTest#testHighlanderMode

    GitHub | 3 years ago | marcanpilami
    javax.persistence.RollbackException: Error while committing the transaction
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Eclipselink OptimisticLock causing deadlocks

    Stack Overflow | 2 years ago | user3491141
    java.sql.SQLTransactionRollbackException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 338) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Error Code: 1205 Call: SELECT CAL_ID_NR, CAL_CNX_B, REC_STS_CD, REC_SEQ_NR, SRC_DAT_CTR_NR, REC_UDT_TS, REC_TYP_VER_NR FROM TCALCNX WHERE (CAL_ID_NR = ?) bind => [P4F22420140806182408001244] Query: ReadObjectQuery(name="readObject" referenceClass=CallContentEntity sql="SELECT CAL_ID_NR, CAL_CNX_B, REC_STS_CD, REC_SEQ_NR, SRC_DAT_CTR_NR, REC_UDT_TS, REC_TYP_VER_NR FROM TCALCNX WHERE (CAL_ID_NR = ?)")
  6. 0

    Eclipselink OptimisticLock causing deadlocks

    Stack Overflow | 2 years ago | user3491141
    java.sql.SQLTransactionRollbackException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 338) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Error Code: 1205 Call: UPDATE TCALCNX SET CAL_CNX_B = ?, REC_STS_CD = ?, REC_UDT_TS = ? WHERE ((CAL_ID_NR = ?) AND (REC_UDT_TS = ?)) bind => [[B@1c1f9699, 02, 2014-08-06 12:27:22.645, P4F21420140806182553001248, 2014-08-06 12:27:21.287] Query: UpdateObjectQuery(CALL ID :P4F21420140806182553001248 REC_UDT_TS :2014-08-06 12:27:22.645 REC_STS_CD:02 SRC_DT_CNTR:10 VERSION_NUM :001 REC_SEQ_NR:1)

    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. java.sql.SQLTransactionRollbackException

      transaction rollback: serialization failure

      at org.hsqldb.jdbc.JDBCUtil.sqlException()
    2. HSQLDB
      JDBCPreparedStatement.executeUpdate
      1. org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)[hsqldb-2.3.1.jar:2.3.1]
      2. org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)[hsqldb-2.3.1.jar:2.3.1]
      3. org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)[hsqldb-2.3.1.jar:2.3.1]
      4. org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)[hsqldb-2.3.1.jar:2.3.1]
      4 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeUpdate
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)[c3p0-0.9.1.1.jar:0.9.1.1]
      1 frame
    4. quartz
      QuartzSchedulerThread.run
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:2666)[quartz-2.2.1.jar:na]
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2832)[quartz-2.2.1.jar:na]
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759)[quartz-2.2.1.jar:na]
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757)[quartz-2.2.1.jar:na]
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787)[quartz-2.2.1.jar:na]
      6. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)[quartz-2.2.1.jar:na]
      7. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)[quartz-2.2.1.jar:na]
      7 frames