Clean install of MariaDB via EE will not restart


#1

I have a clean Ubuntu 14.04 install and a clean Easyengine stack install. The database is large due to 3,000+ subdomain WordPress sites but they are essentially empty because the sites have not been used yet. The problem I am experiencing is MariaDB will not restart. The error log says that mysql was not properly stopped and the ibdata1 was now out of sequence. Therefore, mysql start was aborted. I have used sudo service mysql stop, sudo service mysql restart, sudo ee stack stop --mysql and sudo ee stack restart --mysql. None of these are considered proper shutdown by MariaDB. Even rebooting doesn’t work. This seems to be a bug in MariaDB because there is nothing on the server that would be causing this problem being it’s a clean install across the board. Has anyone else experienced this issue and, if so, how was it resolved?


#2

Hello @macpooh12,

Look like it was because your MariaDB was not properly stopped.

Can you give us MariaDB error log, so that we can give you exact solution.


#3

Thanks for the reply. Currently there is nothing in the error logs to show you because they have been rotated out. But that is what I am asking, I know that is going to come a time when the server will go down or I will have to reboot or I will have to make a configuration change to my.cnf which will require a mysql restart. I need to know what MariaDB considers a proper shutdown. As I have said I have tried all of the following and none have worked:

  • sudo service mysql stop
  • sudo service mysql restart
  • sudo ee stack stop --mysql
  • sudo ee stack restart --mysql
  • sudo reboot

If there is another way to properly shutdown mysql, I am not aware of it.


#4

Hi @macpooh12

Please try the latest EasyEngine. Use ee update to upgrade your current EasyEngine version to the latest.

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


#5