Hi,
We had an unexplained crash today with one PXDBC node 5.5.28, the mysqld process crashed and then the server cannot be restarted without crashing and crashing after each restart, I don't have any idea what is the cause of this crash since we restarted the server this morning (around 9.30am) and everything was fine, the crash occured at 11.02am as you can see in the full error-log provided in attachement.
After this crash, we tried to restart the server 3 or 4 times but it crashed after a few seconds online, finally we tried to disabled wsrep_provider and set it to 'none', then the server finally stayed online and checked for crashed table, so I don't really know if wsrep_provider change was the solution to make it restarting without crash or if it was a coincidence ? For the moment, we ran a full mysqlcheck on all databases to see if everything is OK and it's still runing, so the server is still running with wsrep_provider = none for the moment.
Furthermore, it is needed to indicate that this server is :
1. not a production one but development environnement hosting approximatly 130 databases for a dataset of ~50GB.
2. a single node only (wsrep_provider enabled but gcomm://) and there is no other nodes, we use it only to have the same environnment as our future production environnment.
Is there a way to get some more informations on the cause if possible by analyzing the informations provided by mysqld when it crashed ? If yes how to do this please ?
Thanks for your help and informations.
Regards,
Laurent