April 30, 2003 at 9:51 am
I am getting deadlock that looks like infamous parallel
process lock, which was resolved after sp2 (Q293232)
This is what I am getting.
Any help appreciated (SQL2K sp3)
Deadlock encountered .... Printing deadlock information
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Wait-for graph
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 SPID: 373 ECID: 0
Statement Type: SELECT Line #: 59
2003-04-29 08:55:04.83 spid4 Input Buf: RPC Event:
spfrmSched_Load;1
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:2
2003-04-29 08:55:04.83 spid4 Waiting for parallel
threads to enlist.
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 -- next branch --
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:5
2003-04-29 08:55:04.83 spid4 Waiting for parallel
threads to enlist.
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 -- next branch --
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:8
2003-04-29 08:55:04.83 spid4 Waiting for parallel
threads to enlist.
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 -- next branch --
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:11
2003-04-29 08:55:04.83 spid4 Waiting for parallel
threads to enlist.
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 -- next branch --
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:14
2003-04-29 08:55:04.83 spid4 Waiting for parallel
threads to enlist.
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 -- next branch --
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4
2003-04-29 08:55:04.83 spid4 Node:1
2003-04-29 08:55:04.83 spid4 Port: 0x42c80500 Xid
Slot: -1, EC: 0x5c5a9550, ECID: 0 (Coordinator), Exchange
Wait Type :e_etypeOpenProducers
2003-04-29 08:55:04.83 spid4 Coordinator: EC =
0x5c5a9550, SPID: 373, ECID: 0, Not Blocking
2003-04-29 08:55:04.83 spid4 Consumer List::
2003-04-29 08:55:04.83 spid4 Producer List::
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 0, EC
= 0x5e596098, SPID: 373, ECID: 1, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 1, EC
= 0x5c70a098, SPID: 373, ECID: 3, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 2, EC
= 0x30ad4098, SPID: 373, ECID: 4, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 3, EC
= 0x5c5b2098, SPID: 373, ECID: 6, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 4, EC
= 0x5e5aa098, SPID: 373, ECID: 7, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 5, EC
= 0x546c2098, SPID: 373, ECID: 5, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 6, EC
= 0x5e592098, SPID: 373, ECID: 2, Blocking
2003-04-29 08:55:04.83 spid4 Producer: Xid Slot: 7, EC
= 0x5e586098, SPID: 373, ECID: 8, Blocking
2003-04-29 08:55:04.83 spid4 Victim Resource Owner:
2003-04-29 08:55:04.83 spid4 ResType:PageSupp
Stype:'OR' SPID:373 ECID:1 Ec:(0x5E596098)
Value:0x5e596098
May 5, 2003 at 12:00 pm
This was removed by the editor as SPAM
May 6, 2003 at 3:50 am
Not sure, is this happening often and is it always the same SPID for the operation? In addition have you added any hot patches after SP3 install and maybe revisioned something back inadvertently? I have not seen this on any of my servers.
May 6, 2003 at 6:57 am
Thanks for the response; to answer your question, no hot patches were applied to the system.
May 13, 2003 at 7:20 am
We've got exactly the same problem on our SQL2K SP3 database. The same error occurred in SP2 too. Our log file looks remarkably similar to yours. We've reported out problem to Microsoft, as I think it's a bug. A work around is to run the query serially rather than in parallel by setting the MAXDOP 1. But this is not really a long term solution. I'll let you know what Microsoft have to say about it.
May 13, 2003 at 8:55 am
Thanks for the information
May 15, 2003 at 7:39 am
How many processors are you all running?
Is this something that can only happen on a multiple CPU machine?
May 15, 2003 at 7:41 am
quote:
How many processors are you all running?Is this something that can only happen on a multiple CPU machine?
We have 8 processor and your answer is yes
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply