SQL Crashes Help!

[mmcknig4]

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

[jdalrymple]

1) I moved this to the proper location - General/Nagios XI

2) We include a database repair script you can use:

Code: Select all

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

Run that and it will likely repair your issue.

[dbuland]

If this does not clear the "crashed" flag what do I need to do next?

[tmcdonald]

We would need to know a lot more information, such as:

• Your XI version
• Your OS and version
• What symptoms you are seeing, and where

[dbuland]

Installed Version: 5.2.7
Red Hat Enterprise Linux Server release 6.8 (Santiago)


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

in the GUI and in the nagios log

[rkennedy]

Take a look at this document, which will have further troubleshooting that can be done - https://support.nagios.com/kb/article.php?id=24

If repair_databases doesn't work, I would attempt the repairmysql nagios part, and then look at the force repair options.

Let us know the full input / output you see from these commands if none of this helps.