Query that produces Intra-Query Parallelism Deadlock

Posted on 2007-08-01
Medium Priority
Last Modified: 2013-11-26
Can anyone point me to a query that will consitently produce a 8650 Intra-Query Parallelism deadlock message?

Or can anyone tell me if 8650 will be the exception number passed in the SqlError within the SqlException?

I'm using SQL 2000 SP4 I believe.  On the client side I'm using VS2003, .NET 1.1, VB.NET

Thank you!
Question by:mericks1
  • 2
LVL 43

Expert Comment

by:Eugene Z
ID: 19613262

Author Comment

ID: 19617048
Thanks Eugene,  I tried that query and I'm guessing they are using a view which may contribute to the issue, so I can't really duplicate that given my database.

As far as the solution, that's pretty much what I've been running into, either re-write it or single thread it.  Single threading it might be an option, but the main issue here is that it's not consistently failing, so I need to be able to gracefully handle this exception from the client, which is a .NET 1.1 windows service.  I can simulate this sortof, with a raiseerror, but that will have an exception number of 50000, which I'm guessing will not be the same as the real exception.


Author Comment

ID: 19617328
Ok, I found it.  I wasn't looking though the SqlError collection in the SqlException, I was looking at the SqlException.Number which apparently holds the number of the first exception, which in this case was 50000.  The client was specifically looking for 8650 and wasn't finding it.  So I just itterate through the SqlErrors collection looking for 8650 to determine if we've had a intra-query parallelism deadlock.

Thanks for you help!


Accepted Solution

Computer101 earned 0 total points
ID: 19815884
PAQed with points refunded (125)

EE Admin

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question