Latest version of Microsoft MBSA 1.1.1 says:

I would think that you would still want to remove the
BUILTIN\Administrators group from the sysadmin role even
on a client-only installation.
Many non-administrator users are often members of the
BULTIN\Administrators group on their own machines whether
they should be or not. These users would have the
ability to drop databases, truncate tables, etc., etc.
It may not be the most likely scenario, but stranger
things have happened...
Tim

quote:

---

>--Original Message--
>The latest MBSA (1.1.1) says
>"Issue
>Local Windows administrators should not also be SQL
>database administrators. These roles are very different
>and are typically performed by different people.
>Solution
>Remove BUILTIN\Administrators from the sysadmin role."
>This makes sense for a server. Does it make sense on a
>client machine?
>I am thinking this is necessary for the server that may

---

be

quote:

---

>shared in someway; however, if I am using a setup that

---

has

quote:

---

>DISABLENETWORKPROTOCOLS=1 (no access except from the

---

local

quote:

---

>host itself), I would think this does not apply.
>Does anyone know for sure?
>Giacomo
>.
>

---

Make sure, however that the SQL Server Agent service still has sysadmin
login rights for it's service account, and if you use full-text make sure
[nt authority\system] has sysadmin rights....
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:023601c3d948$60021dd0$a401280a@.phx.gbl...[QUOTE]
> I would think that you would still want to remove the
> BUILTIN\Administrators group from the sysadmin role even
> on a client-only installation.
> Many non-administrator users are often members of the
> BULTIN\Administrators group on their own machines whether
> they should be or not. These users would have the
> ability to drop databases, truncate tables, etc., etc.
> It may not be the most likely scenario, but stranger
> things have happened...
> Tim
>
> be
> has
> local

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 Ec0x22AD2098)
Value:0x6be534c0 Cost0/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 Ec0x22ACE098)
Value:0x6b37a260 Cost0/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 Ec0x249CD4F0)
Value:0x6b37b960 Cost0/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 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Message posted via http://www.sqlmonster.com
I 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 Ec0x22AD2098)
> Value:0x6be534c0 Cost0/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 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/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 Ec0x249CD4F0)
> Value:0x6b37b960 Cost0/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 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/0)
> --
> Message posted via http://www.sqlmonster.com
>

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
>

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 Ec0x22AD2098)
Value:0x6be534c0 Cost0/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 Ec0x22ACE098)
Value:0x6b37a260 Cost0/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 Ec0x249CD4F0)
Value:0x6b37b960 Cost0/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 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Message posted via http://www.droptable.comI recommend following article to analyze deadlocks:
http://support.microsoft.com/?kbid=832524
"BH Ong via droptable.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 deadloc
k
> 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:5
3
> ECID:1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec0x22AD2098
)
> Value:0x6be534c0 Cost0/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:5
4
> 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 Ec0x22ACE098
)
> Value:0x6b37a260 Cost0/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:5
3
> ECID:0
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec0x249CD4F0
)
> Value:0x6b37b960 Cost0/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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> 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 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/0)
> --
> Message posted via http://www.droptable.com
>