A process that has been running fine for a long time encountered an error:
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource.
Why is this happening?
ERROR 2018-12-03 15:48:29,058 [Dispatch Time Slicing : email@example.com (tenant=clarity)] niku.blobcrack (clarity:firstname.lastname@example.org:58636507__BD41492C-25F7-4673-A8CD-535D66539FAC: Time Slicing) Exception during blobcrack process
SQL error code: 60
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource
Time Slicing job was attempting to update the same table as the process, we could observe it in the bg-ca.log. Workaround you can put in place for the process for example you can check if time slicing job is running before proceeding with an update within the process and if it is running you can wait let's say for 30 seconds and try again, if it is not running you can proceed with process updates.