how does the multi-master Problem happen ?
Posted: 14. November 2023 11:12
hi,
i saw in many topics about sudden shutdown mysql, that multi-master Problem is possible the problem.
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
i saw in many topics about sudden shutdown mysql, that multi-master Problem is possible the problem.
Altrea wrote:
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