![]() ![]() ![]() Why were the two statements waiting for the resource and why was this resource unavailable. If it is a bug, a sign the filesystem may be having issues, or that the raid controller couldn't handle the load. What I am after is an idea what it might be, someone who had this happen before who could make an informed guess. ![]() The stacktrace and memory dump could provide more information however I am not a specialist in troubleshooting those. Current SQL Statement for this session (sql_id=6bvzdgdn8vqqt8). Pid: 38 O/S info: user: example_user, term: UNKNOWN, ospid: 14589 Information for the OTHER waiting sessions. Session 142: DID 0001-0026-00000068 session 11: DID 0001-0024-0000005D APP-AR-11526: ORA-00060: deadlock detected while waiting for resource delete from RAINTERFACESALESCREDITS S where (REQUESTID:b0 and ex APP-AR-11526: 24294359/ar/lib/raacit.lpc 400 Error calling raacit() STEPS TO REPRODUCE: 1. Resource Name process session holds waits process session holds waits Relevant trace file output: Deadlock graph: This is not a production system by the way. Posted by previoustoolboxuser on Jun 22nd, 2010 at 12:21 AM. Does it indicate a bug or impeding filesystem failure? I understand running an import and adding datafiles to a tablespace at the same time may be a lot to ask of a server, however this is server has 4 CPUs, 64 GB and a few TB of SAS raid10 at its disposal. Autoinvoice import program failed with error APP-AR-11526: ORA-00060: deadlock detected while waiting for resource. I am asking why this happens because it is unusual to me. I can restart the alter tablespace statement and it mostly will go all right the second attempt. ORA-00060: deadlock detected while waiting for resource This infinite loop is caused by either an application or bad ad hoc SQL, but Oracle. I sometimes get the following error when running the above statement: ERROR at line 1: This deadlock condition is an age-old issue known as the perpetual embrace. I am importing a dumpfile and at the same time I am increasing the tablespace using statements such as this: alter tablespace example add datafile '/path/to/oradata/instance/exampleXX.dbf' size 31000m In this case it's an Oracle11 instance (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit running on Linux to be precise). Though I frequently do this kind of thing for many years now. For more information about Oracle (NYSE:ORCL), visit have noticed something in Oracle which never happened before to me. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! ORA-00060: deadlock detected while waiting for resource ChangesĬonverting non-cdb to pdb fails. ORA-00604: error occurred at recursive SQL level 1 ORA-44303: service name exists WHENEVER SQLERROR EXIT ġ5:57:28 SQL> alter pluggable database "&pdbname" open upgrade 15:56:45 SQL> alter pluggable database "&pdbname" open upgrade ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |