C# – The transaction has aborted

cnetsql serversql-server-2005

I have a multithreaded C# application where each thread has it's own set of db connections. Each thread uses TransactionScope / DTC. Sometimes, I get a "The transaction has aborted" exception. It's not from a timeout since it occurs in less than 2 seconds from starting the transaction.

Here's the stacktrace:

at
System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction
tx, Boolean asyncCommit, AsyncCallback
asyncCallback, Object asyncState) at
System.Transactions.CommittableTransaction.Commit()
at
System.Transactions.TransactionScope.InternalDispose()
at
System.Transactions.TransactionScope.Dispose()
at MyNamespace.CallingMethod()

It happenes very infrequently, say once in 100,000 transactions.

Environment:
Windows Server 2003
.Net 2.0
Connects to SqlServer 2005

Any ideas on why this is occuring?
Thanks!

Best Answer

Is this call stack from your inner-most InnerException? I you get this exceptions, there is usually (not always, though) an InnerException with more info.

My bet would be on a database deadlock.

Related Solutions

C# – the difference between String and string in C#

string is an alias in C# for System.String.
So technically, there is no difference. It's like int vs. System.Int32.

As far as guidelines, it's generally recommended to use string any time you're referring to an object.

e.g.

string place = "world";

Likewise, I think it's generally recommended to use String if you need to refer specifically to the class.

e.g.

string greet = String.Format("Hello {0}!", place);

This is the style that Microsoft tends to use in their examples.

It appears that the guidance in this area may have changed, as StyleCop now enforces the use of the C# specific aliases.

C# – Calling the base constructor in C#

Modify your constructor to the following so that it calls the base class constructor properly:

public class MyExceptionClass : Exception
{
    public MyExceptionClass(string message, string extrainfo) : base(message)
    {
        //other stuff here
    }
}

Note that a constructor is not something that you can call anytime within a method. That's the reason you're getting errors in your call in the constructor body.

Best Answer

Related Solutions

C# – the difference between String and string in C#

This is the style that Microsoft tends to use in their examples.

C# – Calling the base constructor in C#

Related Topic