DB Locks in Activiti DB

[achand]

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

[gdharley · Accepted 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

‌