Please read the Introduction before reading this provider documentation.
The Host.Outbox introduces Transactional Outbox pattern to the SlimMessageBus.
It comes in two flavors:
Host.Outbox.Sqlas integration with the System.Data.Sql client (MSSQL)Host.Outbox.Sql.DbContextas integration with Entity Framework Core
Outbox plugin can work in combination with any transport provider.
Required:
SlimMessageBus.Host.Outbox.Sql.DbContext
using SlimMessageBus.Host.Outbox.Sql.DbContext;Consider the following example (from Samples):
services.AddOutboxUsingDbContext<CustomerContext>(...)is used to add the Outbox.DbContext plugin to the container.CustomerContextis the application specific Entity FrameworkDbContext.CustomerCreatedEventis produced on theAzureSBchild bus, the bus will deliver these events via outbox - see.UseOutbox()CreateCustomerCommandis consumed on theMemorychild bus, each command is wrapped in an SQL transaction - seeUseSqlTransaction()
Startup setup:
@:cs
Command handler:
@:cs
Required:
SlimMessageBus.Host.Outbox.Sql
using SlimMessageBus.Host.Outbox.Sql;Consider the following example:
services.AddMessageBusOutboxUsingSql(...)is used to add the Outbox.Sql plugin to the container.SqlConnectionis registered in the container
builder.Services.AddSlimMessageBus(mbb =>
{
// Alternatively, if we were not using EF, we could use a SqlConnection
mbb.AddOutboxUsingSql(opts => { opts.PollBatchSize = 100; });
});
// SMB requires the SqlConnection to be registered in the container
builder.Services.AddTransient(svp =>
{
var configuration = svp.GetRequiredService<IConfiguration>();
var connectionString = configuration.GetConnectionString("DefaultConnection");
return new SqlConnection(connectionString);
});Required:
SlimMessageBus.Host.Outbox
using SlimMessageBus.Host.Outbox;.UseOutbox() can be used on producer declaration to require outgoing messages to use the outbox.
When applied on the (child) bus level then all the producers will inherit that option.
Each consumer (or handler) can be placed inside of an SQL transaction. What that means is that when a consumer processes a message, an transaction will be started automatically by SMB, then if processing is successful that transaction will get committed. In the case of an error it will be rolled back.
The transactions can be nested. For example a consumer (e.g. Azure SB) invokes a command handler (e.g. Memory) and they both have transactions enabled, then the underlying transaction is committed when both consumers finish with success.
There are two types of transaction support:
Required:
SlimMessageBus.Host.Outbox
using SlimMessageBus.Host.Outbox;.UseTransactionScope() can be used on consumers (or handlers) declaration to force the consumer to start a TransactionScope prior the message OnHandle and to complete that transaction after it. Any exception raised by the consumer would cause the transaction to be rolled back.
When applied on the (child) bus level then all consumers (or handlers) will inherit that option.
Required:
SlimMessageBus.Host.Outbox.SqlorSlimMessageBus.Host.Outbox.Sql.DbContext
using SlimMessageBus.Host.Outbox.Sql;.UseSqlTransaction() can be used on consumers (or handlers) declaration to force the consumer to start a SqlTransaction prior the message OnHandle and to complete that transaction after it. Any exception raised by the consumer would cause the transaction to be rolled back.
When applied on the (child) bus level then all consumers (or handlers) will inherit that option.
SqlTransaction-s are created off the associated SqlConnection.
-
Outbox plugin uses the interceptor interface to tap into the relevant stages of message processing.
-
Upon bus start the
OutboxSQL table is created (if does not exist). The name of the table can be adjusted via settings. -
When a message is sent via a bus or producer marked with
.UseOutbox()then such message will be inserted into theOutboxtable. It is important that message publish happens in the context of an transaction to ensure consistency. -
When the message publication happens in the context of a consumer (or handler) of another message, the
.UseTransactionScope(),.UseSqlTransaction()can be used to start a transaction. -
The transaction can be managed by the application, starting it either explicitly using
DbContext.Database.BeginTransactionAsync()or creating aTransactionScope(). -
On the interceptor being disposed (at then end of a message lifecycle), the outbox service will be notified that a message is waiting to be published if at least one messages was placed in the outbox during the message processing lifetime. Alternatively, on expiry of the
PollIdleSleepperiod following outbox processing, the same process will be initiated. -
If the configuration setting
MaintainSequenceis set totrue, only one application instance will be able to lock messages for delivery. This ensure messages are delivered in the original order to the service bus at the expense of delivery throughput. Iffalse, each distributed instance will place an exclusive lock onPollBatchSizemessages for concurrent distribution. This will greatly increase throughput at the expense of the FIFO sequence. -
If a service instance where to crash or restart, the undelivered messages will be picked and locked by another instance.
-
Once a message is picked from outbox and successfully delivered then it is marked as sent in the outbox table.
On starting SMB, messages that are older than MessageCleanup.Age will be removed from the Outbox table in batches of MessageCleanup.BatchSize until no sent messages of the specified age remain. The process is then repeated every MessageCleanup.Interval period.
| Property | Description | Default |
|---|---|---|
| Enabled | True if messages are to be removed |
true |
| Interval | Time between exections | 1 hour |
| Age | Minimum age of a sent message to delete | 1 hour |
| BatchSize | Number of messages to be removed in each iteration | 10 000 |
As the outbox can be processed by instance of the application that did not originally process it, it is important to ensure that all active instances maintain the same message registrations (and compatible JSON schema definitions).
A message that fails to deserialize will be flagged as invalid by setting the associated DeliveryAborted field in the Outbox table, to 1. It is safe to manually reset this field value to 0 once the version incompatibility has been resolved.