MySQL Error

[Timelord83]

after a server restart sql crashes about 5 minutes in with this error,

[CODE]innodb unable to lock ./ibdata1 error 11 [/CODE]

and after a server restart all seems fine, I haven’t attempted to pull an image but it is downloading them fine.

Has anyone seen this error before?

[Tom Elliott]

Maybe this?

[url]http://forums.mysql.com/read.php?22,577116,577186#msg-577186[/url]

[Tom Elliott]

Or this:
[url]http://tercan-eng.blogspot.com/2010/08/mysql-unable-to-lock-ibdata1-error-11.html[/url]

[A Former User]

Hi, just for information it’s an old post but i have seen exactly the same problem on a new install of fog (with ubuntu 14.04.1)
it seem there is two instance of mysql running, i have kill every and start again mysql and it seems ok for now but each time the server reboot the problem is happening.
I have seen one sql running at boot in rc2.d S20mysql but i have not find the other yet.
For information the running process at boot :
1287 0.0 0.0 2268 660 ? S 12:01 0:00 /bin/sh /usr/bin/mysqld_safe mysql
1645 0.1 0.8 318156 34008 ? Sl 12:01 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

for the moment i have stop the S20mysql (K20mysql) and it seem ok.

[Tom Elliott]

This is a very well known about problem.

What’s worse, the instance of MySQL that starts at boot will actually crash because it’s typically started before networking is even available.

[A Former User]

i see, so what’s the best solution for now to avoid problems ?

[Tom Elliott]

Maybe read one of the many posts containing the problem and using the information found in them to try helping out?

[url]https://github.com/fogproject/fogproject/issues/1[/url]

[A Former User]

ok thanks