topic Re: Deadlock on AcquireAsyncJobsDueCmd for MSSQL in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/deadlock-on-acquireasyncjobsduecmd-for-mssql/m-p/31219#M13235 <HTML><HEAD></HEAD><BODY><P>Even when READ_COMMITTED_SNAPSHOT option(SQL Server's database option) is enabled, are deadlocks reproduced?</P><P></P><P>You can change READ_COMMITTED_SNAPSHOT option by the following sql.</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>ALTER DATABASE {data_base_name} SET READ_COMMITTED_SNAPSHOT ON;</P></BLOCKQUOTE><P>* If you want to know detail, you should check the MS's site.<BR /><A class="jive-link-external-small" href="https://msdn.microsoft.com/en-us//library/tcbchxcb(v=vs.110).aspx" rel="nofollow noopener noreferrer" target="_blank">https://msdn.microsoft.com/en-us//library/tcbchxcb(v=vs.110).aspx</A></P><P></P><P>* Similar problem<BR /><A class="jive-link-external-small" href="https://github.com/Activiti/Activiti/issues/1083" rel="nofollow noopener noreferrer" target="_blank">https://github.com/Activiti/Activiti/issues/1083</A></P></BODY></HTML> Wed, 10 May 2017 12:27:00 GMT Anonymous 2017-05-10T12:27:00Z Deadlock on AcquireAsyncJobsDueCmd for MSSQL https://connect.hyland.com/t5/alfresco-forum/deadlock-on-acquireasyncjobsduecmd-for-mssql/m-p/31218#M13234 Hi There,I am using activiti in one of my project. I am using 5.22.0 version of activiti. I am using sprint boot in my application. My activiti engine is using MSSQL.Whenever I do a performance test of my application I see the following error:### SQL: SELECT SUB.* FROM ( &nbsp; &nbsp; select&nbsp; &nbsp; &nbsp; &nbsp; RES.* , ro Wed, 10 May 2017 12:10:58 GMT https://connect.hyland.com/t5/alfresco-forum/deadlock-on-acquireasyncjobsduecmd-for-mssql/m-p/31218#M13234 saurabh_biet 2017-05-10T12:10:58Z Re: Deadlock on AcquireAsyncJobsDueCmd for MSSQL https://connect.hyland.com/t5/alfresco-forum/deadlock-on-acquireasyncjobsduecmd-for-mssql/m-p/31219#M13235 <HTML><HEAD></HEAD><BODY><P>Even when READ_COMMITTED_SNAPSHOT option(SQL Server's database option) is enabled, are deadlocks reproduced?</P><P></P><P>You can change READ_COMMITTED_SNAPSHOT option by the following sql.</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>ALTER DATABASE {data_base_name} SET READ_COMMITTED_SNAPSHOT ON;</P></BLOCKQUOTE><P>* If you want to know detail, you should check the MS's site.<BR /><A class="jive-link-external-small" href="https://msdn.microsoft.com/en-us//library/tcbchxcb(v=vs.110).aspx" rel="nofollow noopener noreferrer" target="_blank">https://msdn.microsoft.com/en-us//library/tcbchxcb(v=vs.110).aspx</A></P><P></P><P>* Similar problem<BR /><A class="jive-link-external-small" href="https://github.com/Activiti/Activiti/issues/1083" rel="nofollow noopener noreferrer" target="_blank">https://github.com/Activiti/Activiti/issues/1083</A></P></BODY></HTML> Wed, 10 May 2017 12:27:00 GMT https://connect.hyland.com/t5/alfresco-forum/deadlock-on-acquireasyncjobsduecmd-for-mssql/m-p/31219#M13235 Anonymous 2017-05-10T12:27:00Z