Last part of deadlock

I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
for various reasons. Most of them related to incorrect use of triggers and
has been resolved except the last part!! I hv managed to trace the deadlock
below with 1204 flag. Any hints would be most helpful.
many thks
--=============================
Wait-for graph
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
Input Buf: RPC Event: sp_cursoropen;1
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:2
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Wait List:
Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
ECID:1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec:(0x22AD2098)
Value:0x6be534c0 Cost:(0/0)
Node:3
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Grant List 1::
Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
ECID:0
SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
Input Buf: RPC Event: sp_executesql;1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
Value:0x6b37a260 Cost:(0/0)
Node:4
PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
Grant List 1::
Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
ECID:0
Requested By:
ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec:(0x249CD4F0)
Value:0x6b37b960 Cost:(0/1BC)
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Victim Resource Owner:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
Value:0x6b37a260 Cost:(0/0)
--
Message posted via http://www.sqlmonster.comI recommend following article to analyze deadlocks:
http://support.microsoft.com/?kbid=832524
"BH Ong via SQLMonster.com" wrote:
> I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
> for various reasons. Most of them related to incorrect use of triggers and
> has been resolved except the last part!! I hv managed to trace the deadlock
> below with 1204 flag. Any hints would be most helpful.
> many thks
>
> --=============================> Wait-for graph
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
> Input Buf: RPC Event: sp_cursoropen;1
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:2
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Wait List:
> Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
> ECID:1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec:(0x22AD2098)
> Value:0x6be534c0 Cost:(0/0)
> Node:3
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Grant List 1::
> Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
> ECID:0
> SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
> Input Buf: RPC Event: sp_executesql;1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
> Value:0x6b37a260 Cost:(0/0)
> Node:4
> PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
> Grant List 1::
> Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
> ECID:0
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec:(0x249CD4F0)
> Value:0x6b37b960 Cost:(0/1BC)
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Victim Resource Owner:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
> Value:0x6b37a260 Cost:(0/0)
> --
> Message posted via http://www.sqlmonster.com
>