AnsweredAssumed Answered

DB Locks in Activiti DB

Question asked by achand on May 17, 2017
Latest reply on May 18, 2017 by gdharley

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

Outcomes