Nagios XI SQL Error

Error:
SQL: SQL Error [ndoutils]:Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired

Solution:

Repairing MySQL Tables

First, login to your Nagios XI server as the

root user.

Next, stop the MySQL database server with the following command:

service mysqld stop

Run the Nagios XI database repair script with the following command:

/usr/local/nagiosxi/scripts/repairmysql.sh nagios

The script will check and repair all tables in the nagios MySQL database. This process may take several minutes to complete, depending on the size of your database.

Once the script has completed, start the MySQL database server with the following command:

service mysqld start


Reference articles
http://assets.nagios.com/downloads/nagiosxi/docs/Repairing_The_Nagios_XI_Database.pdf