MySQL Error
-
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?
-
Maybe this?
[url]http://forums.mysql.com/read.php?22,577116,577186#msg-577186[/url]
-
-
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=3306for the moment i have stop the S20mysql (K20mysql) and it seem ok.
-
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.
-
i see, so what’s the best solution for now to avoid problems ?
-
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]
-
ok thanks