We are facing deadlock issues on table jbpm_user_tasks with update query (update jbpm_user_tasks set values where id=?), when there is concurrent requests comes to create processInstance 

We enabled Read Commited Snapshot to On at db level and at set isolation level at Datasource Application Level

SpringBootDataSource Configuration with Local entityManagerafactoryBean and Transaction Manager with @Primary annotation as we have multiple datasources in Application

Set below property as we ignored during initial set-up

Hi @Mohan Sumanth

I hope the issue has been resolved after setting the property.

To prevent deadlocks under load, it's necessary to enable snapshot isolation for the BAMOE database:

ALTER DATABASE bamoe SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE bamoe SET READ_COMMITTED_SNAPSHOT ON;

Please feel free to let us know if you have any more questions on this.

Thanks,
Soniya

Yes @SoniaAbraham, its resolved, after setting above configuration settings

ALTER DATABASE bamoe SET ALLOW_SNAPSHOT_ISOLATION ON;ALTER DATABASE bamoe SET READ_COMMITTED_SNAPSHOT ON;