Terracotta Discussion Forums

Hello,

I need a help for the quartz-2.1.0 clustering problem.

I have setup the clustering with 2 machines with single mysql as the JobStore.

#============================================================================
# Configure Main Scheduler Properties
#============================================================================

org.quartz.scheduler.instanceName = MyClusteredScheduler
org.quartz.scheduler.instanceId = AUTO

#============================================================================
# Configure ThreadPool
#============================================================================

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 25
org.quartz.threadPool.threadPriority = 5

#============================================================================
# Configure JobStore
#============================================================================

org.quartz.jobStore.misfireThreshold = 60000

org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.useProperties = false
org.quartz.jobStore.dataSource = myDS
org.quartz.jobStore.tablePrefix = QRTZ_

org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 20000

#============================================================================
# Configure Datasources
#============================================================================

org.quartz.dataSource.myDS.driver = oracle.jdbc.driver.OracleDriver
org.quartz.dataSource.myDS.URL = jdbc:mysql://mydb.com:3306/quartz
org.quartz.dataSource.myDS.user = quartz
org.quartz.dataSource.myDS.password = quartz
org.quartz.dataSource.myDS.maxConnections = 5
org.quartz.dataSource.myDS.validationQuery=select 1

I scheduled a job, but it intermittently fires the same triggers in the both machines(sometimes).

ex: A job having a single trigger which will fire after every 1min.

most of the time it will be fired in only one of the machines.
but intermittently it fires in both the machines.

time is synced to the ntp server in the network.

Am I doing anything wrong ?

Hopefully someone will help me out. L

Thanks & Regards,
Santhosh

Are you using innodb tables?

also, any reason you can't upgrade to 2.1.5 ?

yes, we are using innodb. Is there any bug ?

we haven't thought of upgrade yet.

Is it resolved in quartz-2.1.5?

IIRC, there was some similar bug in 2.1.0.

Could you please provide the bug details (JIRA) ticket or something.?

Actually,
After changing the org.quartz.jobStore.acquireTriggersWithinLock to true.
This issue never happened again.

Do u think org.quartz.jobStore.acquireTriggersWithinLock=false with loadbalance setup causes this issue?

Do u see any problem with this configuration?

Thanks & Regards,
Santhosh