Page 1 of 1

Crashed service status table SQL error

Posted: Tue Jan 21, 2025 5:15 pm
by 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!

Re: Crashed service status table SQL error

Posted: Tue Jan 21, 2025 6:01 pm
by 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

Re: Crashed service status table SQL error

Posted: Tue Jan 21, 2025 6:12 pm
by k234
That fixed it, thank you!