PLEASE help me interpret this 1205 trace!!!

Question

PLEASE help me interpret this 1205 trace!!!

Greg J

SSCarpal Tunnel

Points: 4288
More actions
November 17, 2005 at 2:48 pm

#167023

try searching on "sp_Member_Info". it starts getting good around there. I'm trying to figure out what resources are involved. what are the 2 conflicting requests from SQL?
what other info can I provide?
2005-11-17 15:42:29.91 spid4----------------------------------
2005-11-17 15:42:29.91 spid4End deadlock search 11280 ... a deadlock was found.
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:1 Ec0x62D08098) Value:0x45d
2005-11-17 15:42:29.91 spid4Victim Resource Owner:
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:4 Ec0x69C1E098) Value:0x4aa
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:24
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:6 Ec0x29F44098) Value:0x434
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:21
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:7 Ec0x2C53A098) Value:0xb24
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:18
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:8 Ec0x212FE098) Value:0x367
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:15
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:5 Ec0x7D16E098) Value:0x42f
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:12
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:2 Ec0x2A13E098) Value:0x495
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:9
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:3 Ec0x71D98098) Value:0x800
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:6
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Value:0x4a
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Grant List 2::
2005-11-17 15:42:29.91 spid4Owner:0x3fe7bd20 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:69 ECID:0
2005-11-17 15:42:29.91 spid4Grant List 0::
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:3
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:1 Ec0x62D08098) Value:0x45d
2005-11-17 15:42:29.91 spid4Requested By:
2005-11-17 15:42:29.91 spid4Input Buf: Language Event: exec sp_Member_Info @exec='INSERT', @memmpsalutation
2005-11-17 15:42:29.91 spid4SPID: 68 ECID: 23 Statement Type: INSERT Line #: 1
2005-11-17 15:42:29.91 spid4Owner:0x4aa35d00 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:68 ECID:23
2005-11-17 15:42:29.91 spid4Wait List:
2005-11-17 15:42:29.91 spid4PAG: 8:1:264540 CleanCnt:9 Mode: IX Flags: 0x2
2005-11-17 15:42:29.91 spid4Node:2
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 8, EC = 0x69c1e098, SPID: 69, ECID: 4, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 7, EC = 0x29f44098, SPID: 69, ECID: 6, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 6, EC = 0x2c53a098, SPID: 69, ECID: 7, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 5, EC = 0x212fe098, SPID: 69, ECID: 8, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 4, EC = 0x7d16e098, SPID: 69, ECID: 5, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 3, EC = 0x2a13e098, SPID: 69, ECID: 2, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 2, EC = 0x71d98098, SPID: 69, ECID: 3, Blocking
2005-11-17 15:42:29.91 spid4Producer: Xid Slot: 1, EC = 0x62d08098, SPID: 69, ECID: 1, Blocking
2005-11-17 15:42:29.91 spid4Producer List::
2005-11-17 15:42:29.91 spid4Consumer: Xid Slot: 0, EC = 0x8055f530, SPID: 69, ECID: 0, Blocking
2005-11-17 15:42:29.91 spid4Consumer List::
2005-11-17 15:42:29.91 spid4Coordinator: EC = 0x8055f530, SPID: 69, ECID: 0, Not Blocking
2005-11-17 15:42:29.91 spid4Input Buf: Language Event: exec sp_member_info @exec='insert', @memmpemail1='pe
2005-11-17 15:42:29.91 spid4SPID: 69 ECID: 0 Statement Type: SELECT Line #: 267
2005-11-17 15:42:29.91 spid4Port: 0x80080380 Xid Slot: 0, EC: 0x8055f530, ECID: 0 (Coordinator), Exchange
2005-11-17 15:42:29.91 spid4Node:1
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Wait-for graph
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4...
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:24 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:4 Ec0x69C1E098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:21 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:6 Ec0x29F44098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:18 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:7 Ec0x2C53A098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:15 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:8 Ec0x212FE098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:12 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:5 Ec0x7D16E098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:9 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:2 Ec0x2A13E098) Val
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:6 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:3 Ec0x71D98098) Val
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4Node:3 ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:2 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:1 Ec0x62D08098) Val
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4Deadlock cycle was encountered .... verifying cycle
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:24 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:4 Ec0x69C1E098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:21 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:6 Ec0x29F44098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:18 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:7 Ec0x2C53A098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:15 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:8 Ec0x212FE098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:12 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:5 Ec0x7D16E098) Va
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:9 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:2 Ec0x2A13E098) Val
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:6 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:3 Ec0x71D98098) Val
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4-- next branch --
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4
2005-11-17 15:42:29.91 spid4Cycle: ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4Node:3 ResType:LockOwner Stype:'OR' Mode: S SPID:68 ECID:23 Ec0x4C918098) Va
2005-11-17 15:42:29.91 spid4Node:2 ResType:LockOwner Stype:'OR' Mode: S SPID:69 ECID:1 Ec0x62D08098) Val
2005-11-17 15:42:29.91 spid4Node:1 ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x8
2005-11-17 15:42:29.91 spid4ResType:ExchangeId Stype:'AND' SPID:69 ECID:0 Ec0x8055F530) Value:0x80083bb0
2005-11-17 15:42:29.91 spid4Target Resource Owner:
2005-11-17 15:42:29.91 spid4Starting deadlock search 11280
2005-11-17 15:42:29.91 spid4----------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 1

Bit of a drag looking through the log, you could run the blocker utility provided by http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

and then run SQL Sherlock to analyse the results

http://www.sqlteam.com/item.asp?ItemID=21737

This won't help you interprate the log you have but it will make block detection easier in the future