[Pkg-nagios-devel] Bug#294104: marked as done (Hangs using 80% CPU when database server is restarted)

Debian Bug Tracking System owner@bugs.debian.org
Thu, 03 Mar 2005 09:33:16 -0800


Your message dated Thu, 3 Mar 2005 12:17:39 -0500
with message-id <20050303171739.GA4250@seanius.net>
and subject line closing bug
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; 7 Feb 2005 21:25:06 +0000
>From roman@hodek.net Mon Feb 07 13:25:06 2005
Return-path: <roman@hodek.net>
Received: from reverse-213-146-113-115.dialin.kamp-dsl.de (grufti.hodek.net) [213.146.113.115] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1CyGNV-0004p4-00; Mon, 07 Feb 2005 13:25:06 -0800
Received: from ridcully.hodek.net (ridcully.hodek.net [192.168.24.10])
	by grufti.hodek.net (Postfix) with ESMTP id C4F0CFC8334
	for <submit@bugs.debian.org>; Mon,  7 Feb 2005 22:24:33 +0100 (CET)
Received: by ridcully.hodek.net (Postfix, from userid 2112)
	id C10A25A53C; Mon,  7 Feb 2005 22:24:33 +0100 (CET)
To: submit@bugs.debian.org
Subject: Hangs using 80% CPU when database server is restarted
Reply-To: roman@hodek.net
Message-Id: <20050207203520.EE0985A538@ridcully.hodek.net>
Date: Mon,  7 Feb 2005 21:35:20 +0100 (CET)
From: roman@hodek.net (Roman Hodek)
Delivered-To: submit@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-pgsql
Version: 2:1.3-cvs.20050116-1
Severity: normal

Around a week ago, I switched my nagios installation from text-based
to a Postgres database (which is now running anyway on the same
machine for other reasons).

(Unintendedly) I've set up postmaster.conf so that the db server runs
with locale de_DE.UTF-8, so error messages are in German. When I then
restart the Postgres server, nagios goes into an endless loop, using
~80% CPU time. With strace, I can see that its famous last words are:

send(6, "Q\0\0\0\26BEGIN TRANSACTION\0", 23, 0) = 23
rt_sigaction(SIGPIPE, {SIG_DFL}, {SIG_IGN}, 8) = 0
poll([{fd=6, events=POLLIN|POLLERR, revents=POLLIN|POLLERR|POLLHUP}], 1, -1) = 1
recv(6, "E\0\0\0mSFATAL\0C57P01\0Mbreche Verbi"..., 16384, 0) = 110
poll([{fd=6, events=POLLIN|POLLERR, revents=POLLIN|POLLERR|POLLHUP}], 1, -1) = 1
recv(6, "", 16384, 0)                   = 0
time(NULL)                              = 1107807044
poll([{fd=6, events=POLLIN|POLLERR, revents=POLLIN|POLLERR|POLLHUP}], 1, 0) = 1
recv(6, "", 16384, 0)                   = 0
close(6)                                = 0

"breche Verbi" is probably the start of "breche Verbindung ab" ==
"aborting connection". After that nothing anymore in strace... It
seems nagios somehow checks the wording of the error message, and if
it doesn't see the expected English string it does something silly and
loops around ;) If Postgres runs in en_US.UTF-8 locale, nagios still
runs normally after the db restart.

This is not a big problem for me, as error messages _should_ be
English in my case. However, it would nevertheless be better to check
the return code instead parsing the string...

Roman

---------------------------------------
Received: (at 294104-close) by bugs.debian.org; 3 Mar 2005 17:18:10 +0000
>From seanius@seanius.net Thu Mar 03 09:18:10 2005
Return-path: <seanius@seanius.net>
Received: from dsl092-235-113.phl1.dsl.speakeasy.net (sativa.seanius.net) [66.92.235.113] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1D6txi-0001eL-00; Thu, 03 Mar 2005 09:18:10 -0800
Received: by sativa.seanius.net (Postfix, from userid 1000)
	id E1D1215829; Thu,  3 Mar 2005 12:17:39 -0500 (EST)
Date: Thu, 3 Mar 2005 12:17:39 -0500
From: sean finney <seanius@debian.org>
To: 294104-close@bugs.debian.org
Subject: closing bug
Message-ID: <20050303171739.GA4250@seanius.net>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="gKMricLos+KVdGMg"
Content-Disposition: inline
User-Agent: Mutt/1.5.5.1+cvs20040105i
Delivered-To: 294104-close@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=-3.0 required=4.0 tests=BAYES_00 autolearn=no 
	version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level: 


--gKMricLos+KVdGMg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

hi roman,

as i stated in the last mail, i'm now going to close this bug, assuming
that the notes in README.pgsql fixed the problem.  if this is not the
case we can reopen this bug report when you have the time to help look
into it.


	sean

--=20

--gKMricLos+KVdGMg
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFCJ0azynjLPm522B0RAjWzAJ9P2AN2qYPuvpeBibsZnHzc/i9jzQCeNf8l
z64UYVHmrG/kZpywyc1GFlU=
=fYiQ
-----END PGP SIGNATURE-----

--gKMricLos+KVdGMg--