MassTransit with Azure Service Bus joins a SQL Server Transaction Scope and throws errors

Question

I am executing a series of SQL Inserts from a MassTransit Handler. I create a Transaction Scope, so all Inserts pass or fail. Works with zero issues when RabbitMQ is the Bus.

On switching to Azure Service Bus, introducing a Transaction Scope for SQL Server is a problem for Azure Service Bus, who hooks into it and will not let go.

Errors thrown

Require IsolationLevel.Serializable
Local transactions are not supported with other resource managers/DTC

In any case the code in not working anymore with the Trnx Scope set as it was.

I had to Suppress the Transaction Scope to get the code to work, but that is not the solution.

I want to know how to prevent Azure Service Bus from engaging in a Transaction Scope explicitly meant for SQL Server - do not assume things.

Is there a way to signal Service Bus from MassTransit not to engage in the SQL Transaction scope?

I am sure others have run into this - look forward to the solutions.

please the code in text /link you tried in the above question. — P Sampath
– P Sampath, Commented Aug 9, 2024 at 3:35

Jesse Squire · Accepted Answer · 2024-08-11 16:52:53Z

1

I believe the following will prevent Service Bus from participating in the ambient transaction:

using (var ts = new TransactionScope(TransactionScopeOption.Suppress, TransactionScopeAsyncFlowOption.Enabled))
{
    // Example Service Bus operation
    await _sender.SendMessageAsync(...)
}

see: (GitHub) Errant use of TransactionScope causes messages to be silently dropped

answered Aug 11, 2024 at 16:52

Jesse Squire

8,2121 gold badge31 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MassTransit with Azure Service Bus joins a SQL Server Transaction Scope and throws errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related