OraFAQ Forum: General » Deadlock Error On RAC 9i System

Home » Other » General » Deadlock Error On RAC 9i System (RAC in Oracle 9i on AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deadlock Error On RAC 9i System [message #560944]

Tue, 17 July 2012 23:33

doron.simchoni
Messages: 17
Registered: December 2009

Junior Member

Every couple of days i receive a deadlock error with the below rows from the trace file created:
*** 2011-12-06 13:19:51.686
Global Wait-For-Graph(WFG) at ddTS[0.4] :
BLOCKED 700000021af0bc0 5 [0x6000f][0x24c75],[TX] [65578,43839] 0
BLOCKER 700000021aad9d0 5 [0x6000f][0x24c75],[TX] [65577,11953] 0
BLOCKED 700000021aaec48 5 [0x9001c][0x1250a],[TX] [65577,11953] 0
BLOCKER 700000021af0a58 5 [0x9001c][0x1250a],[TX] [65578,43839] 0

If anybody can help me understanding it will be nice

Trace file is attached

Attachment: deadlock.txt
(Size: 1.47KB, Downloaded 2583 times)

Report message to a moderator

Re: Deadlock Error On RAC 9i System [message #560947 is a reply to message #560944]

Tue, 17 July 2012 23:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

true deadlock is application error.
Oracle RDBMS breaks deadlock & continues.

Report message to a moderator

Re: Deadlock Error On RAC 9i System [message #560950 is a reply to message #560947]

Tue, 17 July 2012 23:52

doron.simchoni
Messages: 17
Registered: December 2009

Junior Member

I read the guidline and don't know what else you ask for
If PL*SQL is not the right place for this error please instruct.
Please elaborate
Doron

Report message to a moderator

Re: Deadlock Error On RAC 9i System [message #560985 is a reply to message #560950]

Wed, 18 July 2012 02:31

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Is it actually a deadlock? I don't remember how 9i reports a deadlock, but my 11g database generates a very different trace file. Here's a sample:

*** 2012-07-18 08:24:25.250
DEADLOCK DETECTED ( ORA-00060 )
 
[Transaction Deadlock]
 
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-000d000e-00000436        29     145     X             27     143           X
TX-000f001a-00000457        27     143     X             29     145           X
 
session 145: DID 0001-001D-00000233	session 143: DID 0001-001B-0000037A 
session 143: DID 0001-001B-0000037A	session 145: DID 0001-001D-00000233 
 
Rows waited on:
  Session 145: obj - rowid = 00013E29 - AAAT4pAAEAAAACTAAN
  (dictionary objn - 81449, file - 4, block - 147, slot - 13)
  Session 143: obj - rowid = 00013E29 - AAAT4pAAEAAAACTAAI
  (dictionary objn - 81449, file - 4, block - 147, slot - 8)

(and by the way, above is how you are meant to format copy/pastes, as mentioed in the guide)

Report message to a moderator

Previous Topic:	Oracle
Next Topic:	Types of Software Testing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:59:27 CST 2024