[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Error: Couldn't acquire next trigger: transaction rollback: serialization failure  XML
Forum Index -> Quartz
Author Message
flowrev1

neo

Joined: 09/24/2014 00:56:20
Messages: 1
Offline

Hi all,

I am trying to implement quartz clustering on HSQL DB with 2 instances having below configuration:

Code:
#============================================================================
 # Configure Main Scheduler Properties  
 #============================================================================
 
 org.quartz.scheduler.instanceName = MyScheduler
 org.quartz.scheduler.instanceId = AUTO
 
 #============================================================================
 # Configure ThreadPool  
 #============================================================================
 
 org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
 org.quartz.threadPool.threadCount = 12
 
 #============================================================================
 # Configure JobStore  
 #============================================================================
 
 org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
 org.quartz.jobStore.useProperties = false
 
 org.quartz.jobStore.isClustered = true
 org.quartz.jobStore.clusterCheckinInterval = 5000
 
 
 org.quartz.jobStore.useDBLocks = true
 org.quartz.jobStore.selectWithLockSQL = SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ? 
 org.quartz.jobStore.dataSource = myDS 
 org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate
 org.quartz.dataSource.myDS.driver = org.hsqldb.jdbcDriver 
 org.quartz.dataSource.myDS.URL =jdbc:hsqldb:hsql://localhost:9001/sampledb
 org.quartz.dataSource.myDS.user = sa 
 org.quartz.dataSource.myDS.password =
 #org.quartz.jobStore.txIsolationLevelSerializable = true
 #org.quartz.jobStore.tablePrefix = QRTZ_


I scheduled 6 jobs to run at the same specific time and got this error sometime (not always):


Code:
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.2-SNAPSHOT.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759) ~[quartz-2.2.2-SNAPSHOT.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757) ~[quartz-2.2.2-SNAPSHOT.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.2-SNAPSHOT.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756) ~[quartz-2.2.2-SNAPSHOT.jar:na]
 	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272) ~[quartz-2.2.2-SNAPSHOT.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.2-SNAPSHOT.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2832) ~[quartz-2.2.2-SNAPSHOT.jar:na]
 	... 5 common frames omitted


My quartz version is 2.2.1. Please help me clarify this problem, thanks a lot :)
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team