ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

[golden3]

In Centos7.3 i have configured , MySQL NDB cluster after installing an tomcat not able to start an mysql service,

while giving the command to "service mysql start" its showing the error , anyone idea on this ?

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

[TrevorH]

We do not ship Mysql on CentOS 7. We ship mariadb. If you have mysql packages installed then they did not come from us and you need to ask the provider of those packages for support.

[aks]

MySQL NDB cluster

That is certainly not supported here.

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Usually what that means is that systemd sent the start command, mysql launched, populated the lock for the subsystem and then exited due to an error. Try running mysql in the foreground and see if you get any other clues (and/or check mysql's error log).

[Nauman87]

Hi dear,

I have facing the same thing and finally got the solution.

This was the error:

-service mysql status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

After getting this error, just follow the following steps:

1- rm /var/lock/subsys/mysql
rm: remove regular empty file ‘/var/lock/subsys/mysql’? y (Press 'y')

2-/etc/init.d/mysql start
Starting MySQL....................................................................................................

3- In case you got the error again like "ERROR! The server quit without updating PID file (/mysql/data/kalsym.com.pid)."

" ps -ef | grep mysql "

Kill all mysql process

and repeat the Step 1 & 2. This should resolve the issue.

NOTE: Check your disk space as well

Thanks