[erlang-questions] Mnesia is restarting transactions for a long time.

[Karolis Petrauskas]

Hello,

I have a system of two Erlang nodes, that use a clustered mnesia. Sometimes
startup of the database takes very long (tens of minutes). After enabling
mnesia event logging I see the following message repeated:

    mnesia_system_event:mnesia_info:
        Restarting transaction {tid,143589,<0.1351.0>}: in 10ms
        {cyclic,
            'some-node@REDACTED',
            {schema,'______WHOLETABLE_____'},
            write,write,{tid,143588,<0.1333.0>}
        }

After a second I am getting the following event:

    Sync serial {tid,143589,<0.1351.0>}

And then "Restarting transaction" events are repeated with increasing time
intervals. TID is remaining the same.

How to determine, why the transaction cannot be restarted. What can I do to
to avoid such situations or how to recover from them.

I have set {max_wait_for_decision, 300000} (5 min) for Mnesia as well as
{auto_repair, true} in sys.config.

Karolis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20160816/3e172658/attachment.htm>