topic Re: DB Locks in Activiti DB in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/db-locks-in-activiti-db/m-p/36413#M15374 <HTML><HEAD></HEAD><BODY><P>No idea if upgrading will resolve the issue as you haven't really identified the execution pattern.<BR />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.</P><P>However, upgrading can't hurt, your version is at least 3 years old and much has changed in that time.</P><P></P><P>Greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Thu, 18 May 2017 15:59:04 GMT gdharley 2017-05-18T15:59:04Z DB Locks in Activiti DB https://connect.hyland.com/t5/alfresco-forum/db-locks-in-activiti-db/m-p/36412#M15373 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 o Wed, 17 May 2017 21:34:03 GMT https://connect.hyland.com/t5/alfresco-forum/db-locks-in-activiti-db/m-p/36412#M15373 achand 2017-05-17T21:34:03Z Re: DB Locks in Activiti DB https://connect.hyland.com/t5/alfresco-forum/db-locks-in-activiti-db/m-p/36413#M15374 <HTML><HEAD></HEAD><BODY><P>No idea if upgrading will resolve the issue as you haven't really identified the execution pattern.<BR />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.</P><P>However, upgrading can't hurt, your version is at least 3 years old and much has changed in that time.</P><P></P><P>Greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Thu, 18 May 2017 15:59:04 GMT https://connect.hyland.com/t5/alfresco-forum/db-locks-in-activiti-db/m-p/36413#M15374 gdharley 2017-05-18T15:59:04Z