topic Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/activiti-6-deadlock-on-delete-and-select-act-ru-job-on-mssql/m-p/23191#M10127 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp;</P><P>we recently upgraded from activiti 5.2.x to activiti 6 and now we have deadlock issue on out database.</P><P>The sql statement which is the source of deadlock is as follows:</P><P>(@P0 nvarchar(4000),@P1 int)delete from ACT_RU_TIMER_JOB where ID_ = @P0 and REV_ = @P1&nbsp; &nbsp; &nbsp; &nbsp;</P><P></P><P>We have tried to add non-clustured index on&nbsp;<SPAN>ID_&nbsp; AND&nbsp;</SPAN><SPAN>REV_&nbsp;however the lock still exists.</SPAN></P><P></P><P><SPAN>the above is the source of issue which cause lock on the followings:</SPAN></P><P><SPAN>(@P0 nvarchar(4000))select * from ACT_RU_JOB where ID_ = @P0&nbsp; &nbsp;</SPAN></P><P></P><P><SPAN>(@P0 datetime2,@P1 int,@P2 int)SELECT SUB.* FROM (<BR /> select<BR /> RES.* , row_number() over (ORDER BY RES.ID_ asc) rnk FROM ( select distinct RES.* <BR /> from ACT_RU_JOB RES<BR /> where RES.LOCK_EXP_TIME_ is not null and RES.LOCK_EXP_TIME_ &lt; @P0<BR /> )RES ) SUB WHERE SUB.rnk &gt;= @P1 AND SUB.rnk &lt; @P2 </SPAN></P><P></P><P></P><P><SPAN>(@P0 int,@P1 int)SELECT SUB.* FROM (<BR /> select<BR /> RES.* , row_number() over (ORDER BY RES.ID_ asc) rnk FROM ( select distinct RES.* <BR /> from ACT_RU_JOB RES<BR /> where LOCK_EXP_TIME_ is null<BR /> )RES ) SUB WHERE SUB.rnk &gt;= @P0 AND SUB.rnk &lt; @P1 </SPAN></P><P></P><P></P><P></P><P><SPAN>Please let me know what further information you require and will provide you&nbsp;</SPAN></P><P><SPAN>regards</SPAN></P><P><SPAN>Nikan</SPAN></P></BODY></HTML> Mon, 25 Sep 2017 13:15:43 GMT nikan_negaresh 2017-09-25T13:15:43Z Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server https://connect.hyland.com/t5/alfresco-forum/activiti-6-deadlock-on-delete-and-select-act-ru-job-on-mssql/m-p/23191#M10127 Hi&nbsp;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<IMG id="smileysad" class="emoticon emoticon-smileysad" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" />@P0 nvarchar(4000),@P1 int)delete from ACT_RU_TIMER_JOB where ID_ = @P0 and REV_ = @P1&nbsp; &nbsp; &nbsp; &nbsp;We have tried to add non-clustured in Mon, 25 Sep 2017 13:15:43 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-6-deadlock-on-delete-and-select-act-ru-job-on-mssql/m-p/23191#M10127 nikan_negaresh 2017-09-25T13:15:43Z Re: Activiti 6 Deadlock on delete and select ACT_RU_JOB on MSSQL Server https://connect.hyland.com/t5/alfresco-forum/activiti-6-deadlock-on-delete-and-select-act-ru-job-on-mssql/m-p/23192#M10128 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>This issue is fixed by switching on READ_COMMITTED_SNAPSHOT on MSSQL server.</P></BODY></HTML> Thu, 28 Sep 2017 08:54:45 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-6-deadlock-on-delete-and-select-act-ru-job-on-mssql/m-p/23192#M10128 nikan_negaresh 2017-09-28T08:54:45Z