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

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
tom_wong
Posts: 37
Joined: Thu Oct 25, 2012 9:13 am

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

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

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

Post by scottwilkerson »

This is a database corruption error

Please run

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
tom_wong
Posts: 37
Joined: Thu Oct 25, 2012 9:13 am

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

Post by tom_wong »

Great, it has been solved!
Locked