Nagios Support Forum

Posted: **Tue Jun 11, 2013 1:43 am**

In the last couple of weeks is happens multiple times that a table of our Nagios XI server is marked as crashed:

Jun 11 02:01:01 localhost ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'

I can repair this with the command "myisamchk -r nagios_servicestatus.MYI" in the directory “/var/lib/mysql/nagios".
What caused this and how can we fix this permanently?

Posted: **Tue Jun 11, 2013 9:33 am**

Have you run our repair script? http://assets.nagios.com/downloads/nagi ... tabase.pdf
Is machine experiencing frequent power loss or incorrect restarts in vmware?

Posted: **Wed Jun 12, 2013 8:49 am**

no, we haven't run the script. Will do that and see what happens.
We ran the command

Code: Select all

myisamchk -r nagios_servicestatus.MYI

.

Server has good uptime, no reboots. Don't think that should do it.
Can the backup cause this?

Posted: **Wed Jun 12, 2013 9:37 am**

Potentially. What version of XI are you running?

Posted: **Thu May 08, 2014 3:18 am**

I know this one is old and we haven't had the problem since we used a new vm. Topic can be closed.

Nagios Support Forum

MySQL table keeps getting "crashed"

MySQL table keeps getting "crashed"

Re: MySQL table keeps getting "crashed"

Re: MySQL table keeps getting "crashed"

Re: MySQL table keeps getting "crashed"

Re: MySQL table keeps getting "crashed"