xi_meta.MYD running wild..
Posted: 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
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