Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ubuntu any version >= 12.04 #1

Closed
mastacontrola opened this issue Jun 15, 2014 · 2 comments
Closed

Ubuntu any version >= 12.04 #1

mastacontrola opened this issue Jun 15, 2014 · 2 comments
Assignees

Comments

@mastacontrola
Copy link
Member

msyql seems to have an issue with the inodb tables in linux.

After startup one can login to the FOG Interface just fine, but after a seemingly random amount of time, days or minutes or both, the mysql server seems to fail. This is not on every system, but enough of a problem to warrant a bug.

@mastacontrola
Copy link
Member Author

From Website (http://tercan-eng.blogspot.com/2010/08/mysql-unable-to-lock-ibdata1-error-11.html)
error logs found report ibdata1 issues quite frequently with reports similar to:

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Error in opening ./ibdata1

For solution
Open terminal. Gain root:
sudo su -
cd /var/lib/mysql
backup original ibdata1.*
mv ibdata1 ibdata1.bak
mv ib_logfile0 ib_logfile0.bak
mv ib_logfile1 ib_logfile1.bak
copy it back
cp -a ibdata1.bak ibdata1
cp -a ib_logfile0.bak ib_logfile0
cp -a ib_logfile1.bak ib_logfile1
restart mysql
service mysql restart

Hopefully all will work properly.

@mastacontrola mastacontrola self-assigned this Jun 15, 2014
@mastacontrola
Copy link
Member Author

Additional information.

It seems that mysql has been bitten by, more or less, the same bug as the tftpd-hpa bug. This affects various versions of ubuntu.

The fix, as this seems to happen after reboot, is to disable the mysql service from boot time startup and place the startup in the rc.local file.

Make adjustments specific to your environment but:
echo manual | sudo tee /etc/init/mysql.override
Edit the /etc/rc.local file before the exit 0; line add:
sleep 30 && start mysql
Save the file, reboot all should work.

junkhacker added a commit that referenced this issue Jul 1, 2014
junkhacker added a commit that referenced this issue Jul 6, 2014
mastacontrola pushed a commit that referenced this issue Jul 31, 2014
mastacontrola pushed a commit that referenced this issue Mar 30, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant