[rabbitmq-discuss] is anybody using tx?

Tue Jun 28 19:48:33 BST 2011

On Tue, Jun 28, 2011 at 3:25 AM, Matthias Radestock
<matthias at rabbitmq.com> wrote:
>> My message consumers are idempotent and always check object status in
>> RDBMS before processing messages, so should I fail to commit to RDBMS
>> after having committed to RabbitMQ, those messages will be ignored.
>
> Idempotence is certainly a good thing.
>
> How does the "check object status before processing" work? Couldn't a
> consumer get the message(s) before the rdbms transaction has committed, thus
> not see the up to date status and erroneously ignore the message?

You can do this with some nasty and slow serialized database locks.
We've done something similar to this in the past but it always makes
me question when we are doing something akin to this if RabbitMQ is
the right solution for this particular problem.

We don't use RabbitMQ transactions.  They were too slow and we ended
up having to build other higher level abstractions anyway so they
really aren't all that useful for us.

Bryan