Miloš Srnić
unread,Nov 24, 2023, 7:16:45 AM11/24/23Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.