[Pkg-nagios-devel] Bug#401155: nagios-pgsql: Dies after trying to SELECT from a nonexistant database column

[Sven Riedel]

Package: nagios-pgsql
Version: 2:1.4-3
Severity: important


After adding a scheduled downtime for a host via the webinterface, the
nagios main process dies. Doing an strace -s 1024 on the main process
during startup reveals the following:

rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
send(7, "Q\0\0\1`INSERT INTO hostcomments
(host_name,persistent,entry_time,author_name,comment_data) VALUES
(\'foo\\-server\',\'0\',1164960990::int4::abstime::timestamp,\'\\(Nagios
Process\\)\',\'This host has been scheduled for downtime from
12\\-01\\-2006 07\\:42\\:36 to 12\\-01\\-2006 09\\:42\\:36\\.
Notifications for the host will not be sent out during that time
period\\.\')\0", 353, 0) = 353
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
poll([{fd=7, events=POLLIN|POLLERR, revents=POLLIN}], 1, -1) = 1
recv(7, "C\0\0\0\17INSERT 0 1\0Z\0\0\0\5I", 16384, 0) = 22
rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
send(7, "Q\0\0\0:SELECT hostcomment_id FROM hostcomments WHERE
oid=\'0\'\0", 59, 0) = 59
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
poll([{fd=7, events=POLLIN|POLLERR, revents=POLLIN}], 1, -1) = 1
recv(7, "E\0\0\0WSERROR\0C42703\0Mcolumn \"oid\" does not
exist\0Fparse_expr.c\0L396\0RtransformColumnRef\0\0Z\0\0\0\5I", 16384,
0) = 94
open("/dev/tty", O_RDWR|O_NONBLOCK|O_NOCTTY) = 8
writev(8, [{"*** glibc detected *** ", 23}, {"corrupted double-linked
list", 28}, {": 0x", 4}, {"0809ebe8", 8}, {" ***\n", 5}], 5*** glibc
detected *** corrupted double-linked list: 0x0809ebe8 ***
) = 68
rt_sigprocmask(SIG_UNBLOCK, [ABRT], NULL, 8) = 0
tgkill(10825, 10825, SIGABRT)           = 0
--- SIGABRT (Aborted) @ 0 (0) ---

And postgres is right: there is no column hostcomments.oid column 
being set in /usr/share/doc/nagios-pgsql/create_pgsql.

So it looks like two bugs:
- Nagios dying because it's not handling the database error gracefully
  and
- Nagios trying to access a nonexistant column

Regs,
Sven


-- System Information:
Debian Release: 4.0
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.17-1-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages nagios-pgsql depends on:
ii  dbconfig-common              1.8.29      common framework for packaging dat
ii  debconf [debconf-2.0]        1.5.9       Debian configuration management sy
ii  libc6                        2.3.6.ds1-8 GNU C Library: Shared libraries
ii  libdbd-pg-perl               1.49-2      a PostgreSQL interface for Perl 5 
ii  libgd2-noxpm                 2.0.33-5.1  GD Graphics Library version 2 (wit
ii  libjpeg62                    6b-13       The Independent JPEG Group's JPEG 
ii  libpng12-0                   1.2.13-4    PNG library - runtime
ii  libpq4                       8.1.5-1     PostgreSQL C client library
ii  nagios-common                2:1.4-3     A host/service/network monitoring 
ii  postgresql-client-8.1        8.1.5-1     front-end programs for PostgreSQL 
ii  ucf                          2.0017      Update Configuration File: preserv
ii  zlib1g                       1:1.2.3-13  compression library - runtime

Versions of packages nagios-pgsql recommends:
ii  nagios-images                 0.3        Collection of images and icons for

-- debconf information:
  nagios-pgsql/app-password-confirm: (password omitted)
  nagios-pgsql/password-confirm: (password omitted)
  nagios-pgsql/pgsql/app-pass: (password omitted)
  nagios-pgsql/pgsql/admin-pass: (password omitted)
  nagios-pgsql/purge: false
  nagios-pgsql/db/app-user: nagiospgsql
  nagios-pgsql/remote/newhost:
  nagios-pgsql/internal/skip-preseed: false
  nagios-pgsql/passwords-do-not-match:
  nagios-pgsql/pgsql/manualconf:
  nagios-pgsql/remote/host:
  nagios-pgsql/dbconfig-reinstall: false
  nagios-pgsql/install-error: retry
  nagios-pgsql/upgrade-error: abort
  nagios-pgsql/pgsql/no-empty-passwords:
  nagios-pgsql/remote/port:
  nagios-pgsql/database-type: pgsql
  nagios-pgsql/internal/reconfiguring: false
  nagios-pgsql/db/dbname: nagiospgsql
  nagios-pgsql/import-oldsettings:
  nagios-pgsql/dbconfig-remove: true
  nagios-pgsql/dbconfig-upgrade: true
  nagios-pgsql/pgsql/changeconf: false
  nagios-pgsql/pgsql/method: unix socket
* nagios-pgsql/dbconfig-install: false
  nagios-pgsql/pgsql/authmethod-user: ident
  nagios-pgsql/performing_upgrade: true
  nagios-pgsql/remove-error: abort
  nagios-pgsql/pgsql/authmethod-admin: ident
  nagios-pgsql/upgrade-backup: true
  nagios-pgsql/pgsql/admin-user: postgres