Error with upgrading to 5.2.0

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Error with upgrading to 5.2.0

Post by tgriep »

Can you run the following as root in a shell to repair the 2 tables that are still crashed.

Code: Select all

echo "use nagios;repair table nagios_systemcommands use_frm;" | mysql -pnagiosxi
echo "use nagios;repair table nagios_statehistory use_frm;" | mysql -pnagiosxi
Try that and see if the upgrade runs.
Be sure to check out our Knowledgebase for helpful articles and solutions!
jimhoffmann
Posts: 50
Joined: Fri May 03, 2013 1:38 pm

Re: Error with upgrading to 5.2.0

Post by jimhoffmann »

Those commands did the trick. I was able to complete the upgrade.

Thank you very much for all the help.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Error with upgrading to 5.2.0

Post by rkennedy »

Glad to see this worked for you. I will now close this thread out, but feel free to open another in the future if you ever need assistance.
Former Nagios Employee
Locked