Cannot insert data to table after ORA-00060 has been encountered.

Cannot insert data to table after ORA-00060 has been encountered.

  

Hi All

We've encounter the error below during the insertion of the data in a table.

ORA-00060: deadlock detected while waiting for resource

After that, we tried uploading the data to the same table and we've encountered this error ORA-01013: user requested cancel of current operation.Since then,we cannot upload data anymore.

Can someone help me how to resolve the issue and educate me on how we can avoid such error in the future.

Note: The uploading works fine previously and no changes has been made and this is the first time we've encountered such error. Also, this is working in our other environments.

Below are the detailed errors:


Regards, 

Froi





You have a deadlock. Oracle likes to NEVER release resources in some cases.

The immediate fix is to restart JBoss on all of the front end servers in the environment to release the lock. The long term fix is to figure out what happened, you may need to open a support ticket with OutSystems to understand why the lock wasn't released in the first place.

J.Ja

I full agree with Justin James!! 


regards,

Vijay Malviya