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; ^
Hello Julien, On Dec 22, 2013, at 15:37 , Julien Cristau wrote: On Sun, Oct 20, 2013 at 22:40:04 +0200, Peter van Dijk wrote: I have a patch for this, will submit it to the maintainers soon, if it's not already fixed in their git. Hi Peter, I can't see the patch at http://anonscm.debian.org/gitweb/?p=pkg-pdns/pdns.git;a=summary Any chance you could send it to this bug? Please find it attached. This is the version from October, I have not verified it against PowerDNS 3.3.1 (but the differences should be minor, if at all present). Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/ pdns-backend-pgsql-726945.patch Description: Binary data signature.asc Description: Message signed with OpenPGP using GPGMail
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; ^
On Sun, Oct 20, 2013 at 22:40:04 +0200, Peter van Dijk wrote: I have a patch for this, will submit it to the maintainers soon, if it's not already fixed in their git. Hi Peter, I can't see the patch at http://anonscm.debian.org/gitweb/?p=pkg-pdns/pdns.git;a=summary Any chance you could send it to this bug? Thanks, Julien signature.asc Description: Digital signature
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; ^
Package: pdns-backend-pgsql Version: 3.3-1 Severity: serious User: debian...@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 Description: GNU Zip compressed data
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; ^
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...@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/ signature.asc Description: Message signed with OpenPGP using GPGMail