how does the multi-master Problem happen ?

[amiens80]

hi,

i saw in many topics about sudden shutdown mysql, that multi-master Problem is possible the problem.

Thanks for providing detailed debug information.
I call this the multi-master error. Your MariaDB thinks it is running in master replicant setting.

Please try the following fix. It already helped lots of users solving the multi-master Problem:

• Open your folder "\xampp\mysql\data"
• Delete the file "multi-master.info"
• Delete all files beginning with "master-"
• Delete all files beginning with "mysql_relay-bin-"
• Delete all files beginning with "relay-log-"

Now try to start mariadb the normal way again.

best wishes,
Altrea

does anybody have a clue how or why it happens ?
In my case, i did 2 bad things (i think) :
- forgot to stop mysql process , then stop apache before switch off my computer
- open phpmyadmin on the same database in two different browsers (i need that to work on many query and phpmysql only have one tab !, so i open twice the localhost/phpmyadmin)

was one of my behavior the cause of the multi-master Problem ?


Best regards

[Altrea]

Hi,

The true problem is unclear. There are three different problems that all seems to be related with the unclean MariaDB shutdown XAMPP uses.
These Problems doesn't seem to happen if MariaDB is started and stopped by a windows service.

[amiens80]

hi,


the problem appears again, i still do not know why.
but this time, i'm sure i correctly close/stop mysql server by the xamp button before switch down my computer.