Nagios Support Forum

Hi,

Had a system outage and after that some issues, xi_meta.MYD have gone crazy is on 66GB now.
The cron job DBMaint job is running but not cleaning up apparently, under the admin module "database maintenance" says not run for a couple days, but cron job is running, attached dbmaint.log.
Im seeing quite a few of these entries one logs, but guessing it load since they come and go:
PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysqli.inc.php on line 125

Repair database script does not help.

And I am also unable to apply configuration, cmdsubsys.log just saying:

Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...


The event_handler log is always going wild, seems to be looping with the same event queue id and log growing.

/Claus

You could start with increasing the max connections allowed to the MySQL database:
https://support.nagios.com/kb/article/n ... s-513.html

It's possible the DB maint job just isn't able to grab a connection to do its work.

@mcapra Thanks for the assistance today!

Also, please try running the following command to repair your database and send us your system profile if the issue persists. Thanks 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
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.