How to solve InnoDB: cannot block the error. / ibdata 1 mysql?

Question

2016-03-14 02:30:29 58150 [ERROR] InnoDB: Unable to block. / ibdata 1, Error: 35 2016-03-14 02:30:29 58150 [Note] InnoDB: Make sure you do not already have another mysqld process using the same InnoDB data or log files.

Answer 1

First list the MySQL processes using the ps command:

ps aux | grep mysql 

And then kill the process

 sudo kill 56311 

Answer 2

Believe it or not, the solution is in a different place. The problem is due to incorrect AppArmor configuration.

So simple:

 $ apt install apparmor-profiles 

and then restart MySQL (note how fast it will reboot).

I noticed that the file associated with AppArmor is missing:

 $ systemctl status mysql.service 

Voila.

Answer 3

It should be said: "There is another solution: the problem may be in AppArmor." If you do not see entries in /var/log/apport.log , then probably the problem is not with AppArmor.

An intriguing decision, however.