Deadlock on AcquireAsyncJobsDueCmd for MSSQL

saurabh_biet — Wed, 10 May 2017 12:10:58 GMT

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 ( select RES.* , ro

Re: Deadlock on AcquireAsyncJobsDueCmd for MSSQL

Anonymous — Wed, 10 May 2017 12:27:00 GMT

Even when READ_COMMITTED_SNAPSHOT option(SQL Server's database option) is enabled, are deadlocks reproduced?

You can change READ_COMMITTED_SNAPSHOT option by the following sql.

ALTER DATABASE {data_base_name} SET READ_COMMITTED_SNAPSHOT ON;

* If you want to know detail, you should check the MS's site.
https://msdn.microsoft.com/en-us//library/tcbchxcb(v=vs.110).aspx

topic Deadlock on AcquireAsyncJobsDueCmd for MSSQL in Alfresco Forum

Deadlock on AcquireAsyncJobsDueCmd for MSSQL

Re: Deadlock on AcquireAsyncJobsDueCmd for MSSQL