[Pkg-nagios-devel] Bug#296100: marked as done (nagios-pgsql: postgres process eats 6% CPU)

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

Your message dated Thu, 3 Mar 2005 12:22:53 -0500
with message-id <20050303172253.GA4304@seanius.net>
and subject line closing bugs
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; 20 Feb 2005 10:17:58 +0000
>From marcus@better.se Sun Feb 20 02:17:58 2005
Return-path: <marcus@better.se>
Received: from mxfep02.bredband.com [] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1D2oA1-0002D2-00; Sun, 20 Feb 2005 02:17:58 -0800
Received: from thales.home.better.se ([] [])
          by mxfep02.bredband.com with ESMTP
          id <20050220101726.PEDS17521.mxfep02.bredband.com@thales.home.better.se>
          for <submit@bugs.debian.org>; Sun, 20 Feb 2005 11:17:26 +0100
Received: from thales.home.better.se (localhost.localdomain [])
	by thales.home.better.se (8.13.3/8.13.3/Debian-6) with ESMTP id j1KAHD0g023039
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <submit@bugs.debian.org>; Sun, 20 Feb 2005 11:17:14 +0100
Received: (from marcus@localhost)
	by thales.home.better.se (8.13.3/8.13.3/Submit) id j1KAHC6a023036;
	Sun, 20 Feb 2005 11:17:12 +0100
Date: Sun, 20 Feb 2005 11:17:12 +0100
From: Marcus Better <marcus@better.se>
Message-Id: <200502201017.j1KAHC6a023036@thales.home.better.se>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: nagios-pgsql: postgres process eats 6% CPU
X-Debbugs-CC: Marcus Better <marcus@better.se>
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=-11.0 required=4.0 tests=BAYES_00,HAS_PACKAGE,
	X_DEBBUGS_CC autolearn=ham version=2.60-bugs.debian.org_2005_01_02

Package: nagios-pgsql
Version: 2:1.3-cvs.20050116-1
Severity: normal

When running nagios, CPU usage for the postgres process is permanently
around 5-7%.

The "ps" command shows the following:

 8131 ?        D      3:37 postgres: nagios nagios DELETE

"top" gives the following:

 8131 postgres  15   0 18592  11m  10m D  6.0  2.2   2:44.58 postmaster

This is an AMD Athlon XP 2400+ system. I have other postgres processes
running too, but they don't take any noticeable amount of CPU

The postgres log shows the following from time to time:

2005-02-20 11:10:01 [20983] LOG:  connection received: host= port=33116
2005-02-20 11:10:01 [20983] LOG:  connection authorized: user=nagios database=nagios
2005-02-20 11:10:03 [20983] WARNING:  skipping "programretention" --- only table or database owner can vacuum it
2005-02-20 11:10:03 [20983] WARNING:  skipping "hostretention" --- only table or database owner can vacuum it
2005-02-20 11:10:03 [20983] WARNING:  skipping "serviceretention" --- only table or database owner can vacuum it

The database was created using the scripts in the distribution.

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.10-thales
Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8)

Versions of packages nagios-pgsql depends on:
ii  libc6               2.3.2.ds1-20         GNU C Library: Shared libraries an
ii  libgd2-noxpm        2.0.33-1.1           GD Graphics Library version 2 (wit
ii  libjpeg62           6b-9                 The Independent JPEG Group's JPEG 
ii  libpng12-0          1.2.8rel-1           PNG library - runtime
ii  libpq3              7.4.7-2              PostgreSQL C client library
ii  nagios-common       2:1.3-cvs.20050116-1 A host/service/network monitoring 
ii  zlib1g              1:1.2.2-3            compression library - runtime

-- no debconf information

Received: (at 296100-close) by bugs.debian.org; 3 Mar 2005 17:23:25 +0000
>From seanius@seanius.net Thu Mar 03 09:23:25 2005
Return-path: <seanius@seanius.net>
Received: from dsl092-235-113.phl1.dsl.speakeasy.net (sativa.seanius.net) [] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1D6u2n-0003JM-00; Thu, 03 Mar 2005 09:23:25 -0800
Received: by sativa.seanius.net (Postfix, from userid 1000)
	id D97D715829; Thu,  3 Mar 2005 12:22:53 -0500 (EST)
Date: Thu, 3 Mar 2005 12:22:53 -0500
From: sean finney <seanius@debian.org>
To: 296100-close@bugs.debian.org, 296562-close@bugs.debian.org,
Subject: closing bugs
Message-ID: <20050303172253.GA4304@seanius.net>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="BXVAT5kNtrzKuDFl"
Content-Disposition: inline
User-Agent: Mutt/
Delivered-To: 296100-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 

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

these three bugs are fixed, but since we skipped a version with our
uploads, the changelogs never closed the bugs.



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

Version: GnuPG v1.2.4 (GNU/Linux)