Nagios Support Forum

Hello,

I have attempted to update to the latest version of NagiosXI (5.2.5) but the update does not complete due to an error. The last couple lines of the error are show below. Please assist.

mysqldump: Error 1194: Table 'nagios_statehistory' is marked as crashed and should be repaired when dumping table `nagios_statehistory` at row: 173361
Error backing up MySQL database 'nagios' - check the password in this script!

Thanks for your help.

Please repair the database prior to upgrading. You can do so by running -
/usr/local/nagiosxi/scripts/repair_databases.sh

Once that finishes, try upgrading from the CLI by following this guide -
https://assets.nagios.com/downloads/nag ... nstall.pdf

Let us know if that works out!

Do you see any errors/crashed tables in the mysqld.log? You may need to run the repair on the db:
to fix the crashed tables, and rerun the "upgrade" script.

repairing the database did the trick, thanks!

please close this ticket.