Errors

[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 CloudLinux 7

If you are getting [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 in CloudLinux, following steps will help you.

First, stop MySQL service using following command:

# service mysql stop

and ensure that no MySQL processes are running using following command:

# ps aux| grep mysql ### no mysql processes here
# lsof -i:3306 ### nothing here as well

Next, follow below steps:

# mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
# cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
# service mysql start

Now, use lsof command to verify again:

# lsof -i:3306

You should now see that MySQL is operational:

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 802407 mysql 33u IPv6 13892877 0t0 TCP *:mysql (LISTEN)

If MySQL service still now running, contact us. Our server experts will solve the issue.

[Need assistance to fix this error or install tools? We’ll help you.]

Related Articles