[Pkg-nagios-devel] Bug#774917: icinga-idoutils: fails to upgrade squeeze -> wheezy -> jessie: ERROR: syntax error at or near "EXISTS" LINE 1: ALTER TABLE icinga_comments DROP CONSTRAINT IF EXISTS uq_com... ^

[Andreas Beckmann]

Package: icinga-idoutils
Version: 1.11.6-1
Severity: serious
User: debian-qa at lists.debian.org
Usertags: piuparts

Hi,

during a test with piuparts I noticed your package fails to upgrade from
'squeeze' to 'wheezy' to 'jessie'.
It installed fine in 'squeeze', and upgraded to 'wheezy' successfully,
but then the upgrade to 'jessie' failed.

>From the attached log (scroll to the bottom...):

[...]
  Setting up nagios-plugins-basic (2.1.1-1) ...
  Setting up icinga-common (1.11.6-1) ...
  Installing new version of config file /etc/init.d/icinga ...
  Installing new version of config file /etc/icinga/icinga.cfg ...
  invoke-rc.d: policy-rc.d denied execution of stop.
  invoke-rc.d: policy-rc.d denied execution of start.
  Setting up icinga-idoutils (1.11.6-1+b4) ...
  Installing new version of config file /etc/icinga/idomod.cfg ...
  dbconfig-common: writing config to /etc/dbconfig-common/icinga-idoutils.conf
  Replacing config file /etc/icinga/ido2db.cfg with new version
  creating database backup in /var/cache/dbconfig-common/backups/icinga-idoutils_1.7.1-7.pgsql.
  applying upgrade sql for 1.7.1-7 -> 1.8.0-1.
  applying upgrade sql for 1.7.1-7 -> 1.9.0-1.
  applying upgrade sql for 1.7.1-7 -> 1.10.1-1.
  error encountered processing /usr/share/dbconfig-common/data/icinga-idoutils/upgrade/pgsql/1.10.1-1:
  ERROR: syntax error at or near "EXISTS" LINE 1: ALTER TABLE icinga_comments DROP CONSTRAINT IF EXISTS uq_com... ^
  dbconfig-common: icinga-idoutils configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing package icinga-idoutils (--configure):
   subprocess installed post-installation script returned error exit status 1
  Setting up nagios-plugins-common (2.1.1-1) ...
  Setting up openssl (1.0.1j-1) ...
  Setting up ssl-cert (1.0.35) ...
  Processing triggers for postgresql-common (164) ...
  Building PostgreSQL dictionaries from installed myspell/hunspell packages...
  Removing obsolete dictionary files:
  Processing triggers for libc-bin (2.19-13) ...
  Errors were encountered while processing:
   icinga-idoutils


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: icinga-idoutils_1.11.6-1+b4.log.gz
Type: application/gzip
Size: 59161 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-nagios-devel/attachments/20150109/7d98b4d5/attachment.bin>