[Pkg-nagios-devel] Bug#407034: nagios-pgsql: scheduling downtimes doesn't work on AMD64

[root]

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


Hi!

I recently migrated an i386 Nagios setup to amd64. Now, however, there are
problems with scheduling downtimes. When I schedule downtime for a
hostgroup (or group of services), Nagios happily sends out warnings in
the specified timeperiod. A look at "downtime" in the CGI shows some hosts
with multiple entries for the same scheduled downtime, and others with none
whatsoever. If I restart Nagios after scheduling downtimes, everything's as
expected, and warnings for hosts in scheduled downtime are no longer sent
out.

An example:

- no downtimes scheduled currently:
  http://www.waldner.priv.at/photos/nagios-downtime/no-downtime.jpg
- select hostgroup, select "schedule downtime for all hosts.."
  http://www.waldner.priv.at/photos/nagios-downtime/select-downtime-for-group.jpg
- schedule downtime
  http://www.waldner.priv.at/photos/nagios-downtime/commit-downtime.jpg
- "downtime" from the CGI
  http://www.waldner.priv.at/photos/nagios-downtime/downtime-group.jpg
- select first host from downtime list
  http://www.waldner.priv.at/photos/nagios-downtime/viele-downtimes.jpg
- second host
  http://www.waldner.priv.at/photos/nagios-downtime/no-downtime-visible.jpg

In the postgres db it looks like I'd expect:

nagios=# select * from hostdowntime;
 hostdowntime_id |    host_name    |     entry_time      |     start_time      |
-----------------+-----------------+---------------------+---------------------+
            3693 | sheakkacs02     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3694 | sheasracs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3695 | sheavbacs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3696 | sheawjacs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3697 | vheafracs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3698 | vheakiacs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3699 | vhearoacs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3700 | vheasdacs01     | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |
            3701 | vwbipheabiacs01 | 2007-01-15 15:18:54 | 2007-01-15 15:17:14 |

Any hints? This used to Just Work on i386 (with Nagios 1.3, though).

cheers,
&rw

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.17-2-amd64
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages nagios-pgsql depends on:
ii  dbconfig-common              1.8.27      common framework for packaging dat
ii  debconf [debconf-2.0]        1.5.8       Debian configuration management sy
ii  libc6                        2.3.6.ds1-8 GNU C Library: Shared libraries
ii  libdbd-pg-perl               1.49-1      a PostgreSQL interface for Perl 5 
ii  libgd2-xpm                   2.0.33-5.1  GD Graphics Library version 2
ii  libjpeg62                    6b-13       The Independent JPEG Group's JPEG 
ii  libpng12-0                   1.2.8rel-7  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.0016      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: nagios
  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: ignore
  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: nagios
  nagios-pgsql/import-oldsettings:
  nagios-pgsql/dbconfig-remove:
  nagios-pgsql/dbconfig-upgrade: true
  nagios-pgsql/pgsql/changeconf: false
* nagios-pgsql/pgsql/method: unix socket
* nagios-pgsql/dbconfig-install: true
* nagios-pgsql/pgsql/authmethod-user: ident
  nagios-pgsql/performing_upgrade: false
  nagios-pgsql/remove-error: abort
* nagios-pgsql/pgsql/authmethod-admin: ident
  nagios-pgsql/upgrade-backup: true
* nagios-pgsql/pgsql/admin-user: postgres
Oö. Gesundheits- und Spitals-AG, Techcenter, Hafenstraße 47-51, 4020 Linz, DVR 2107870, ATU 51928204, Firmenbuchgericht: Landesgericht Linz, FN 210146 p