Bug #55649 | cpanel error: "mysql has failed. ... a restart was attempted automagically" | ||
---|---|---|---|
Submitted: | 30 Jul 2010 13:18 | Modified: | 11 Aug 2010 10:48 |
Reporter: | Leon LaSpina | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.91 | OS: | Linux (CentOS on a VPS) |
Assigned to: | CPU Architecture: | Any | |
Tags: | cpanel, failed, restart |
[30 Jul 2010 13:18]
Leon LaSpina
[30 Jul 2010 13:23]
Valeriy Kravchuk
Please, upload the entire error log of your MySQL server. Usually this is <hostname>.err file in the data directory.
[1 Aug 2010 9:04]
Leon LaSpina
This is the error log file (error.log) which confirms that the service is stopping and restartig.
Attachment: error.zip (application/x-zip-compressed, text), 55.60 KiB.
[1 Aug 2010 9:20]
Valeriy Kravchuk
As far as I can see from the error log: 100730 21:53:16 [Note] /usr/sbin/mysqld: Shutdown complete 100730 21:53:24 mysqld started 100730 21:53:24 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.91-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 100731 21:53:04 [Note] /usr/sbin/mysqld: Normal shutdown 100731 21:53:04 [Note] /usr/sbin/mysqld: Shutdown complete 100731 21:53:04 mysqld ended 100731 21:53:09 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.91-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 100731 21:53:15 [Note] /usr/sbin/mysqld: Normal shutdown 100731 21:53:15 [Note] /usr/sbin/mysqld: Shutdown complete 100731 21:53:23 mysqld started 100731 21:53:23 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.91-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) there are regular normal(!) restarts every day around 21:53. Maybe they are initiated by some cron job or cpanel software. In any case, I see no problems from MySQL server side: it got a request to shut down and then was started again, cleanly.
[9 Aug 2010 12:24]
Leon La Spina
This is not a normal daily restart at all. The restart is triggered by loading any web page from the server and can occur at any time. If I download the home page from the web server 100 times, I get 100 re-start messages! The real problem is that MySQL doesn't work at all. I cannot get into it through the command line because although a password was never assigned, it acts as if there is one set that I don't know. Through cpanel it looks like you can create a MySQL database. But after you create it, nothing shows up.
[11 Aug 2010 10:49]
Sveta Smirnova
Thank you for the feedback. But error log does contain only "Normal shutdown" records. If this happens every time you load web page this means this is web application sends shutdown request. Please check and fix your application.
[11 Aug 2010 11:08]
Leon La Spina
Here is where this error gets even more odd: While I still cannot get into mySQL through the linux command line, I was able to create a database and a DB user through the web interface WHM. My cPanel license must have expired, so I'm not able to easily get in now and use PHPmyAdmin for instance to start creating tables and such. And here's the kicker...the error messages went away. This doesn't mean its working. I still cannot access the mysql database I created through the command line or any other means. I have no web applications running, other than Tomcat demos.