Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server

nikan_negaresh — Mon, 25 Sep 2017 13:15:43 GMT

Hi we recently upgraded from activiti 5.2.x to activiti 6 and now we have deadlock issue on out database.The sql statement which is the source of deadlock is as follows@P0 nvarchar(4000),@P1 int)delete from ACT_RU_TIMER_JOB where ID_ = @P0 and REV_ = @P1 We have tried to add non-clustured in

Re: Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server

nikan_negaresh — Thu, 28 Sep 2017 08:54:45 GMT

Hi All

This issue is fixed by switching on READ_COMMITTED_SNAPSHOT on MSSQL server.

topic Re: Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server in Alfresco Forum

Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server

Re: Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server