BUG: Simultaneous DTC Operations May Cause SPID to Stop Responding (258238)
The information in this article applies to:
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: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB258238 |
|---|
|