topic Activiti deadlock sql server in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/activiti-deadlock-sql-server/m-p/41455#M17394 <HTML><HEAD></HEAD><BODY><P style="color: #0c0d0e; background-color: #ffffff; border: 0px; margin: 0px 0px 0.8em;">We had experienced deadlocks with some standard 'Select' queries provided by Activiti on the following tables: <STRONG style="border: 0px; font-weight: bold; font-size: inherit;">ACT_RU_TASK</STRONG>, <STRONG style="border: 0px; font-weight: bold; font-size: inherit;">ACT_RU_EXECUTION</STRONG> and <STRONG style="border: 0px; font-weight: bold; font-size: inherit;">ACT_RE_PROCDEF</STRONG>. Here is an example query:</P><PRE style="color: #0c0d0e; background-color: #f0f0f0; border: 0px; font-size: 13px; margin: 0px 0px 0.8em; padding: 10px;"><CODE style="background-color: #f0f0f0; border: 0px; font-weight: inherit; font-size: 13px;">### SQL: SELECT SUB.* FROM (&nbsp;&nbsp;&nbsp;&nbsp; select distinct TEMPRES_ID_ as ID_, TEMPP_KEY_ as ProcessDefinitionKey, TEMPP_ID_ as ProcessDefinitionId,&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_REV_ as REV_, TEMPRES_ACT_ID_ as ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_BUSINESS_KEY_ as BUSINESS_KEY_, TEMPRES_IS_ACTIVE_ as IS_ACTIVE_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_IS_CONCURRENT_ as IS_CONCURRENT_, TEMPRES_IS_SCOPE_ as IS_SCOPE_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_IS_EVENT_SCOPE_ as IS_EVENT_SCOPE_, TEMPRES_PARENT_ID_ as PARENT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_PROC_INST_ID_ as PROC_INST_ID_, TEMPRES_SUPER_EXEC_ as SUPER_EXEC_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMPRES_SUSPENSION_STATE_ as SUSPENSION_STATE_, TEMPRES_CACHED_ENT_STATE_ as CACHED_ENT_STATE_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPVAR_ID_ as VAR_ID_, TEMPVAR_NAME_ as VAR_NAME_, TEMPVAR_TYPE_ as VAR_TYPE_, TEMPVAR_REV_ as VAR_REV_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPVAR_PROC_INST_ID_ as VAR_PROC_INST_ID_, TEMPVAR_EXECUTION_ID_ as VAR_EXECUTION_ID_, TEMPVAR_TASK_ID_ as VAR_TASK_ID_,&nbsp;&nbsp;&nbsp;&nbsp; TEMPVAR_BYTEARRAY_ID_ as VAR_BYTEARRAY_ID_, TEMPVAR_DOUBLE_ as VAR_DOUBLE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMPVAR_TEXT_ as VAR_TEXT_, TEMPVAR_TEXT2_ as VAR_TEXT2_, TEMPVAR_LONG_ as VAR_LONG_&nbsp;&nbsp;&nbsp;&nbsp; , row_number() over (ORDER BY TEMPRES_ID_ asc) rnk FROM ( select distinct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RES.ID_ as TEMPRES_ID_, RES.REV_ as TEMPRES_REV_, P.KEY_ as TEMPP_KEY_, P.ID_ as TEMPP_ID_,&nbsp;&nbsp;&nbsp;&nbsp; RES.ACT_ID_ as TEMPRES_ACT_ID_, RES.PROC_INST_ID_ as TEMPRES_PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RES.BUSINESS_KEY_ as TEMPRES_BUSINESS_KEY_, RES.IS_ACTIVE_ as TEMPRES_IS_ACTIVE_,&nbsp;&nbsp;&nbsp;&nbsp; RES.IS_CONCURRENT_ as TEMPRES_IS_CONCURRENT_, RES.IS_SCOPE_ as TEMPRES_IS_SCOPE_,&nbsp;&nbsp;&nbsp;&nbsp; RES.IS_EVENT_SCOPE_ as TEMPRES_IS_EVENT_SCOPE_, RES.PARENT_ID_ as TEMPRES_PARENT_ID_,&nbsp;&nbsp;&nbsp;&nbsp; RES.SUPER_EXEC_ as TEMPRES_SUPER_EXEC_, RES.SUSPENSION_STATE_ as TEMPRES_SUSPENSION_STATE_,&nbsp;&nbsp;&nbsp;&nbsp; RES.CACHED_ENT_STATE_ as TEMPRES_CACHED_ENT_STATE_,&nbsp;&nbsp;&nbsp;&nbsp; VAR.ID_ as TEMPVAR_ID_, VAR.NAME_ as TEMPVAR_NAME_, VAR.TYPE_ as TEMPVAR_TYPE_, VAR.REV_ as TEMPVAR_REV_,&nbsp;&nbsp;&nbsp;&nbsp; VAR.PROC_INST_ID_ as TEMPVAR_PROC_INST_ID_, VAR.EXECUTION_ID_ as TEMPVAR_EXECUTION_ID_, VAR.TASK_ID_ as TEMPVAR_TASK_ID_,&nbsp;&nbsp;&nbsp;&nbsp; VAR.BYTEARRAY_ID_ as TEMPVAR_BYTEARRAY_ID_, VAR.DOUBLE_ as TEMPVAR_DOUBLE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VAR.TEXT_ as TEMPVAR_TEXT_, VAR.TEXT2_ as TEMPVAR_TEXT2_, VAR.LONG_ as TEMPVAR_LONG_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_RU_EXECUTION RES&nbsp;&nbsp;&nbsp;&nbsp; inner join ACT_RE_PROCDEF P on RES.PROC_DEF_ID_ = P.ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; left outer join ACT_RU_VARIABLE VAR ON RES.PROC_INST_ID_ = VAR.EXECUTION_ID_ and VAR.TASK_ID_ is null&nbsp; WHERE RES.PARENT_ID_ is null and P.KEY_ = ?&nbsp; and RES.BUSINESS_KEY_ = ?&nbsp;&nbsp; )RES ) SUB WHERE SUB.rnk &gt;= ? AND SUB.rnk &lt; ?</CODE></PRE><P style="color: #0c0d0e; background-color: #ffffff; border: 0px; margin: 0px 0px 0.8em;">Activiti version is 5.15.1, I have changed the version now I use 5.22.0 but the problem it isn't resolved.</P><P style="color: #0c0d0e; background-color: #ffffff; border: 0px;">Does anyone experienced something similar, or does anyone have an idea to start understanding why this happens and how to prevent it?</P><P style="color: #0c0d0e; background-color: #ffffff; border: 0px;">I use sql server.</P></BODY></HTML> Fri, 07 Apr 2017 06:56:00 GMT ambrina82 2017-04-07T06:56:00Z Activiti deadlock sql server https://connect.hyland.com/t5/alfresco-forum/activiti-deadlock-sql-server/m-p/41455#M17394 We had experienced deadlocks with some standard 'Select' queries provided by Activiti on the following tables: ACT_RU_TASK, ACT_RU_EXECUTION and ACT_RE_PROCDEF. Here is an example query:### SQL: SELECT SUB.* FROM (&nbsp;&nbsp;&nbsp;&nbsp; select distinct TEMPRES_ID_ as ID_, TEMPP_KEY_ as ProcessDefinitionKey, TEMPP_ID_ Fri, 07 Apr 2017 06:56:00 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-deadlock-sql-server/m-p/41455#M17394 ambrina82 2017-04-07T06:56:00Z Re: Activiti deadlock sql server https://connect.hyland.com/t5/alfresco-forum/activiti-deadlock-sql-server/m-p/41456#M17395 <HTML><HEAD></HEAD><BODY><P>This appears to be a duplicated of the following question on Stack Overflow:</P><P></P><P><A class="link-titled" href="http://stackoverflow.com/questions/43256607/activiti-deadlocks-occuring-with-queries-on-tables-task-execution-and-procd/43268030?noredirect=1#comment73612408_43268030" title="http://stackoverflow.com/questions/43256607/activiti-deadlocks-occuring-with-queries-on-tables-task-execution-and-procd/43268030?noredirect=1#comment73612408_43268030" rel="nofollow noopener noreferrer">Activiti: deadlocks occuring with queries on tables _TASK, _EXECUTION and _PROCDEF - Stack Overflow</A>&nbsp;<BR /><BR />I believe I answered your question in that forum.</P><P>Thanks,<BR />Greg</P><P>bp3‌</P></BODY></HTML> Fri, 07 Apr 2017 20:30:32 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-deadlock-sql-server/m-p/41456#M17395 gdharley 2017-04-07T20:30:32Z