Hi,
Where did you get the error message? I suspect the error message was mixed
with something unrelated. The normal error message from SQL Server should
be something like the following instead (without the string of "on thread |
communication buffer resources"):
Transaction (Process ID 55) was deadlocked with another process and has
been chosen as the deadlock victim. Rerun the transaction.
The select statement will also require locks, meanwhile the connection
might be in a transaction and had already held some locks acquired by
previous operations.
You can start the troubleshooting with enabling the traceflag 1204 to get
more information about the deadlock chain (which table, what type of locks
etc.) and you might also need SQL Profiler trace to find out the
application logic causing the deadlock (e.g. find out what is the "previous
operations" as mentioned above).
Thanks and regards,
Liu An
Microsoft Support Engineer
Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Lines: 17
| Newsgroups: microsoft.public.sqlserver.server
| Date: 24 Jun 2002 16:24:02 GMT
| Organization: AOL http://www.aol.com
| Subject: Deadlock on Thread | Communication buffer resources
| Path:
cpmsftngxa08!tkmsftngp01!newsfeed00.sul.t-online.de!t-online.de!news-spur1.m
axwell.syr.edu!news.maxwell.syr.edu!news-out.nuthinbutnews.com!propagator-st
erling!news-in.nuthinbutnews.com!cyclone1.gnilink.net!ngpeer.news.aol.com!au
drey04.news.aol.com!not-for-mail
| Xref: cpmsftngxa08 microsoft.public.sqlserver.server:216005
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Running SQL Server 2000, I'm periodically getting this error executing a
select
| statement that joins 5 tables.
|
| "Error","TID=200","06/21/02","16:54:10","ODBC Error Code = 40001
(Serialization
| failure)<P> [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction
(Process
| ID 55) was deadlocked on thread | communication buffer resources with
another
| process and has been chosen as the deadlock victim. Rerun the transaction.
|
| Since this is a select only, I don't quite understand how there could be
| deadlock issues.
|
| I've searched Microsoft and other sites and don't see a lot of discussion
about
| deadlocks on thread | communication buffer resources.
|
| Any help would be greatly appreciated.
|
| Doug
|
by