Upgrade failed to 2014R1.0

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
datacom
Posts: 18
Joined: Tue May 20, 2014 2:42 am

Upgrade failed to 2014R1.0

Post 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.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Upgrade failed to 2014R1.0

Post 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
datacom
Posts: 18
Joined: Tue May 20, 2014 2:42 am

Re: Upgrade failed to 2014R1.0

Post by datacom »

hello,
After this db cleanup. The upgrade works fine.
Thanks a lot
Locked