BUG: Simultaneous DTC Operations May Cause SPID to Stop Responding (258238)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q258238
BUG #: 57639(SQLBUG_70)

SYMPTOMS

SQL Server allows multiple connections, identified by their system process id (SPID), to enlist in the same Microsoft Distributed Transaction Coordinator (MS DTC) transaction. SQL Server limits active operations to a single SPID. Simultaneous operation attempts result in the following 3910 error message:
Error 3910: Transaction context in use by another session.
When the SPID attempts to engage (propagate) in the same transaction, the SPID can go to sleep and not be alerted by another thread.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

256649 FIX: Simultaneous DTC Operations May Cause Errors

WORKAROUND

Correct the application logic to avoid the 3910 error message.

You can use the T-SQL Kill command to terminate the processes that are not responding.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB258238
©2002 Microsoft Corporation. All rights reserved.