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
tbmay
Posts: 67
Joined: Wed Jan 22, 2014 6:23 pm

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

Post by tbmay »

2014R1.1
Centos 6.5 on the metal.

Good morning,

I have the error:

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

The server went down for a reason I'm not sure about yet. I bounced it to get it clean. Now I have the message above when I go to Host Group or Service Group status.

What's the best course of action before I restore.
tbmay
Posts: 67
Joined: Wed Jan 22, 2014 6:23 pm

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

Post by tbmay »

Never mind. A db repair seemed to correct it. Can I get a copy of the last version. I may want to backrev. This one is putting the server under a larger load than the last version.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

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

Post by tmcdonald »

Former Nagios employee
tbmay
Posts: 67
Joined: Wed Jan 22, 2014 6:23 pm

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

Post by tbmay »

Thanks a million. I meant the last pre-2014 version. I didn't install that version so I don't know what it did with the load. I'll just fetch it off the same site though. Thanks a million for your help.


Edit: Or I guess I won't as I'm forbidden.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

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

Post by tmcdonald »

Former Nagios employee
tbmay
Posts: 67
Joined: Wed Jan 22, 2014 6:23 pm

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

Post by tbmay »

Thanks a million....I was trying to view the directory /downloads and it's not letting me do that.

I appreciate it. You can close the ticket.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

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

Post by slansing »

Yep you won't be able to view that normally, you will only have access to direct links.
Locked