Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Deadlock - parallellism ?

Author  Topic 

rockmoose
SQL Natt Alfen

3279 Posts
Posted - 2006-07-06 : 11:12:06
Hi,

One proc (reporting query)
Started deadlocking, tracing in the sqllog gave me these results.
(Ordered Desc)
I have never seen this before, anyone knows what the likely reason can be?

index fragmentation?, bad query plan?

When i set the option(maxdop 1) the query runs ok.

Update: I removed the option maxdop, and it started to work.



deadlocks                                                                                                                                                                                                                                                        
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
2006-07-06 16:03:06.33 spid4      ResType:LockOwner Stype:'OR' Mode: S SPID:73 ECID:2 Ec:(0xD17E80C0) Value:0x935bb7c0 Cost:(0/0)
2006-07-06 16:03:06.33 spid4     Victim Resource Owner:
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xd5e900c0, SPID: 73, ECID: 11, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd5b880c0, SPID: 73, ECID: 12, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd5b760c0, SPID: 73, ECID: 10, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0800  Xid Slot: 0, EC: 0xc47f1530, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeMsgReceive
2006-07-06 16:03:06.33 spid4     Node:2
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 5, EC: 0xd5e900c0, ECID: 11 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:51
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 5, EC: 0xd5e900c0, ECID: 11 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:51
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 5, EC: 0xd5e900c0, ECID: 11 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:51
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 5, EC: 0xd5e900c0, ECID: 11 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:51
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xd5e900c0, SPID: 73, ECID: 11, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd5b880c0, SPID: 73, ECID: 12, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd5b760c0, SPID: 73, ECID: 10, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0800  Xid Slot: 0, EC: 0xc47f1530, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeMsgReceive
2006-07-06 16:03:06.33 spid4     Node:2
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 4, EC: 0xd5b880c0, ECID: 12 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:43
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 4, EC: 0xd5b880c0, ECID: 12 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:43
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 4, EC: 0xd5b880c0, ECID: 12 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:43
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 4, EC: 0xd5b880c0, ECID: 12 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:43
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xd5e900c0, SPID: 73, ECID: 11, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd5b880c0, SPID: 73, ECID: 12, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd5b760c0, SPID: 73, ECID: 10, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0800  Xid Slot: 0, EC: 0xc47f1530, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeMsgReceive
2006-07-06 16:03:06.33 spid4     Node:2
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 3, EC: 0xd5b760c0, ECID: 10 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:3
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 3, EC: 0xd5b760c0, ECID: 10 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:3
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 3, EC: 0xd5b760c0, ECID: 10 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:3
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 0, EC: 0xc6fae0c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:4
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 0, EC: 0xc6fae0c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:4
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 0, EC: 0xc6fae0c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:4
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 3, EC: 0xc6fa60c0, ECID: 7 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:5
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 3, EC: 0xc6fa60c0, ECID: 7 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:5
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 1, EC: 0xd1ca80c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:8
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 5, EC: 0xa22340c0, ECID: 9 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:21
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 5, EC: 0xa22340c0, ECID: 9 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:21
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 5, EC: 0xa22340c0, ECID: 9 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:21
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 5, EC: 0xa22340c0, ECID: 9 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:21
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 1, EC: 0xd1ca80c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:8
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 4, EC: 0xd1fc80c0, ECID: 8 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:11
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4        ResType:LockOwner Stype:'OR' Mode: IX SPID:126 ECID:0 Ec:(0xB53F9558) Value:0xa8e9d540 Cost:(0/368)
2006-07-06 16:03:06.33 spid4      Requested By: 
2006-07-06 16:03:06.33 spid4        Input Buf: RPC Event: multiple_bet_submit;1
2006-07-06 16:03:06.33 spid4        SPID: 98 ECID: 0 Statement Type: INSERT Line #: 142
2006-07-06 16:03:06.33 spid4        Owner:0xdbbf1460 Mode: IX       Flg:0x0 Ref:1 Life:02000000 SPID:98 ECID:0
2006-07-06 16:03:06.33 spid4      Wait List:
2006-07-06 16:03:06.33 spid4     PAG: 8:3:2708773               CleanCnt:3 Mode: S Flags: 0x2
2006-07-06 16:03:06.33 spid4     Node:17
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4        ResType:LockOwner Stype:'OR' Mode: S SPID:73 ECID:2 Ec:(0xD17E80C0) Value:0x935bb7c0 Cost:(0/0)
2006-07-06 16:03:06.33 spid4      Requested By: 
2006-07-06 16:03:06.33 spid4      Grant List 3::
2006-07-06 16:03:06.33 spid4        Input Buf: RPC Event: v4_transaction_addExternal;1
2006-07-06 16:03:06.33 spid4        SPID: 126 ECID: 0 Statement Type: INSERT Line #: 142
2006-07-06 16:03:06.33 spid4        Owner:0xa8e9cae0 Mode: IX       Flg:0x0 Ref:1 Life:02000000 SPID:126 ECID:0
2006-07-06 16:03:06.33 spid4      Grant List 2::
2006-07-06 16:03:06.33 spid4     PAG: 8:1:115200                CleanCnt:2 Mode: IX Flags: 0x2
2006-07-06 16:03:06.33 spid4     Node:16
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 4, EC: 0xd1fc80c0, ECID: 8 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:11
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 4, EC: 0xd1fc80c0, ECID: 8 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:11
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 4, EC: 0xd1fc80c0, ECID: 8 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:11
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 1, EC: 0xd1ca80c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:8
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 1, EC: 0xd1ca80c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:8
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 3, EC: 0xc6fa60c0, ECID: 7 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:5
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     -- next branch --
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Not Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 3, EC: 0xc6fa60c0, ECID: 7 (Producer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:5
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 5, EC = 0xa22340c0, SPID: 73, ECID: 9, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 4, EC = 0xd1fc80c0, SPID: 73, ECID: 8, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xc6fa60c0, SPID: 73, ECID: 7, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 2, EC = 0xd17e80c0, SPID: 73, ECID: 2, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 1, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0880  Xid Slot: 0, EC: 0xc6fae0c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:4
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd1ca80c0, SPID: 73, ECID: 3, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd17e80c0, SPID: 73, ECID: 2, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 0, EC = 0xc6fae0c0, SPID: 73, ECID: 1, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 5, EC = 0xd5e900c0, SPID: 73, ECID: 11, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 4, EC = 0xd5b880c0, SPID: 73, ECID: 12, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 3, EC = 0xd5b760c0, SPID: 73, ECID: 10, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d1580  Xid Slot: 3, EC: 0xd5b760c0, ECID: 10 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-07-06 16:03:06.33 spid4     Node:3
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 3, EC = 0xd5e900c0, SPID: 73, ECID: 11, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 2, EC = 0xd5b880c0, SPID: 73, ECID: 12, Blocking
2006-07-06 16:03:06.33 spid4     Producer: Xid Slot: 1, EC = 0xd5b760c0, SPID: 73, ECID: 10, Blocking
2006-07-06 16:03:06.33 spid4     Producer List::
2006-07-06 16:03:06.33 spid4     Consumer: Xid Slot: 0, EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Consumer List::
2006-07-06 16:03:06.33 spid4     Coordinator: EC = 0xc47f1530, SPID: 73, ECID: 0, Not Blocking
2006-07-06 16:03:06.33 spid4     Port: 0x800d0800  Xid Slot: 0, EC: 0xc47f1530, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeMsgReceive
2006-07-06 16:03:06.33 spid4     Node:2
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4        ResType:LockOwner Stype:'OR' Mode: IX SPID:98 ECID:0 Ec:(0xB9C41558) Value:0xdbbf1460 Cost:(0/340)
2006-07-06 16:03:06.33 spid4      Requested By: 
2006-07-06 16:03:06.33 spid4        Input Buf: Language Event: exec dbo.bibit_reportNotSettled '20060601', '20060801'
2006-07-06 16:03:06.33 spid4        SPID: 73 ECID: 0 Statement Type: SELECT Line #: 25
2006-07-06 16:03:06.33 spid4        Owner:0xb05f8100 Mode: S        Flg:0x0 Ref:0 Life:00000001 SPID:73 ECID:0
2006-07-06 16:03:06.33 spid4      Grant List 2::
2006-07-06 16:03:06.33 spid4     PAG: 8:3:2708773               CleanCnt:3 Mode: S Flags: 0x2
2006-07-06 16:03:06.33 spid4     Node:1
2006-07-06 16:03:06.33 spid4     
2006-07-06 16:03:06.33 spid4     Wait-for graph
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site