Page 1 of 1

SQL Crashes Help!

Posted: Fri Oct 09, 2015 3:06 pm
by 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

Re: SQL Crashes Help!

Posted: Fri Oct 09, 2015 9:55 pm
by 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.

Re: SQL Crashes Help!

Posted: Wed Oct 19, 2016 8:59 am
by dbuland
If this does not clear the "crashed" flag what do I need to do next?

Re: SQL Crashes Help!

Posted: Wed Oct 19, 2016 10:14 am
by 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

Re: SQL Crashes Help!

Posted: Wed Oct 19, 2016 10:48 am
by 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

Re: SQL Crashes Help!

Posted: Wed Oct 19, 2016 2:07 pm
by 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.