Monitoring Engine crashing (Nagios XI 5.7.2)

[meganwilliford]

I have sent a few more findings in a PM. I'm seeing "systemd: nagios.service stop-sigterm timed out. Killing." in the /var/log/messages at the time our backups are scheduled.

[ssax]

Send fresh output of this:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

Include the output of this command as well:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "desc nagios_hoststatus; desc nagios_servicestatus;"

EDIT: Send a fresh profile from the server that's having the most issues as well.