Deadlocked Trigger

Error:

org.quartz.JobPersistenceException: Couldn't update trigger state(s): Transaction (Process ID 199) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 199) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Solution:

We have found a property "org.quartz.jobStore.acquireTriggersWithinLock" this was used for the acquisition of next triggers to fire should occur within an explicit database lock. This was once necessary (in previous versions of Quartz) to avoid dead-locks with particular databases, but it is no longer considered necessary, hence the default value is "false".

Please follow the below step as a workaround for now:

1) Open quartz.properties file located inside "ServerKernel/etc" .
2) Add a below line under "Configure JobStore" section
"org.quartz.jobStore.acquireTriggersWithinLock=true"
3) Save this file and Restart Adeptia Services i.e. Kernel and Web-runner.