Page 2 of 2

Re: Error with upgrading to 5.2.0

Posted: Wed Nov 04, 2015 5:16 pm
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.

Re: Error with upgrading to 5.2.0

Posted: Thu Nov 05, 2015 9:04 am
by jimhoffmann
Those commands did the trick. I was able to complete the upgrade.

Thank you very much for all the help.

Re: Error with upgrading to 5.2.0

Posted: Thu Nov 05, 2015 10:54 am
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.