topic Alfresco 5.2 (Deadlock on table ACT_RU_TASK) in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-5-2-deadlock-on-table-act-ru-task/m-p/38142#M16080 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>We have some weird experience with Activiti Workflow for the moment.</P><P>We are&nbsp;developing a platform of 900 concurrent users starting and processing workflows</P><P>Our DB is composed by 500 tables (Activiti ones included)</P><P></P><P>Sometimes we have some deadlocks on table ACT_RU_TASK</P><P>Does someone has&nbsp;explanations or similar experience with this table? I have read posts about it</P><P>Here is an exemple of query beeing waiting for a deadlock</P><P></P><DIV style="font-weight: normal;">update ACT_RU_TASK<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET REV_ = $1,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NAME_ = $2,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PARENT_TASK_ID_ = $3,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIORITY_ = $4,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CREATE_TIME_ = $5,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OWNER_ = $6,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ASSIGNEE_ = $7,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DELEGATION_ = $8,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXECUTION_ID_ = $9,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PROC_DEF_ID_ = $10,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DESCRIPTION_ = $11,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DUE_DATE_ = $12,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CATEGORY_ = $13,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUSPENSION_STATE_ = $14,<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FORM_KEY_ = $15<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where ID_= $16<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and REV_ = $17</DIV></BODY></HTML> Wed, 22 May 2019 10:54:19 GMT tdesany2 2019-05-22T10:54:19Z Alfresco 5.2 (Deadlock on table ACT_RU_TASK) https://connect.hyland.com/t5/alfresco-forum/alfresco-5-2-deadlock-on-table-act-ru-task/m-p/38142#M16080 Hi all,We have some weird experience with Activiti Workflow for the moment.We are&nbsp;developing a platform of 900 concurrent users starting and processing workflowsOur DB is composed by 500 tables (Activiti ones included)Sometimes we have some deadlocks on table ACT_RU_TASKDoes someone has&nbsp;explanations Wed, 22 May 2019 10:54:19 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-5-2-deadlock-on-table-act-ru-task/m-p/38142#M16080 tdesany2 2019-05-22T10:54:19Z