[Pkg-nagios-devel] Bug#641391: icinga-idoutils SQL fails when constraints have already been removed

[David Tulloh]

Package: icinga-idoutils
Version: 1.5.0-3
Severity: normal

Setting up icinga-idoutils (1.5.0-3) ...
dbconfig-common: writing config to /etc/dbconfig-common/icinga-idoutils.conf
creating database backup in
/var/cache/dbconfig-common/backups/icinga-idoutils_1.4.2-1+b2.pgsql.
applying upgrade sql for 1.4.2-1+b2 -> 1.5.0-1.sql.
error encountered processing
/usr/share/dbconfig-common/data/icinga-idoutils/upgrade/pgsql/1.5.0-1.sql:
ERROR: constraint "uq_timeperiod_timeranges" of relation
"icinga_timeperiod_timeranges" does not exist
dbconfig-common: icinga-idoutils configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing icinga-idoutils (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 icinga-idoutils

Actual error is caused by the SQL line in 1.5.0-1.sql:
ALTER TABLE icinga_timeperiod_timeranges DROP CONSTRAINT
uq_timeperiod_timeranges;

I believe I'm not actually upgrading from 1.4.2-1+b2, I probably had
1.5.0-0 installed, so the constraint had already been removed.

Changing the SQL line to the following should work for both cases
ALTER TABLE icinga_timeperiod_timeranges DROP CONSTRAINT IF EXISTS
uq_timeperiod_timeranges;

The other seven lines in the file have to be changed similarly.


-- System Information:
Debian Release: wheezy/sid
  APT prefers stable
  APT policy: (800, 'stable'), (750, 'testing'), (600, 'unstable'),
(500, 'oldstable'), (150, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.39+ (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages icinga-idoutils depends on:
ii  dbconfig-common            1.8.47        common framework for packaging dat
ii  debconf [debconf-2.0]      1.5.36.1      Debian configuration management sy
ii  icinga-common              1.5.0-3       host and network monitoring system
ii  libc6                      2.13-18       Embedded GNU C Library: Shared lib
ii  libdbd-mysql               0.8.3-1+s-2.1 MySQL database server driver for l
ii  libdbd-pgsql               0.8.3-1+s-2.1 PostgreSQL database server driver
ii  libdbi1                    0.8.4-5.1     DB Independent Abstraction Layer f
ii  lsb-base                   3.2-28        Linux Standard Base 3.2 init scrip
ii  ucf                        3.0025+nmu2   Update Configuration File: preserv

Versions of packages icinga-idoutils recommends:
ii  mysql-client-5.1 [mysql-clien 5.1.49-3   MySQL database client binaries
ii  postgresql-client             9.1+121    front-end programs for PostgreSQL
ii  postgresql-client-9.0 [postgr 9.0.4-2    front-end programs for PostgreSQL
ii  postgresql-client-9.1 [postgr 9.1~rc1-3  front-end programs for PostgreSQL

icinga-idoutils suggests no packages.

-- debconf information:
  icinga-idoutils/dbconfig-upgrade: true
  icinga-idoutils/mysql/method: unix socket
  icinga-idoutils/db/dbname: icinga
  icinga-idoutils/dbconfig-remove:
  icinga-idoutils/missing-db-package-error: abort
  icinga-idoutils/install-error: retry
  icinga-idoutils/pgsql/authmethod-admin: ident
  icinga-idoutils/pgsql/admin-user: postgres
  icinga-idoutils/internal/reconfiguring: false
  icinga-idoutils/purge: false
  icinga-idoutils/pgsql/changeconf: false
  icinga-idoutils/db/basepath:
  icinga-idoutils/database-type: pgsql
  icinga-idoutils/upgrade-error: abort
  icinga-idoutils/pgsql/method: unix socket
  icinga-idoutils/remote/port:
  icinga-idoutils/internal/skip-preseed: false
  icinga-idoutils/dbconfig-reinstall: false
  icinga-idoutils/upgrade-backup: true
  icinga-idoutils/remove-error: abort
  icinga-idoutils/dbconfig-install: true
  icinga-idoutils/pgsql/manualconf:
  icinga-idoutils/passwords-do-not-match:
  icinga-idoutils/pgsql/authmethod-user: password
  icinga-idoutils/pgsql/no-empty-passwords:
  icinga-idoutils/db/app-user: icingaidoutils
  icinga-idoutils/remote/host:
  icinga-idoutils/mysql/admin-user: root
  icinga-idoutils/remote/newhost: