after a server restart sql crashes about 5 minutes in with this error,
innodb unable to lock ./ibdata1 error 11
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?
Maybe read one of the many posts containing the problem and using the information found in them to try helping out?
i see, so what’s the best solution for now to avoid problems ?
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.
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.