Deadlock read
- From: Chadi Kassan <chadi@xxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 9 Nov 2004 10:06:12 -0500
Hi everyone,
Can anyone explain what caused this deadlock or how to read this kind of
deadlock (i'm just wondering how it happens with the insert).
thank you
=================================================
DEADLOCK DETECTED
Current SQL statement for this session:
INSERT INTO COLORS (color_code, clr_id, clr_name, bu_bu_id) VALUES (:1, :2,
:3, :4)
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)--------
---------Waiter(s)---------
Resource Name process session holds waits process session holds
waits
TX-0056001a-0000008d 50 368 X 74 426
S
TX-00660018-0000006f 74 426 X 50 368
S
session 368: DID 0001-0032-00039980 session 426: DID 0001-004A-00022694
session 426: DID 0001-004A-00022694 session 368: DID 0001-0032-00039980
Rows waited on:
Session 426: obj - rowid = 000101AA - AAAQGqAAXAAAAkKAAA
(dictionary objn - 65962, file - 23, block - 2314, slot - 0)
Session 368: obj - rowid = 000101C7 - AAAQHHAAWAAAGANAAA
(dictionary objn - 65991, file - 22, block - 24589, slot - 0)
Information on the OTHER waiting sessions:
Session 426:
pid=74 serial=2070 audsid=189403 user: 71/ADI_IL_TEST
O/S info: user: , term: , ospid: 1234, machine: esjmstst01
program:
Current SQL Statement:
INSERT INTO COLORS (color_code, clr_id, clr_name, bu_bu_id) VALUES (:1,
:2, :3, :4)
End of information on OTHER waiting sessions.
===================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
