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.