[CubsFan1060]

https://microservices.io/patterns/data/transactional-outbox....

It allows you to wrap it all in a transaction. If you separate a database update and insertion into a queue, whichever happens second may fail, while the first succeeds.

[illusive4080]

Tell the alternative is a saga pattern to implement a distributed two phase commit.

Or actual XA, but that is cursed.