xi_meta.MYD running wild..

This board serves as an open discussion and support collaboration point for Nagios XI. NOTE: Nagios XI customers should use the Customer Support forum to obtain expedited support.

xi_meta.MYD running wild..

Postby clkc » Thu Jul 04, 2019 7:14 am

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
Attachments
dbmaint.log
(12.61 KiB) Downloaded 32 times
clkc
 
Posts: 1
Joined: Tue Jul 02, 2019 8:15 am

Re: xi_meta.MYD running wild..

Postby mcapra » Mon Jul 08, 2019 11:15 am

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
http://www.mcapra.com/
User avatar
mcapra
 
Posts: 3573
Joined: Thu May 05, 2016 3:54 pm

Re: xi_meta.MYD running wild..

Postby benjaminsmith » Mon Jul 08, 2019 4:58 pm

@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!
User avatar
benjaminsmith
 
Posts: 1466
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul


Return to Nagios XI

Who is online

Users browsing this forum: No registered users and 12 guests