cancel
Showing results for 
Search instead for 
Did you mean: 

DB Locks in Activiti DB

achand
Champ in-the-making
Champ in-the-making

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 ACCEPTED ANSWER

gdharley
Elite Collaborator
Elite Collaborator

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 answer in original post

1 REPLY 1

gdharley
Elite Collaborator
Elite Collaborator

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