Nagios is grown out of control

[vmwareguy]

I'm having a problem with my NagiosXI server running out of space over and over. I did a fresh rebuild of centos 7 yesterday and ran a restore of my database. Over night my usr/local/nagiosxi/var/event_handler.log-20181017 has grown to 21gb and my /var/lib/mysql/nagiosxi/xi_meta.MYD has grown to 20gb

I have no idea what to do to keep these files from growing out of control next to rebuilding and starting all over.

We only have about 80 servers that are monitored and I have tried the repair_database script

Thanks for any help.

[npolovenko]

Hello, @vmwareguy. This is most likely a database corruption issue. Please delete the event_handler.log and run the following commands:

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

mysqlcheck -r -f -uroot -pnagiosxi --all-databases

Let me know if this fixes your issues.