InnoDB: Unable to lock ./ibdata1, error: 11


Today, I saw that our mysql server suddenly went down and on checking mysql server logs,

following thing was noticed.


InnoDB: Unable to lock /path/to/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

To fix this issue, make a copy of the original files (ibdata1, ib_logfile0, ib_logfile1…).

mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak

cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1

Now start mysql service.

/etc/init.d/mysql start

Post to Twitter

Leave a Reply

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