monitoring engine freezes on database optimize

[vantage]

We're experiencing the following issue on 3 of our NagiosXI systems after an upgrade to version 5.8.4. Whenever the dbmaint.php runs and does a optimize on the database, it looks like the monitoring engine is frozen. No checks are executed until the optimize is finished.

We have decreased the duration of the impact by setting a lower max age for notifications and state history, but still the monitoring engine freezes for ~10 minutes every time the optimize runs.

Do you have any idea what we can do to fix this?

[benjaminsmith]

Hi,

It's also possible that the GUI is not updating during the optimization but the Core process is running normally. I'd like to review the Nagios Core log file for any errors. It would be ideal to capture the log output during the optimization.

Please run the following command and post the output to the thread.

Code: Select all

/usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php >> /usr/local/nagiosxi/var/dbmaint.log

Then PM a fresh System Profile. Also, a couple of other questions to help us troubleshoot this error.

1. Does Nagios Core need to be manually restarted to resume checks again?
2. Is the database offloaded?
3. Have you made any modifications?

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button

Thanks,
Benjamin