title: quartz clustered scheduler deadlock
body: <p>We randomly get below exception while running quartz clustered scheduler on 6 instances:</p>
  
  <blockquote>
    <p>Couldn't acquire next trigger: Deadlock found when trying to get lock;
    try restarting transaction</p>
  </blockquote>
  
  <p>Here is our quartzConfig.properties</p>
  
  <pre><code>    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
  </code></pre>
  
  <p>We are using quartz grails plugins(with quartz 2.2.1) in our application with mysql db.</p>