Hi,
I am getting deadlock error while completing tasks.
{“timestamp”:1667218964066,“status”:500,“errors”:[{“code”:1003,“value”:“ERR_INTERNAL_ERROR”,“message”:“\n### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 283) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.\n### The error may exist in org/flowable/variable/service/db/mapping/entity/VariableInstance.xml\n### The error may involve org.flowable.variable.service.impl.persistence.entity.VariableInstanceEntityImpl.selectVariablesByQuery\n### The error occurred while handling results\n### SQL: select * from ACT_RU_VARIABLE WHERE SUB_SCOPE_ID_ = ? AND SCOPE_TYPE_ in ( ? )\n### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 283) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”,“details”:“”}],
This happens while running multiple tasks in parallel with the spring transaction enabled.