php – mysql is dead but subsys locked-ThrowExceptions

Exception or error:

I am using PHP-mysql on Linux (RHEL 5.0) For First Time
When I tried to connect to MySQL from my PHP Script using mysqli_connect.
It Displayed The Following Error:

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'(2)

After googling for hour I found solution to this as stated here.

When I followed that approach and issued command:

service mysqld status

as a root user
I got : mysql is dead but subsys locked Any one know how to solve this and cause of this error ?

Also

  • Restarting
  • Starting
  • And Stopping of MySQL

is Giving Output as: FAILED
But PHP is working fine. I’ve tested the phpinfo(); for Demo.
I’ve installed MySQL in /usr/local/mysql/bin. Can Anyone Help me in this ? Any help is appreciated.

Thanks in advance.

How to solve:

I had this problem with my OTRS server after I tried to update a to large package.

The solution was:

copy for safty:

cp /var/lock/subsys/mysqld /root/mysqld

than delete it

rm /var/lock/subsys/mysqld

than close all services that depends on mysql:

service httpd stop
service otrs stop

after that:

service mysqld restart
service httpd restart
service otrs restart

System is CentOS 6.x

Answer:

  1. tail /var/log/mysqld.log to check the error log
  2. then do the following actions:

    rm /var/lock/subsys/mysqld
    chown -R mysql.mysql /var/run/mysqld

Answer:

service mysqld restart

Simply restarting the mysqld worked fro me on Centos.

Answer:

first,make sure that /etc/init.d/mysqld is running from /usr/local/mysql/bin
then,kill mysqld ,delete the lock file and restart it.

Answer:

This (and all sorts of other weird errors) can also happen if you have a full disk. In my case, my /var partition had filled up. Freeing up space allowed mysqld to restart again.

Answer:

First find the PID number of mysqld:

 1. Use top | grep mysqld
 2. kill -9 PID

Safe method, works fine with Cent OS

Answer:

Rebooting the server worked for me. Please remember to start all the services once you reboot in case you haven’t added ‘chkconfig’ for them, lets say httpd, named and mysql.

Answer:

i use command kill, step by step:

  1. use command service mysqld status for find PID mysqld
  2. kill -9 PID
  3. use command service mysqld status again for find PID mysqld
  4. kill -15 PID
  5. check again with command service mysqld status , check until the PID dead OR subsys locked
  6. use command service mysqld start

Answer:

The problem I meet in the project is because of the disk space run out.

The server that MySQL is running run out the disk space, business project’s log is too large. The result is that MySQL restart failed.

It is one probability and you can have a try.

du -sh *

and

service mysqld restart

Leave a Reply

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