Page 1 of 1

Nagios upgrade is failing with the error 'nagios' database is not in a usable configuration.

Posted: Thu Nov 23, 2023 11:32 pm
by arista-nagios
OS Distro: CentOS 7.9
Nagios version: 5.7.4
trying to upgrade to the latest version
----------------
Nagios upgrade is failing with the below error, I want to know fix the issue with Nagios and do the upgrade.
I am sure I can make changes in some files to configure my Nagios credentials and make this work. I don't know which file or configuration needs to be updated.
----------------
Error Log:

ERROR 144 (HY000) at line 7: Table './nagios/nagios_logentries' is marked as crashed and the last (automatic?) repair failed
Automated migration failed on file upgrade-from-3.0.4.sql!
The 'nagios' database is not in a usable configuration.
Please revert to your pre-upgrade snapshot and reach out to the Support Team.
----------------

Re: Nagios upgrade is failing with the error 'nagios' database is not in a usable configuration.

Posted: Mon Nov 27, 2023 10:12 am
by gwesterman
Hi @arista-nagios,

The first thing I would try is to repair the databases. You can follow this support article that walks you through doing so.

Let us know if this works!