Page 1 of 1
SQL Error [ndoutils] : Incorrect file format 'nagios_contact
Posted: Thu Jul 01, 2021 6:37 am
by 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
Re: SQL Error [ndoutils] : Incorrect file format 'nagios_con
Posted: Thu Jul 01, 2021 11:04 am
by ssax
Re: SQL Error [ndoutils] : Incorrect file format 'nagios_con
Posted: Mon Jul 05, 2021 3:54 am
by 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"
Re: SQL Error [ndoutils] : Incorrect file format 'nagios_con
Posted: Mon Jul 05, 2021 4:05 am
by nagios-retail
I send you
@ssax a profile for further investigation.
Thx.
Re: SQL Error [ndoutils] : Incorrect file format 'nagios_con
Posted: Tue Jul 06, 2021 4:38 pm
by 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