[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 [69.9.164.210] (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 [66.150.84.1])
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
X-Spam-Level:
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
:/
---------------------------------------
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-Level:
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:
nagios-common_1.3-cvs.20050402-6_all.deb
to pool/main/n/nagios/nagios-common_1.3-cvs.20050402-6_all.deb
nagios-mysql_1.3-cvs.20050402-6_i386.deb
to pool/main/n/nagios/nagios-mysql_1.3-cvs.20050402-6_i386.deb
nagios-pgsql_1.3-cvs.20050402-6_i386.deb
to pool/main/n/nagios/nagios-pgsql_1.3-cvs.20050402-6_i386.deb
nagios-text_1.3-cvs.20050402-6_i386.deb
to pool/main/n/nagios/nagios-text_1.3-cvs.20050402-6_i386.deb
nagios_1.3-cvs.20050402-6.diff.gz
to pool/main/n/nagios/nagios_1.3-cvs.20050402-6.diff.gz
nagios_1.3-cvs.20050402-6.dsc
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
attached.
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
pp.
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)
-----BEGIN PGP SIGNED MESSAGE-----
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>
Description:
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
Changes:
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.
Files:
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFDNWtyynjLPm522B0RAkMOAJ9x/dbeoSJvEXOE5taA8udLkmv8xwCfQAwc
phXDuLYKieLEnqb95+LcTvs=
=ikOd
-----END PGP SIGNATURE-----
More information about the Pkg-nagios-devel
mailing list