Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global Enqueue Services Deadlock detected.

155929Jul 17 2007 — edited Nov 7 2007
Hi Guys

Each time I got this error the instances got frozen I checked the trace file and seems its under resource remastering

ftd received from node 2 (4/0.36.0)
ftd received from node 1 (4/0.36.0)
all ftds received
syncr inc 4 lvl 39 from 1 rcvd (my inc,lvl: 4, 38) (4/0.36.0)
syncr inc 4 lvl 39 from 2 rcvd (my inc,lvl: 4, 39) (4/0.36.0)
ftd received from node 1 (4/0.38.0)
ftd received from node 2 (4/0.38.0)
all ftds received
syncr inc 4 lvl 40 from 1 rcvd (my inc,lvl: 4, 39) (4/0.38.0)
syncr inc 4 lvl 40 from 2 rcvd (my inc,lvl: 4, 40) (4/0.38.0)
*** 2007-05-12 10:32:23.215
* End DRM for pkey remastering request(s) (locally requested)
* kjdrchkdrm: found an RM request in the request queue
Transfer pkey 4294950914 to node 0


Im running a rac 3 nodes using ASM on Red hat 4

the trace file gave me the following information


DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[674.622]
Submitting asynchronized dump request [28]
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.7] :
BLOCKED 0x15c718398 5 [0x360004][0xc16],[TX] [34000-0001-0000C970] 0
BLOCKER 0x15c718230 5 [0x360004][0xc16],[TX] [2A2000-0001-00000157] 0
BLOCKED 0x15c718cc8 5 [0x39000f][0x926],[TX] [2A2000-0001-00000157] 0
BLOCKER 0x15c718b78 5 [0x39000f][0x926],[TX] [34000-0001-0000C970] 0



I already raised this case to oracle but they havent given me some information

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2007
Added on Jul 17 2007
8 comments
20,498 views