Crashed service status table SQL error

[k234]

Hello, I am getting the following error when I log into Nagios XI:

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


I think this issue is preventing me from seeing the status of my services in XI. How would I go about fixing this error?

Thank you!

[gwesterman]

Hi @k234,

It looks as if you have encountered a database corruption error.

If you are on an XI version 2014 onwards, try running:

Code: Select all

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

Else try:

Code: Select all

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

[k234]

That fixed it, thank you!