Every morning monitoring engine stopped

[fogier]

Since recently every morning when I come in to work I see that the monitoring engine had stopped on our Nagios XI virtual machine (downloaded from you guys).

A lot of checks are run in the morning and are not executed because of this problem. Yesterday I rebooted the machine but today I find out that this does not solve the problem. Also in NagVis all checks turn out blue. When I start the monitoring engine all is well but some checks don't execute till the next morning (if the engine keeps running, which it does not).

Our Server info:
Nagios XI 2012R1.6 Enterprise
CentOS 6.2 (x64)
2GB RAM
Runs on vSphere 5.0 Update1

What can I do to solve this issue.

Nieuwe afbeelding (1).png

Nieuwe afbeelding.png

[fogier]

Saw this error in /var/log/messages:

May 16 07:23:49 localhost ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'

executed myisamchk -r nagios_logentries.MYI from the directory /var/lib/mysql/nagios

Result:
- recovering (with sort) MyISAM-table 'nagios_logentries.MYI'
Data records: 652791
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

Now reboot the machine and see if it helps.

[yancy]

fogier,

If that does not help, check out this documentation for running a database repair.

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Thanks,

-Yancy

[fogier]

After the repair of that table all is well.
Case closed!