[rabbitmq-discuss] mnesia tables

[Alain Dazzi]

On Wed, May 11, 2011 at 5:15 AM, Emile Joubert <emile at rabbitmq.com> wrote:

> Hi Alain,
>
>
> On 11/05/11 00:44, Alain Dazzi wrote:
>
>> Hi,
>>
>> I was wondering if anyone had a procedure to connect to running
>> rabbitmq node and read/extract mnesia records using erlang. For the
>> lack of such tool, I use grep to try to find stuck messages in the
>> various queues (cd /var/lib/rabbitmq/mnesia/...node.../ and grep one
>> of the queues).
>>
>
> The mnesia table layout could change in the future, so it would be
> dangerous to rely on that. "rabbitmqctl list_queues" or the management &
> monitoring plugin is a better way of inspecting queues. Do you need
> additional information not displayed by these tools?
>
> -Emile
>

The monitoring plugin and rabbitmqctl utility are great tools! However those
tools only tell me that for instance n messages are in the queue (in a
certain state).  I am debugging a case where we have 4 messages (financial
transactions) that are stuck in the queue in un-Acked state. Without some
type of messageId or transactionID, I have to look directly at mnesia file
system and try to find my data. It would be nice to be able to dump the
records to analyse the data in the various queues (kind of a mysqldump that
would be legible).

Thanks!

-Alain
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rabbitmq.com/pipermail/rabbitmq-discuss/attachments/20110511/5a9665cd/attachment-0001.htm>