Nagios Support Forum

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.

Your database has become corrupt.

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

Hi,

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

Thank you.

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

My top command, Got more load.

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

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. 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

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.

dimsum wrote: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