Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What are the implications of the error “The transaction is in doubt” Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 6:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 1:24 AM
Points: 268, Visits: 876
One of our applications has reported the error in the ADO.NET stack “The transaction is in doubt” when the SQL Server was under heavy load. I've read around this area and I'm confused!

Some sources seem to say this is purely an MSDTC error within a system transaction, and that the database transaction will have either completed or rolled back. It's just that MSDTC doesn't know which it was (in other words, my database is still internally consistent).

However I also read this article: http://technet.microsoft.com/en-us/library/ms179586.aspx

This seems to say that in doubt transactions will remain in my database and should I restart SQL Server it will fail to recover (by default) although it explains how I can change that.

I've never had this error before. Can anyone offer any more details on what it means and whether I need to take any corrective actions please?

Thanks in ancipation

Tim Walker


.
Post #1521864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse