Support Article
ORA-00060: deadlock detected while waiting for resource
SA-68119
Summary
When deploying logic in the Deployment Manager, the application receives stuck threads and error occurs in the logs
This occurs when using the 2uaanry2rhuud SQL_ID. Below is the query for this SQL_ID,
select undeployme0_.UNDEPLOYMENT_ID as UNDEPLOY1_, undeployme0_.HANDLE_CREATION_TIME as HANDLE_C2_, undeployme0_.PROJECT_ID as PROJECT_ID from RTDS_UNDEPLOYMENT_INFO undeployme0_ where (undeployme0_.HANDLE_CREATION_TIME<=:1 ) for update
The application works after reverting logic.
Error Messages
Oracle DB “JDBCExceptionReporter - ORA-00060: deadlock detected while waiting for resource”.
Steps to Reproduce
- Launch the Deployment Manager.
- Deploy the Logic.
Root Cause
The cache-synchronization-timeout was set to the default value (that is, 60000).
Resolution
Perform the following local-change,
Increase the cache-synchronization-timeout value.
Tags:
Published March 19, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.