Bug#848137: tango-db: fails to upgrade from 'jessie': mysqldump: tango has insufficent privileges to SHOW CREATE PROCEDURE `class_att_prop`!

[Andreas Beckmann]

Package: tango-db
Version: 9.2.5~rc1+dfsg1-2
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 'stretch' fails.

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

  Setting up tango-db (9.2.5~rc1+dfsg1-2) ...
  Installing new version of config file /etc/init.d/tango-db ...
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/tango-db.conf
  Replacing config file /etc/dbconfig-common/tango-db.conf with new version
  creating database backup in /var/cache/dbconfig-common/backups/tango-db_8.1.2c+dfsg-5.2016-12-14-10.08.39.
  error encountered backing up the old database:
  mysqldump: tango has insufficent privileges to SHOW CREATE PROCEDURE `class_att_prop`!
  dbconfig-common: tango-db configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing package tango-db (--configure):
   subprocess installed post-installation script returned error exit status 1

In jessie, tango-db used mysql-server-5.5 (via mysql-server).
The upgrade of tango-db was performed after mysql-server had been upgraded
to mariadb-server-10.0 (via default-mysql-server) and was started again.


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tango-db_9.2.5~rc1+dfsg1-2.log.gz
Type: application/gzip
Size: 54763 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/debian-science-maintainers/attachments/20161214/2d2db94c/attachment-0001.bin>