Page 1 of 1

Table './nagios/nagios_servicestatus' is marked as crashed

Posted: Fri Jan 25, 2013 8:20 am
by tom_wong
We have Nagiosxi 2012 R1.4 virtual machine running on CentOS. It is running fine with the extended trial license. However, everytime we powered down the machine and restarted it, Nagios refused to monitor.

It replies

Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
and sometimes, it reports another table is crashed too.

How to fix it and why everytime when we restarted the machine, Nagios refuse to start? When we load the last backed up virtual machine, Nagios will be ok until when the machine get restarted.

Tom

Re: Table './nagios/nagios_servicestatus' is marked as crash

Posted: Fri Jan 25, 2013 9:05 am
by scottwilkerson
This is a database corruption error

Please run

Code: Select all

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

Re: Table './nagios/nagios_servicestatus' is marked as crash

Posted: Fri Jan 25, 2013 11:24 am
by tom_wong
Great, it has been solved!