[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; ^

[Peter van Dijk]

I have a patch for this, will submit it to the maintainers soon, if it's not already fixed in their git.

On Oct 20, 2013, at 22:36 , Andreas Beckmann wrote:

> 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
> <pdns-backend-pgsql_3.3-1.log.gz>

Kind regards,
-- 
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 841 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.alioth.debian.org/pipermail/pkg-pdns-maintainers/attachments/20131020/0b74b78e/attachment-0001.sig>