MySQL shutting down daily
MySQL is shutting down/crashing everyday at 0000hrs. I am not aware what has caused this issue, but this started about a week back. I have to do a Graceful Reboot to normalise services. I am getting a mail everyday as per below :
SUBJECT : [mysqlconnectioncheck] Authentication Failed, and could not reset the MySQL server root password.
The system was unable to authenticate to the local MySQL server on "localhost".
The connection driver reported the following error: Access denied for user 'root'@'localhost' (using password: YES)
The error reported by the reset attempt was: The subprocess reported the "" (72057594037927935) error when it ended. The process dumped a core file.
The system was unable to automatically reconnect to the MySQL server.
You must manually update the password in "/root/.my.cnf" in order to restore normal operations.
I have Reset MySQL password using WHM. Also as per the above mail, updated password in /root/.my.cnf, but it did not work. I just check the .my.cnf file and the password has changed to something else. Also, If I restart MySQL from Restart Services option in WHM, It shows the following log.
If I am trying to Create an Account in Cpanel using a reseller account, it gives the following error : Account Creation Status: failed The MySQL service is down. Help would be appreciated. Thanks, Saurabh.
I have Reset MySQL password using WHM. Also as per the above mail, updated password in /root/.my.cnf, but it did not work. I just check the .my.cnf file and the password has changed to something else. Also, If I restart MySQL from Restart Services option in WHM, It shows the following log.
Log Messages
150217 6:35:04 [Note] /usr/sbin/mysqld: ready for connections.
150217 06:35:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150217 06:35:02 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
150217 6:35:02 [Note] /usr/sbin/mysqld: Shutdown complete
150217 6:35:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 104 user: 'eximstats'
150217 6:34:59 [Note] /usr/sbin/mysqld: Normal shutdown
150217 6:03:17 [Note] /usr/sbin/mysqld: ready for connections.
150217 06:03:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150217 00:20:06 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
150217 0:20:06 [Note] /usr/sbin/mysqld: Shutdown complete
150217 0:20:04 [Warning] /usr/sbin/mysqld: Forcing close of thread 62 user: 'eximstats'
150217 0:20:04 [Warning] /usr/sbin/mysqld: Forcing close of thread 19294 user: 'leechprotect'
150217 0:20:02 [Note] /usr/sbin/mysqld: Normal shutdown
150215 6:35:14 [Note] /usr/sbin/mysqld: ready for connections.
150215 06:35:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150215 00:18:58 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
150215 0:18:58 [Note] /usr/sbin/mysqld: Shutdown complete
150215 0:18:57 [Warning] /usr/sbin/mysqld: Forcing close of thread 8 user: 'eximstats'
150215 0:18:57 [Warning] /usr/sbin/mysqld: Forcing close of thread 7183 user: 'leechprotect'
150215 0:18:55 [Note] /usr/sbin/mysqld: Normal shutdown
150214 10:46:30 [Note] /usr/sbin/mysqld: ready for connections.
150214 10:46:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150214 10:44:20 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
150214 10:44:19 [Note] /usr/sbin/mysqld: Shutdown complete
150214 10:44:18 [Warning] /usr/sbin/mysqld: Forcing close of thread 45 user: 'eximstats'
150214 10:44:18 [Warning] /usr/sbin/mysqld: Forcing close of thread 1873 user: 'leechprotect'If I am trying to Create an Account in Cpanel using a reseller account, it gives the following error : Account Creation Status: failed The MySQL service is down. Help would be appreciated. Thanks, Saurabh.
-
Hello, You will have to monitor your server with the top and ps aufx command, May be due to insufficient memory, you are getting this issues. So please monitor it and try to optimize your MySQL with [url=http://mysqltuner.com/]MySQLTuner-perl by major scripts. 0 -
Hello :) What error message do you see in /var/lib/mysql/$hostname.err when attempting to create an account or restart MySQL? Thank you. 0
Please sign in to leave a comment.
Comments
2 comments