Microsoft KB Archive/258238

= BUG: Simultaneous DTC Operations May Cause SPID to Stop Responding =

Article ID: 258238

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Keywords: kbbug kbpending KB258238

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.