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: -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
