[Pkg-nagios-devel] Bug#311695: nagios-mysql: default config fills disk

[Andres Salomon]

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

:/