Deadlock read

From: Chadi Kassan <chadi_at_myvirtualmodel.com>
Date: Tue, 9 Nov 2004 10:06:12 -0500
Message-ID: <2C605DDCFE30504F82EB1DE0A5EB981E117507@ntexccrp01.mvm.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 09 2004 - 09:03:18 CST