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
xi_meta.MYD running wild..
xi_meta.MYD running wild..
You do not have the required permissions to view the files attached to this post.
Re: xi_meta.MYD running wild..
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.
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/
https://www.mcapra.com/
-
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: xi_meta.MYD running wild..
@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.
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
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!
Be sure to check out our Knowledgebase for helpful articles and solutions!