Package: nagios-mysql Version: 1.3-cvs.20050402-2 Severity: critical Justification: will happily peg the cpu at 100%, and fill the disk, making system unusable (and potentially losing data)
Hi, I have a machine w/ mysql-server installed. I did an apt-get install nagios-mysql, restarted apache, and followed the nagios-common/README.Debian instructions (going through, modifying the config files). After about 20 minutes, I was informed that the machine was slowing down considerably. The culprit was nagios, which was using 100% cpu. /var/log/nagios/nagios.log was at 648MB, and was filled with: [1117732808] Error: Could not insert retention data for host 'gw' in table 'hostretention' [1117732808] Error: Could not insert retention data for host 'gw' in table 'hostretention' [1117732808] Error: Could not insert retention data for host 'gw' in table 'hostretention' [1117732808] Error: Could not insert retention data for host 'gw' in table 'hostretention' I assume nagios was spinning, attempting to do sql stuff on a database that hadn't be configured yet. syslog contained: Jun 2 13:06:16 helmsley nagios: Error: Could not lock status data tables in database '' Jun 2 13:06:31 helmsley nagios: Error: Could not insert row for program retention data in table 'programretention' Jun 2 13:06:31 helmsley nagios: Error: Could not insert retention data for host 'gw' in table 'hostretention' Jun 2 13:07:02 helmsley last message repeated 280669 times Jun 2 13:08:03 helmsley last message repeated 553752 times Jun 2 13:09:04 helmsley last message repeated 553292 times That's, um, a lot. Nagios-common debconf values: * nagios/adminpassword: (password omitted) * nagios/wwwsuid: true nagios/upgradefromnetsaint: * nagios/configapache: Apache As an added bonus, I noticed the following in daemon.log: Jun 2 15:02:02 helmsley mysqld[9510]: 050602 15:02:02 /usr/sbin/mysqld: Disk is full writing './bugtracker/mantis_bug_history_table.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs :/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

