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.