The Ultimate Guide to High Availability with MariaDB

Local state seqno out of sync with group

You are viewing an old version of this question. View the current version here.

Monty Program has What is MariaDB 5.5? and MariaDB vs. MySQL whitepapers available for download.

This is the main Knowledgebase category for MariaDB.

Follow any of the links below to find information on the topics you are interested in. If you would like to know more about anything that isn't documented, ask a question at the place where the answers should be and we will do our best to provide an answer for it!

Answer Answered by Alex yurchenko in this comment.

It is impossible to diagnose what happened here without full logs from the node in question and at least one node from the cluster. Most likely you did not exactly what you described, maybe in a subtle and non-obvious way.

It is safe to proceed with removing grastate.dat in a sense that the node will join the cluster and synchronize with it by copying the state with seqno 15898. However you will lose the 155 extra transactions that you have there now.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.