MassTransit Transactional Outbox Isolation Level per Consumer

Question

I have a consumer where I begin a serializable transaction.

public class Consumer : IConsumer<Message>
{
        public async Task Consume(ConsumeContext<Message> context)
        {
            using var transaction = dbContext.Database.BeginTransaction(System.Data.IsolationLevel.Serializable);
            
            // Do Something

            transaction.Commit();
        }
}

I'm trying to use the new MassTransit Transactional Outbox, but with the outbox configured I can't open this inside transaction because all consumers become wrapped in a transaction and it doesn't allow nested transactions.

One way that I see to solve this is changing the outbox transaction isolation level to serializable so I don't need to open this one inside the consumer, but I don't want to change the isolation level on all my outbox consumers.

Is there a way to configure the outbox transaction isolation level per consumer?

If not, is there another way I could to solve this?

I figured out how to change the isolation level for all the outbox consumers, but didn't find how to change it individually.

Chris Patterson · Accepted Answer · 2023-01-18 00:52:30Z

1

You can configure the IsolationLevel by adding and configuring the options as shown below:

services.AddOptions<EntityFrameworkOutboxOptions>()
    .Configure(options => options.IsolationLevel = IsolationLevel.Serializable);

answered Jan 18, 2023 at 0:52

Chris Patterson

34.1k4 gold badges58 silver badges74 bronze badges

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

2 Comments

JoaoVelho Over a year ago

Sorry, but I don't see how I could change the isolation level from an specific consumer using this setting. Could you give me an example, please? I have other consumers in my app that I would like the isolation level to be RepeatableRead and only a few of them to be Serializable. EDIT: And I'm using Masstransit version 8.0.6

Chris Patterson Over a year ago

You can't change it per-consumer, it's a container-wide configuration setting that would apply to all consumers.

Collectives™ on Stack Overflow

MassTransit Transactional Outbox Isolation Level per Consumer

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related