Galera, problem with grastate.dat and gvwstate.dat values

34 views
Skip to first unread message

Miloš Srnić

unread,
Nov 24, 2023, 7:16:45 AM11/24/23
to codership
Hi all,

i am running Galera Mariadb cluster with 3 nodes for 8 or 9 months without any problems. Few days ago i restarted mariadb on one ot the nodes, and it wouldn't start again. I got all kinds od errors about SST failiing, and that the values in gvwstate.dat file are not ok, then the errors that the file is not there, not reachable and so on. 

At the end, when clean start didn't work, i realised the problem was in the binlog files in the /var/lib/mysql directory. 

My new cluster is up and running, i imported 20GB database without problems, when i check every possible wsrep command on all 3 nodes, everything is perfect. Synced, primary, 3 nodes, no latency, no issues. 

But i still don't understand the grastate.dat file. In all 3 files seqno is -1, and UUID is the same. In gvwstate.dat file i see all 3 members with different IDs, but the boostrap is 0 on all 3 nodes. 
Thanks for all the help, will be happy to provide any additional info.

Reply all
Reply to author
Forward
0 new messages