05-17-2017 02:34 PM
We are getting DB deadlocks from Activiti DB in production environment. DBAs have identified several locks. One set of SQLs causing the locks is given below-
Is there any solution for this? Activiti version used is 5.9. Will upgrading to latest version solve this? Need an urgent solution as this is occurring in production environment.
Thanks in advance for the help.
SQL_TEXT('7u87tws0zqgwk')
--------------------------------------------------------------------------------
update ACT_GE_BYTEARRAY
set
REV_ = :1 ,
BYTES_ = :2
where ID_ = :3
and REV_ = :4
SQL_TEXT('35pkdfpxcm8yx')
--------------------------------------------------------------------------------
update ACT_RU_EXECUTION set
REV_ = :1 ,
PROC_DEF_ID_ = :2 ,
ACT_ID_ = :3 ,
IS_ACTIVE_ = :4 ,
IS_CONCURRENT_ = :5 ,
IS_SCOPE_ = :6 ,
IS_EVENT_SCOPE_ = :7 ,
PARENT_ID_ = :8 ,
SUPER_EXEC_ = :9 ,
SUSPENSION_STATE_ = :10
where ID_ = :11
and REV_ = :12
05-18-2017 08:59 AM
No idea if upgrading will resolve the issue as you haven't really identified the execution pattern.
Typically, ACT_RU_EXECUTION/ACT_GE_BYTEARRAY deadlocks only appear if you are updating the same variable in the same execution simultaneously. This is really not a great pattern.
However, upgrading can't hurt, your version is at least 3 years old and much has changed in that time.
Greg
05-18-2017 08:59 AM
No idea if upgrading will resolve the issue as you haven't really identified the execution pattern.
Typically, ACT_RU_EXECUTION/ACT_GE_BYTEARRAY deadlocks only appear if you are updating the same variable in the same execution simultaneously. This is really not a great pattern.
However, upgrading can't hurt, your version is at least 3 years old and much has changed in that time.
Greg
Explore our Alfresco products with the links below. Use labels to filter content by product module.