The Server quit without updating PID file MySQL RESTART ERROR

Are you interested for monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more ? please check our Monthly server support plans

The server quit without updating PID file MySQL RESTART ERROR

This error may happens while restarting msql service,

Also you can see the error ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists while checking the status of mysql.

In this case you just need to remove the lock file /var/lock/subsys/mysql then try restarting the mysql service again,

Sometimes you will again see an error The server quit without updating PID file. This time you need to locate the mysql process and kill it.

Then restart mysql service again,

[email protected] [~]# /etc/init.d/mysql start
Starting MySQL.. SUCCESS!
[email protected]iserversupport[~]#

Still you are facing any issue then check the mysql logs and check the error in logs,

 

An example log
—————
120122 10:55:22 [ERROR] /usr/sbin/mysqld: unknown variable ‘set-variable=max_user_connections=40′
120122 10:55:22 [ERROR] Aborting
120122 10:55:22 InnoDB: Starting shutdown…
120122 10:55:22 InnoDB: Shutdown completed; log sequence number 2153996
120122 10:55:22[Note] /usr/sbin/mysqld: Shutdown complete

120122 10:55:22 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
—————

Here in the logs you can see error in the first line. So you need to comment the line by editing the file my.cnf and start mqsql.

Need our help to fix the issue ? Submit Support Ticket Now

View Server Administration Packages

Leave a Reply

Your email address will not be published. Required fields are marked *