[Pkg-pdns-maintainers] Bug#726945: pdns-backend-pgsql: fails to upgrade from testing: ERROR: syntax error at or near "NOT" LINE 1: ...ABLE supermasters ALTER COLUMN ip TYPE VARCHAR(64) NOT NULL; ^

[Andreas Beckmann]

Package: pdns-backend-pgsql
Version: 3.3-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
'jessie'.
It installed fine in 'jessie', then the upgrade to 'sid' fails.

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

  Setting up pdns-server (3.3-1) ...
  Installing new version of config file /etc/init.d/pdns ...
  Installing new version of config file /etc/insserv.d/pdns-server ...
  Replacing config file /etc/powerdns/pdns.conf with new version
  invoke-rc.d: policy-rc.d denied execution of start.
  Setting up pdns-backend-pgsql (3.3-1) ...
  dbconfig-common: writing config to /etc/dbconfig-common/pdns-backend-pgsql.conf
  creating database backup in /var/cache/dbconfig-common/backups/pdns-backend-pgsql_3.1-4.pgsql.
  applying upgrade sql for 3.1-4 -> 3.3-1.
  error encountered processing /usr/share/dbconfig-common/data/pdns-backend-pgsql/upgrade/pgsql/3.3-1:
  ERROR: syntax error at or near "NOT" LINE 1: ...ABLE supermasters ALTER COLUMN ip TYPE VARCHAR(64) NOT NULL; ^
  dbconfig-common: pdns-backend-pgsql configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing pdns-backend-pgsql (--configure):
   subprocess installed post-installation script returned error exit status 1
  Processing triggers for libc-bin ...
  Errors were encountered while processing:
   pdns-backend-pgsql


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdns-backend-pgsql_3.3-1.log.gz
Type: application/x-gzip
Size: 15677 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-pdns-maintainers/attachments/20131020/261008c8/attachment.bin>