Quartz Cluster Scheduler Lock

We accidentally get the exception below when starting the quartz cluster scheduler on 6 instances:

Failed to get the following trigger: a deadlock was detected when trying to get a lock; try restarting the transaction

Here is our quartzConfig.properties

    scheduler.skipUpdateCheck = true
    scheduler.instanceName = 'quartzScheduler'
    scheduler.instanceId = 'AUTO'
    threadPool.threadCount = 13
    threadPool.threadPriority = 5
    jobStore.misfireThreshold = 300000
    jobStore.'class' = 'org.quartz.impl.jdbcjobstore.JobStoreTX'
    jobStore.driverDelegateClass = 'org.quartz.impl.jdbcjobstore.StdJDBCDelegate'
    jobStore.useProperties = true
    jobStore.dataSource = 'myDS'
    jobStore.tablePrefix = 'QRTZ_'
    jobStore.isClustered = true
    jobStore.clusterCheckinInterval = 10000
    dataSource.myDS.driver='com.mysql.jdbc.Driver'
    dataSource.myDS.maxConnections = 15

In our application with mysql db, quartz grail plugins are used (with quartz 2.2.1).

+4
source share

Source: https://habr.com/ru/post/1649936/


All Articles