Deadlock LIKE error message in the SQL Server Error log but not Deadlock

Hi, I'm seeing the following entries in the SQL Server error log. Query parallelism is ENABLED in the server. It seems like a Deadlock but it is not I hope.

2010-01-02 01:37:09.36 spid76 DBCC CHECKDB (XPlanner) executed by sa found 0 errors and repaired 0 errors.
2010-01-02 04:51:38.25 spid4 Victim Resource Owner:
2010-01-02 04:51:38.25 spid4 ResType:ExchangeId Stype:'AND' SPID:94 ECID:12 Ec:(0x599CE0C0) Value:0x800ee8a4 Cost:(0/270F)
2010-01-02 04:52:08.25 spid4 Victim Resource Owner:
2010-01-02 04:52:08.25 spid4 ResType:ExchangeId Stype:'AND' SPID:94 ECID:11 Ec:(0xAD11A0C0) Value:0x800eec3c Cost:(0/270F)
2010-01-02 06:00:26.81 spid100 Database SolarWinds: IO is frozen for snapshot

Anyone have any experience with this error message?


more ▼

asked Jan 05, 2010 at 03:09 PM in Default

avatar image

31 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

That's a deadlock message. It's showing the victim and the resources that were deadlocked on. You may want to look into that closely because, I think, spid=4 means that it's a system process that was chosen as the deadlock victim.

more ▼

answered Jan 05, 2010 at 03:48 PM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

Thans - It looks like deadlock message but I don't see 2 SPIDs involving here(In deadlock sitution genearally we see 2 or more SPIDs in the contention). I almost get this on alternate days.

Jan 05, 2010 at 05:57 PM Ken13
(comments are locked)
10|1200 characters needed characters left

spid4 is the deadlock monitor, so that's normal. What version of SQL Server are you running? is it 2000? I have a feeling that what you have here may be a parallelism bug, which is why you only see one spid (94) involved

more ▼

answered Jan 19, 2010 at 11:13 PM

avatar image

Nick Kavadias
486 3 5 11

(comments are locked)
10|1200 characters needed characters left

I agree with other post, it is deadlock...

Check the following article... http://support.microsoft.com/kb/832524

Check also Bart Duncan blog... blogs.msdn.com/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

more ▼

answered Feb 18, 2010 at 09:28 PM

avatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 05, 2010 at 03:09 PM

Seen: 9582 times

Last Updated: Jan 05, 2010 at 04:42 PM

Copyright 2018 Redgate Software. Privacy Policy