[ERROR] mysqld: Table './nagios/nagios_logentries' is marked

[dimsum]

I got the errors from mariadb.log

I'm not sure of the issue but my XI CPU have overload. How can I fix this error? Also, I have attached file of the system profile.

-----Error-----
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair
failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair
failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair
failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair
failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair
failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180531 20:04:48 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed

Thank you.

[scottwilkerson]

Your database has become corrupt.

Please follow steps in this doc
https://assets.nagios.com/downloads/nag ... tabase.pdf

[dimsum]

Hi,

I have followed the repair and error was gone. but my CPU got critical. how to find the problem?

Thank you.

[scottwilkerson]

you need to see what it causing the load by running the following

Code: Select all

top

or

Code: Select all

ps aux

[dimsum]

My top command, Got more load.

[scottwilkerson]

Please go to Admin -> System Profile ans PM me your profile.zip

[scottwilkerson]

I received the profile, we only work M-F 9-5 CDT

I see the load has come down a lot from the image you posted.

I do see there are still database errors, and the server has only been up for a little over 1 day.

If this is a VM, make sure when you stop this server you use a shutdown command from the command line and don't just click the STOP or RESET button in VMWare.

Lets re-run the database repair command again until the mariadb.log doesn't show new crashed tables.

Code: Select all

tail -f /var/log/mariadb.log 

https://assets.nagios.com/downloads/nag ... tabase.pdf

You are also at the point that a RAM Disk would be helpful
https://assets.nagios.com/downloads/nag ... giosXI.pdf

[dimsum]

I have already to use a ramdisk. and I have deactivated some service it about 1,900 checks. my database is no error anymore. but CPU still critical. What is a load value for 8vCPU? this a default value w=5.0,4.0,3.0 c=10.0,6.0,4.0

Before I reply, I was a reboot system.

Thank you.

[scottwilkerson]

this a default value w=5.0,4.0,3.0 c=10.0,6.0,4.0

I would multiply each of these by 8
so

Code: Select all

w=40.0,32.0,24.0 c=80.0,48.0,32.0