[Pkg-pdns-maintainers] Bug#698562: pdns-backend-{my, pg}sql: fails to upgrade from squeeze: mysqldump: Got error: 1049: Unknown database 'pdns' when selecting the database

[Andreas Beckmann]

Package: pdns-backend-mysql,pdns-backend-pgsql
Version: 3.1-4
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'.
It installed fine in 'squeeze', then the upgrade to 'wheezy' fails.

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

  Setting up pdns-server (3.1-4) ...
  Installing new version of config file /etc/init.d/pdns ...
  Replacing config file /etc/default/pdns with new version
  invoke-rc.d: policy-rc.d denied execution of start.
  Setting up pdns-backend-mysql (3.1-4) ...
  dbconfig-common: writing config to /etc/dbconfig-common/pdns-backend-mysql.conf
  
  Creating config file /etc/dbconfig-common/pdns-backend-mysql.conf with new version
  
  Creating config file /etc/powerdns/pdns.d/pdns.local.gmysql with new version
  detected upgrade from previous non-dbconfig version.
  creating database backup in /var/cache/dbconfig-common/backups/pdns-backend-mysql_2.9.22-8+squeeze1.mysql.
  error encountered backing up the old database:
  mysqldump: Got error: 1049: Unknown database 'pdns' when selecting the database
  dbconfig-common: pdns-backend-mysql configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing pdns-backend-mysql (--configure):
   subprocess installed post-installation script returned error exit status 1


  Setting up pdns-server (3.1-4) ...
  Installing new version of config file /etc/init.d/pdns ...
  Replacing config file /etc/default/pdns with new version
  invoke-rc.d: policy-rc.d denied execution of start.
  Setting up pdns-backend-pgsql (3.1-4) ...
  dbconfig-common: writing config to /etc/dbconfig-common/pdns-backend-pgsql.conf
  
  Creating config file /etc/dbconfig-common/pdns-backend-pgsql.conf with new version
  
  Creating config file /etc/powerdns/pdns.d/pdns.local.gpgsql with new version
  detected upgrade from previous non-dbconfig version.
  creating database backup in /var/cache/dbconfig-common/backups/pdns-backend-pgsql_2.9.22-8+squeeze1.pgsql.
  error encountered backing up the old database:
  pg_dump: [archiver (db)] connection to database "pdns" failed: FATAL: database "pdns" does not exist
  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

Running piuparts tests is a very experimental feature and not available
in piuparts.git, yet. But I'm confident the db servers are running and
have been upgraded before the application.

I'm starting with a DEBIAN_FRONTEND=noninteractive install in minimal
squeeze (that works fine), do not configure the packages in any way and
distupgrade to wheezy later on (first the dbserver, the remaining
packages in the next run).


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdns-backend-mysql_3.1-4.log.gz
Type: application/x-gzip
Size: 29792 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-pdns-maintainers/attachments/20130120/4afd5216/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdns-backend-pgsql_3.1-4.log.gz
Type: application/x-gzip
Size: 33708 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-pdns-maintainers/attachments/20130120/4afd5216/attachment-0003.bin>