<div dir="ltr"><div>1) No clue. But would be interested if you have an idea what have gone wrong.</div><div><br></div><div>2) <span style="line-height:1.5">mnesia:del_table_copy(...) followed by mnesia:add_table_copy(..) should re-copy the table from the other nodes.</span></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Apr 26, 2016 at 9:30 PM Daniel Dormont <<a href="mailto:dan@greywallsoftware.com">dan@greywallsoftware.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
<br>
I have a three node Mnesia cluster (hosting a somewhat outdated<br>
version of ejabberd, but I'm not sure that matters). I have a table<br>
that is stored as ram_copies on all three nodes. Yet, this table has<br>
differing numbers of records among the three.<br>
<br>
The table info from one of them is pasted below. Running the same<br>
query on one of my other nodes, I get more or less the same result,<br>
but the "size" is very different: 553 vs 867. And indeed, there are<br>
individual records that turn up in a mnesia:read/2 or<br>
mnesia:dirty_read/2 on one node and not the other.<br>
<br>
Yet, nothing in my log indicates that there was ever a netsplit or<br>
disconnection. So I have two questions:<br>
<br>
1) What might cause this? and<br>
2) Is there any way, especially given I know which records are<br>
affected, to force some kind of replication on this table without<br>
completely restarting one of the nodes?<br>
<br>
thanks,<br>
Dan Dormont<br>
<br>
<br>
[{access_mode,read_write},<br>
{active_replicas,['<a href="mailto:ejabberd@chat-03.ec2-int.veoci.com" target="_blank">ejabberd@chat-03.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-01.ec2-int.veoci.com" target="_blank">ejabberd@chat-01.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-02.ec2-int.veoci.com" target="_blank">ejabberd@chat-02.ec2-int.veoci.com</a>']},<br>
{all_nodes,['<a href="mailto:ejabberd@chat-03.ec2-int.veoci.com" target="_blank">ejabberd@chat-03.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-02.ec2-int.veoci.com" target="_blank">ejabberd@chat-02.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-01.ec2-int.veoci.com" target="_blank">ejabberd@chat-01.ec2-int.veoci.com</a>']},<br>
{arity,3},<br>
{attributes,[name_host,pid]},<br>
{checkpoints,[]},<br>
{commit_work,[]},<br>
{cookie,{{1341,344810,207763},'<a href="mailto:ejabberd@10.86.211.63" target="_blank">ejabberd@10.86.211.63</a>'}},<br>
{cstruct,{cstruct,muc_online_room,set,<br>
['<a href="mailto:ejabberd@chat-03.ec2-int.veoci.com" target="_blank">ejabberd@chat-03.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-02.ec2-int.veoci.com" target="_blank">ejabberd@chat-02.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-01.ec2-int.veoci.com" target="_blank">ejabberd@chat-01.ec2-int.veoci.com</a>'],<br>
[],[],0,read_write,false,[],[],false,muc_online_room,<br>
[name_host,pid],<br>
[],[],[],{...},...}},<br>
{disc_copies,[]},<br>
{disc_only_copies,[]},<br>
{frag_properties,[]},<br>
{index,[]},<br>
{load_by_force,false},<br>
{load_node,'<a href="mailto:ejabberd@chat-vpc-06.ec2-int.veoci.com" target="_blank">ejabberd@chat-vpc-06.ec2-int.veoci.com</a>'},<br>
{load_order,0},<br>
{load_reason,{active_remote,'<a href="mailto:ejabberd@chat-vpc-06.ec2-int.veoci.com" target="_blank">ejabberd@chat-vpc-06.ec2-int.veoci.com</a>'}},<br>
{local_content,false},<br>
{majority,false},<br>
{master_nodes,[]},<br>
{memory,73643},<br>
{ram_copies,['<a href="mailto:ejabberd@chat-03.ec2-int.veoci.com" target="_blank">ejabberd@chat-03.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-02.ec2-int.veoci.com" target="_blank">ejabberd@chat-02.ec2-int.veoci.com</a>',<br>
'<a href="mailto:ejabberd@chat-01.ec2-int.veoci.com" target="_blank">ejabberd@chat-01.ec2-int.veoci.com</a>']},<br>
{record_name,muc_online_room},<br>
{record_validation,{muc_online_room,3,set}},<br>
{type,set},<br>
{size,867},<br>
{snmp,[]},<br>
{storage_properties,...},<br>
{...}|...]<br>
_______________________________________________<br>
erlang-questions mailing list<br>
<a href="mailto:erlang-questions@erlang.org" target="_blank">erlang-questions@erlang.org</a><br>
<a href="http://erlang.org/mailman/listinfo/erlang-questions" rel="noreferrer" target="_blank">http://erlang.org/mailman/listinfo/erlang-questions</a><br>
</blockquote></div>