[Pkg-nagios-devel] Bug#303422: marked as done (nagios: Error: Could not lock status data tables in database '')

Debian Bug Tracking System owner@bugs.debian.org
Thu, 07 Apr 2005 21:48:11 -0700

Your message dated Fri, 8 Apr 2005 00:39:22 -0400
with message-id <20050408043922.GA2363@seanius.net>
and subject line Bug#303422: [Pkg-nagios-devel] Bug#303422: nagios: Error: Could not lock status data tables in database ''
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; 6 Apr 2005 15:43:21 +0000
>From cteachworth@gmail.com Wed Apr 06 08:43:21 2005
Return-path: <cteachworth@gmail.com>
Received: from (ami-hq-noc) [] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1DJCga-0006WZ-00; Wed, 06 Apr 2005 08:43:20 -0700
Received: by ami-hq-noc (Postfix, from userid 1000)
	id 08FF4A4054; Wed,  6 Apr 2005 07:41:44 -0800 (AKDT)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Chris Teachworth <cteachworth@gmail.com>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: nagios: Error: Could not lock status data tables in database ''
X-Mailer: reportbug 3.8
Date: Wed, 06 Apr 2005 07:41:44 -0800
Message-Id: <20050406154144.08FF4A4054@ami-hq-noc>
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

Package: nagios-mysql
Version: 2:1.3-cvs.20050116-4
Severity: important

The following error is writtent to /var/log/syslog and /var/log messages once
every minute:

Error: Could not lock status data tables in database '' 

My guess is that the  nagios-mysql plugin is not pulling the xsddb_database value
from the /etc/nagios/cgi.cfg file. I believe this error message is printed in
the source file nagios-1.3-vus.20050116/xdata/xsddb.c

I followed all of the instructions in README.Debian and README.mysql from the
/usr/share/doc/nagios-mysql dir and verfied that the user I'm specifying in
/etc/nagios/cgi.cfg for the xsddb_database has SELECT, INSERT, UPDATE, DELETE,
and LOCK privileges on the nagios database.

I haven't upgraded from a previous version of either nagios or mysql.

This is what the relevent section of my cgi.cfg file looks like:

Thanks for any help,
	Chris Teachworth

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.9-xenU
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages nagios-mysql depends on:
ii  libc6               2.3.2.ds1-18         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  libmysqlclient12    4.0.23-7             mysql database client library
ii  libpng12-0          1.2.8rel-1           PNG library - runtime
ii  nagios-common       2:1.3-cvs.20050116-4 A host/service/network monitoring 
ii  zlib1g              1:1.2.2-3            compression library - runtime

-- no debconf information

Received: (at 303422-done) by bugs.debian.org; 8 Apr 2005 04:39:53 +0000
>From seanius@seanius.net Thu Apr 07 21:39:53 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 1DJlHd-0005CC-00; Thu, 07 Apr 2005 21:39:53 -0700
Received: by sativa.seanius.net (Postfix, from userid 1000)
	id 80C7B15834; Fri,  8 Apr 2005 00:39:22 -0400 (EDT)
Date: Fri, 8 Apr 2005 00:39:22 -0400
From: sean finney <seanius@debian.org>
To: Chris Teachworth <cteachworth@gmail.com>,
Subject: Re: Bug#303422: [Pkg-nagios-devel] Bug#303422: nagios: Error: Could not lock status data tables in database ''
Message-ID: <20050408043922.GA2363@seanius.net>
References: <20050406154144.08FF4A4054@ami-hq-noc> <20050406234441.GA19274@seanius.net> <e60e40cd05040711262e24d30e@mail.gmail.com> <20050408013707.GA750@seanius.net> <e60e40cd05040720415571a180@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="ZGiS0Q5IWpPtfppv"
Content-Disposition: inline
In-Reply-To: <e60e40cd05040720415571a180@mail.gmail.com>
User-Agent: Mutt/
Delivered-To: 303422-done@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

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


On Thu, Apr 07, 2005 at 07:41:53PM -0800, Chris Teachworth wrote:
> Man... talk about making things more complicated than they need to
> be... when will I ever learn?
> That was is it, there was a process hung up from a couple of days ago.
> Sorry for wasting your time like that.

aha.  believe it or not, i had the same problem about two weeks ago.
i had a particular check sending me an email every minute, even though
the host was fine.  no matter what i turned off or disabled, i kept
getting the same messages.  turns out there was a hung process.

anyway, i'm going to go ahead and close this bug. =20



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

Version: GnuPG v1.2.4 (GNU/Linux)