SQL Error in Nagios XI Console

SQL Error in Nagios XI Console pops up strangley after configuring services for monitoring. This has happened frequently and after checking out Nagios XI library, there is resolution given by them for the same.

Error message:

SQL: SQL Error [ndoutils] : Table ‘./nagios/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table ‘./nagios/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table ‘./nagios/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed

Solution: Run below commands and make sure that no one is configuring any hosts or services while executing the same.

service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
service mysqld start

After these 3 commands (restart of mysql), the SQL error moves out of the Nagios XI console.

Nagios XI Solution for reference here.