[Pkg-nagios-devel] Bug#311695: marked as done (nagios-mysql: default config fills disk)

Debian Bug Tracking System owner at bugs.debian.org
Sat Sep 24 15:33:16 UTC 2005

Your message dated Sat, 24 Sep 2005 08:17:05 -0700
with message-id <E1EJBlx-0003XC-00 at spohr.debian.org>
and subject line Bug#311695: fixed in nagios 2:1.3-cvs.20050402-6
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

Received: (at submit) by bugs.debian.org; 2 Jun 2005 19:13:33 +0000
>From dilinger at debian.org Thu Jun 02 12:13:33 2005
Return-path: <dilinger at debian.org>
Received: from faye.voxel.net [] (8f0b97357c77e90dcfa65f1974e5b0cc)
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1Ddv8H-0006f1-00; Thu, 02 Jun 2005 12:13:33 -0700
Received: from jack.dev.in.athenacr.com (unknown [])
	by faye.voxel.net (Postfix) with ESMTP id BF603371B3
	for <submit at bugs.debian.org>; Thu,  2 Jun 2005 15:13:31 -0400 (EDT)
Subject: nagios-mysql: default config fills disk
From: Andres Salomon <dilinger at debian.org>
To: submit at bugs.debian.org
Content-Type: text/plain
Date: Thu, 02 Jun 2005 15:13:31 -0400
Message-Id: <1117739611.10070.33.camel at jack.dev.in.athenacr.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 
Content-Transfer-Encoding: 7bit
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

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)


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/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


Received: (at 311695-close) by bugs.debian.org; 24 Sep 2005 15:18:21 +0000
>From katie at spohr.debian.org Sat Sep 24 08:18:21 2005
Return-path: <katie at spohr.debian.org>
Received: from katie by spohr.debian.org with local (Exim 3.36 1 (Debian))
	id 1EJBlx-0003XC-00; Sat, 24 Sep 2005 08:17:05 -0700
From: sean finney <seanius at debian.org>
To: 311695-close at bugs.debian.org
X-Katie: $Revision: 1.56 $
Subject: Bug#311695: fixed in nagios 2:1.3-cvs.20050402-6
Message-Id: <E1EJBlx-0003XC-00 at spohr.debian.org>
Sender: Archive Administrator <katie at spohr.debian.org>
Date: Sat, 24 Sep 2005 08:17:05 -0700
Delivered-To: 311695-close at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

Source: nagios
Source-Version: 2:1.3-cvs.20050402-6

We believe that the bug you reported is fixed in the latest version of
nagios, which is due to be installed in the Debian FTP archive:

  to pool/main/n/nagios/nagios-common_1.3-cvs.20050402-6_all.deb
  to pool/main/n/nagios/nagios-mysql_1.3-cvs.20050402-6_i386.deb
  to pool/main/n/nagios/nagios-pgsql_1.3-cvs.20050402-6_i386.deb
  to pool/main/n/nagios/nagios-text_1.3-cvs.20050402-6_i386.deb
  to pool/main/n/nagios/nagios_1.3-cvs.20050402-6.diff.gz
  to pool/main/n/nagios/nagios_1.3-cvs.20050402-6.dsc

A summary of the changes between this version and the previous one is

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 311695 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
sean finney <seanius at debian.org> (supplier of updated nagios package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster at debian.org)

Hash: SHA1

Format: 1.7
Date: Sat, 24 Sep 2005 08:23:22 -0400
Source: nagios
Binary: nagios-pgsql nagios-text nagios-mysql nagios-common
Architecture: source i386 all
Version: 2:1.3-cvs.20050402-6
Distribution: unstable
Urgency: low
Maintainer: seanius at debian.org
Changed-By: sean finney <seanius at debian.org>
 nagios-common - A host/service/network monitoring and management system
 nagios-mysql - A host/service/network monitoring and management system
 nagios-pgsql - A host/service/network monitoring and management system
 nagios-text - A host/service/network monitoring and management system
Closes: 311695 317015 321932 323110
 nagios (2:1.3-cvs.20050402-6) unstable; urgency=low
   * Sean Finney:
     - update debian/rules to install the Knn scripts for nagios to kill
       nagios before mysql is killed (which is done at K19-K21).  thanks
       to Al Nikolov for pointing this out (closes: #321932).
     - finally include a fix for nagios-mysql/nagios-pgsql when they
       start but are unable to connect to the database, which can
       result in massively large logs as nagios spins its wheels.  thanks
       to Andres Salomon and Don Armstrong and Steve Langasek for their
       feedback and suggested patches (closes: #311695).  testing
       of this feature would be appreciated.
     - re-added (commented out) ScriptAliases for the old netsaint
       locations, for folks who still have bookmarks :)  thanks to
       Mathew Rubright for mentioning this (closes: #317015).
     - hardcode the path to traceroute as it will always be there
       on debian systems and this lets us bypass having to have it
       as a build-dependency, which doesn't seem right.  thanks to
       Ben Winslow (closes: #323110).
     - update control file, removing uploaders who have never
       uploaded or even made cvs commits.
 4e2ef94699ae67eb9ffdc3c4cd3e0c1d 951 net optional nagios_1.3-cvs.20050402-6.dsc
 24569287ae9166922a3a09289d2424f7 64813 net optional nagios_1.3-cvs.20050402-6.diff.gz
 62b1d507ab1306bb2cf3bc98a930cd01 903148 net optional nagios-text_1.3-cvs.20050402-6_i386.deb
 364fd5049a2de331f2ef9fa5695a258a 906454 net optional nagios-mysql_1.3-cvs.20050402-6_i386.deb
 7e9286f49cecb90685ae01f5cb9f0e53 915876 net optional nagios-pgsql_1.3-cvs.20050402-6_i386.deb
 147d7c9df14d7c99a08740f900fcf811 1215008 net optional nagios-common_1.3-cvs.20050402-6_all.deb

Version: GnuPG v1.4.1 (GNU/Linux)


More information about the Pkg-nagios-devel mailing list