Page 1 of 1

Upgrade failed to 2014R1.0

Posted: Tue May 20, 2014 2:53 am
by datacom
Hello,
I've the same problem as in this post, but with different error.

Removing depricated failure_prediction_enabled from NagiosQL
Current database version: 1.5.2
** DB upgrade required for 2.0.0
Using mysql-upgrade-2.0.0.sql for upgrade...
ERROR 144 (HY000) at line 6: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
Upgrade from mysql-upgrade-2.0.0.sql failed at ./upgradedb line 106.

Thanks for your help.

Re: Upgrade failed to 2014R1.0

Posted: Tue May 20, 2014 9:41 am
by slansing
It looks like your server has been running with crashed tables, please follow this document and then re-run the upgrade:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Re: Upgrade failed to 2014R1.0

Posted: Fri May 23, 2014 3:32 am
by datacom
hello,
After this db cleanup. The upgrade works fine.
Thanks a lot