MySQL Bugs: #55649: cpanel error: "mysql has failed. ... a restart was attempted automagically"

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:	None
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

Description:
Every time a web page is downloaded from my web server, cpanel throws a mysql error.  mysql is installed along with cpanel and tomcat, but the web server does not have any pages yet that use mysql.  Yet every page request generates the error " "mysql has failed @ [timestamp].  A restart was attempted automagically."  

Through cpanel, I tried to create a database and a database user.  While cpanel did not indicate an error, it failed to create the database.  So I have no databases running and about 1000 database errors.  What is going on?

How to repeat:
Go to http://laspina.opticgrid.com/~nciml/ and the error will again land in my in-box.

To re-create my environment, you would need to set up a Virtual Private Server.

Please, upload the entire error log of your MySQL server. Usually this is <hostname>.err file in the data directory.

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.

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.

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.

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.

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.