topic Re: Activiti deadlock sql server in Alfresco Forum 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 gdharley 2017-04-07T20:30:32Z 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