False SQL Deadlock Messages?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Neal Walters (NealWalters_at_discussions.microsoft.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 11:35:01 -0800

We started getting large number of deadlock messages on some rather simple
SQL receive ports. It has been in production for six weeks without problems.

To complicate matters the event log message, shown below, shows the schema
name of our "JumpStart" schema, but it does not tell the URI or the
ReceivePort causing the problem. We have about 10 receive ports that all use
the same schema, so know the schema doesn't help narrow down which port is
causing the problem (or is it all of them?).

We have about 10 Jumpstart receive locations that poll the database roughly
every 30 seconds. We use this to schedule our orchestrations at certain
times of day.
Our volume is VERY low, so we are doubting how there could be deadlocks, and
why they started appearing in our log of all a sudden yesterday. We did
have some SQL connectivity problems yesterday, but they seem to be gone now.

Here is the event log message:

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 12/16/2004
Time: 2:03:43 PM

Description:
The adapter "SQL" raised an error message. Details "<?xml version="1.0"
encoding="utf-16" ?><JumpStart
xmlns="http://Odimo.com/Amazon/JumpStart"><?MSSQLError HResult="0x80004005"
Source="Microsoft OLE DB Provider for SQL Server" Description="Transaction
(Process ID 51) was deadlocked on lock resources with another process and has
been chosen as the deadlock victim. Rerun the transaction."?></JumpStart>".

The stored proc basically finds any rows in a scheduling table where the
date-processed is NULL and the matching orchestration name is found. It
also looks up some basic parameter data and returns it.

Thanks for any ideas,
Neal Walters - http://Biztalk-Training.com - Free Biztalk Videos

Relevant Pages

  • Re: SQL Server
    ... >> SQL Service manager shows that \\LAPTOP\PALSOFT - MSSQLServer is running. ... Antivirus is Sophos ... > allows you to check connectivity to ports. ... And it looks like you can in fact get the server manger status ...
    (uk.rec.motorcycles)
  • Re: URGENT deadlock question
    ... I have a deadlock template that I use with the following ... > SQL: Statement Completed ... > "Trace flags remain enabled in the server until disabled by executing ...
    (microsoft.public.sqlserver.server)
  • Re: OO vs. RDB challenge
    ... You've shifted thread-saftey and deadlock prevention to the client, ... SQL can surely do ... Fix yours. ... > 3) have developers that write perfect software ...
    (comp.object)
  • Re: OO vs. RDB challenge
    ... >>More broken code, Kurt? ... expression in SQL queries. ... users can sometimes deadlock each other by requiring access to ... cause the mechanism to write perfect software ...
    (comp.object)
  • Re: Analyzing Error log with Trace Flag 1204 turned on
    ... I have read the appropriate section out of Inside SQL ... up to a deadlock only from the spids involved in the deadlock? ... > resources in Inside SQL Server 2000, and in my ebook on Troubleshooting ... Are they locks currently held or ...
    (microsoft.public.sqlserver.server)