![]() Process session holds waits process session holds waits TX-0006001a-0000131b ![]() The following information may aid in determining the deadlock: Deadlock graph: -Blocker(s)-Waiter(s)- Resource Name It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. *** 09:11:40.646 *** ACTION NAME:() 09:11:40.615 *** MODULE NAME:(SQL*Plus) 09:11:40.615 *** SERVICE NAME:(SYS$USERS) 09:11:40.615 *** SESSION ID:(137.7008) 09:11:40.615 DEADLOCK DETECTED Current SQL statement for this session: SELECT ID FROM DEADLOCK_2 WHERE ID = 1 FOR UPDATE - PL/SQL Call Stack - objectġ6 anonymous block The following deadlock is not an ORACLE error. I get the name of a primary key on a completely different table! Could this be a clue as to why the deadlock is happening? How do I use the above information to find out what caused the problem? There aren't any unindexed foreign keys on either TABLE_A or TABLE_B (which I believe is commonly the cause of this type of error). ![]() Session 22: obj - rowid = 0002A6B1 - AAAqaxAAUAAAAFTAAA Session 200: obj - rowid = 0002A6B1 - AAAqaxAAUAAAAFTAAA Resource Name process session holds waits process session holds waits ![]() Information may aid in determining the deadlock: It is aĭeadlock due to user error in the design of an application The following deadlock is not an ORACLE error. SELECT A_ID FROM TABLE_B WHERE SOME_COLUMN=:SOMECOLUMN I looked in the trace file generated for this event and it shows me which query caused this: I'm not sure how to determine the cause of this error, so if anyone could help me it would be greatly appreciated. Strange thing is that this is intermittent and as soon if i retry same function and same data it goes through.When testing my application with multiple users, I have encountered an ORA-00060 deadlock error. I never get error in insertData function, but i often get above errors in transactionData function. You can identify from above that on which line i am seeing errors. Transaction commit failed-Error: ORA-24324: service handle not initialized.Transaction error -ORA-00060: deadlock detected while waiting for resource.Transaction commit failed-Error: DPI-1010: not connected.Instant Client) version? Is it 64-bit or 32-bit? How was it installed? Where is it installed? Using docker image collinestes/docker-node-oracle:10-slim What is your Node.js version? Is it 64-bit or 32-bit? Run version.js from This.poolIncrement = ? parseInt(, 10) : 0 Īwait oracledb.getPool(this.poolAlias).close() Ĭonsole.log(`Establishing Oracle DB connection to host: $) Import oracleConfig from "././config/oracle-config"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |