DB Locks in Activiti DB

cancel
Showing results for 
Search instead for 
Did you mean: 
achand
Member II

DB Locks in Activiti DB

Jump to solution

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

1 Solution

Accepted Solutions
gdharley
Intermediate

Re: DB Locks in Activiti DB

Jump to solution

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

View solution in original post

1 Reply
gdharley
Intermediate

Re: DB Locks in Activiti DB

Jump to solution

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