SQL Error [ndoutils] : Incorrect file format 'nagios_contact

[nagios-retail]

Hello we seem to be having an issue with Service notifications Report.
When we want to run a Service notification we get the following error:
Incorrect file format 'nagios_contactnotificationmethods

This is the same for ALL service notifications.
OS is CentOS 7.9.2009
Nagios is version 5.8.4

[ssax]

Please repair the databases following this guide:

https://assets.nagios.com/downloads/nag ... tabase.pdf

[nagios-retail]

Hello,

The repair failed with the following error:

Code: Select all

myisamchk: error: 'nagios_contactnotificationmethods' is not a MyISAM-table

I also ran the

Code: Select all

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, '
engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';

where I got the error log:

Code: Select all

Error    : Incorrect file format 'nagios_contactnotificationmethods'
error    : Corrupt

So the database repair did not work.
I still get the same error code in the " Service Notifications"

[nagios-retail]

I send you @ssax a profile for further investigation.
Thx.

[vtrac]

Hi,
How are you doing?

Please try the followings command:

Code: Select all

echo 'repair table nagios_contactnotificationmethods use_frm;' | mysql -t -u root -pnagiosxi nagios

mysqlcheck -f -r -u root -pnagiosxi nagios

systemctl restart mariadb

/usr/local/nagiosxi/scripts/repair_databases.sh

Best Regards,
Vinh