Hi Terrence,
Thanks for the logs. Actually, the current database log does look better, I'm not seeing the following error in that one:
Code: Select all
2020-07-20T07:35:22.976508Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 415 user: 'ndoutils'.
Have you noticed any improvement or is the monitoring engine still stopping? One thing I noticed the following on the command subsystem log:
Code: Select all
usr/local/nagios/etc/hosts: Cannot utime: Operation not permitted
Log in as root and run the following script:
Code: Select all
/usr/local/nagiosxi/scripts/reset_config_perms.sh
Also, let's check the max connection on the database, what is the output to the following commands:
Code: Select all
mysql -uroot -pnagiosxi -e "show variables like 'max_connections';"
mysql -uroot -pnagiosxi -e "show global status like 'Max_used_connections';"
Can you send us an updated profile, I'd like to see if the load has come down and check the logs once more. If this is affecting your monitoring, we can also roll back ndo if necessary, please let me know.