maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "Galera" by uxbod:
--------------------------------
We have MariaDB and Galera working in our lab on a three node cluster.  When setting them up the wsrep options for each node were as follows:

{{{
node1: wsrep_cluster_address="gcomm://"
node2: wsrep_cluster_address="gcomm://172.30.1.3"
node3: wsrep_cluster_address="gcomm://172.30.1.1"
}}}

Once all the nodes were in sync I shutdown node1 and set its wsrep_cluster_address to be 172.30.1.2.  This I thought would allow the three nodes to keep in sync.  What happened though was when I started MariaDB backup I received the error:

{{{
130702  8:35:51 [ERROR] WSREP: Local state seqno (16053) is greater than group seqno (15898): states diverged. Aborting to avoid potential data loss. Remove '/var/lib/mysql//grastate.dat' file and restart if you wish to continue. (FATAL)
         at galera/src/replicator_str.cpp:state_transfer_required():34
}}}

Why has this happened ? Is it safe to proceed with the recommendation of removing grastate.dat ?
--------------------------------

To view or answer this question please visit: http://kb.askmonty.org/en/local-state-seqno-out-of-sync-with-group/