xi_meta.MYD running wild..

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
clkc
Posts: 1
Joined: Tue Jul 02, 2019 8:15 am

xi_meta.MYD running wild..

Post by clkc »

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 do not have the required permissions to view the files attached to this post.
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: xi_meta.MYD running wild..

Post by mcapra »

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.
Former Nagios employee
https://www.mcapra.com/
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: xi_meta.MYD running wild..

Post by benjaminsmith »

@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

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm
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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked