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

Terracotta Project Issue Tracker | Long Nh | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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 | 3 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 | 3 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

    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