Nagios Support Forum

Posted: **Sat Oct 01, 2016 11:36 am**

We have Nagios XI 2014R2.7 and Nagios XI 5.2.3 on Redhat 6.7 systems. We noticed the following error in the mysqld.log, and on Nagios XI web interface when selecting "Notifications" under "Home->Incident Management":
In the mysqld.log:
161001 10:57:38 [ERROR] //opt/app/mysql/bin/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed

On Nagios XI Web Interface:
SQL: SQL Error [ndoutils] : Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed

How can I fix this problem? I am not sure what/how "last (automatic?) repair" was done? Should I try to run /usr/local/nagiosxi/scripts/repair_databases.sh? What other tools/scripts that I can run to fix this problem? Thanks!

Posted: **Mon Oct 03, 2016 10:48 am**

Run the db repair script:

Code: Select all

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

If this doesn't help, you can try:

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases

If this doesn't fix the issue either, run:

Code: Select all

echo 'repair table nagios_notifications use_frm;' | mysql -t -u root -pnagiosxi nagios
service mysqld restart

Let us know if this helped.

Posted: **Sat Oct 08, 2016 4:48 pm**

The script repair_databases.sh helped repair the table "nagios_notifications'. Thanks!

Posted: **Mon Oct 10, 2016 9:32 am**

Awesome, are we good to mark this thread as resolved?

Nagios Support Forum

Table nagios_notifications crashed and auto repair failed

Table nagios_notifications crashed and auto repair failed

Re: Table nagios_notifications crashed and auto repair faile

Re: Table nagios_notifications crashed and auto repair faile

Re: Table nagios_notifications crashed and auto repair faile