AnsweredAssumed Answered

Alfresco 5.2 (Deadlock on table ACT_RU_TASK)

Question asked by tdesany2 on May 22, 2019

Hi all,

 

We have some weird experience with Activiti Workflow for the moment.

We are developing a platform of 900 concurrent users starting and processing workflows

Our DB is composed by 500 tables (Activiti ones included)

 

Sometimes we have some deadlocks on table ACT_RU_TASK

Does someone has explanations or similar experience with this table? I have read posts about it

Here is an exemple of query beeing waiting for a deadlock

 

update ACT_RU_TASK
             SET REV_ = $1,
              NAME_ = $2,
              PARENT_TASK_ID_ = $3,
              PRIORITY_ = $4,
              CREATE_TIME_ = $5,
              OWNER_ = $6,
              ASSIGNEE_ = $7,
              DELEGATION_ = $8,
              EXECUTION_ID_ = $9,
              PROC_DEF_ID_ = $10,
              DESCRIPTION_ = $11,
              DUE_DATE_ = $12,
              CATEGORY_ = $13,
              SUSPENSION_STATE_ = $14,
              FORM_KEY_ = $15
            where ID_= $16
              and REV_ = $17

Outcomes