The event manager status is flapping

[neo_infraestructura]

Hi there,

Today I started to see problems with the Event Manager, the check status of this service is flapping and the logs /usr/local/nagiosxi/var/eventman.log and /usr/local/nagiosxi/var/event_handler.log are writing really fast and can't see the error or the cause of it.

nagios.png

[neo_infraestructura]

The event_handler.log it's been written really fast. It size was of 60gb and filled my /usr disk space, I already had made a repair of the database and a reboot of the machine but the problem persist.

The version of NagiosXI that I have is the 5.5.10.

[neo_infraestructura]

Now the disc / was fulled due to a file in the mysql folder /var/lib/mysql/nagiosxi/ and found that the xi_meta are really heavy.

nagios4.png

Then I tryed to make another database repair and it got stuck in this the repair of nagiosxi

nagios3.png

What is going on?

[cdienger]

It looks like you're running to bug from a couple versions ago. Clear out the table(and a couple others than can cause issues):

Code: Select all

echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi

and then reboot the server to stop and start everything for good measure.

[neo_infraestructura]

It took a while, but the command worked. I have rebooted the machine and then stopped and started all the services. Everything seems to be working fine. I'm only worried that I still don't know what was the problem. I will be monitoring the status of the server.

Please don't close the topic yet.

[scottwilkerson]

It took a while, but the command worked. I have rebooted the machine and then stopped and started all the services. Everything seems to be working fine. I'm only worried that I still don't know what was the problem. I will be monitoring the status of the server.

Please don't close the topic yet.

Sounds good, we will leave the topic open.