[Pkg-bareos-devel] Bug#851584: bareos-database-common: fails to upgrade from 'jessie': mysql said: ERROR 1067 (42000) at line 2: Invalid default value for 'CreateTime'

[Andreas Beckmann]

Package: bareos-database-common
Version: 16.2.4-3
Severity: serious
User: debian-qa at lists.debian.org
Usertags: piuparts
Control: affects -1 + bareos-database-mysql

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 bareos-database-common (16.2.4-3) ...
  Warning: failed to get "dbname" from config, using default value "bareos", see /tmp/bareos-config.3523.log
  Warning: failed to get "dbuser" from config, using default value "bareos", see /tmp/bareos-config.3523.log
  (config) dbc_go() bareos-database-common configure 2003.
  dbc_config() bareos-database-common configure 2003.
  dbc_set_dbtype_defaults() .
  dbc_detect_installed_dbtype() mysql.
  _dbc_detect_installed_dbtype() mysql.
  dbc_register_debconf() .
  dbc_read_package_config() .
  dbc_preseed_package_debconf() .
  dbc_config() bareos-database-common configure 2003.
  dbc_set_dbtype_defaults() mysql.
  dbc_detect_installed_dbtype() mysql.
  _dbc_detect_installed_dbtype() mysql.
  dbc_register_debconf() .
  dbc_get_app_pass() .
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/bareos-database-common.conf
  Replacing config file /etc/dbconfig-common/bareos-database-common.conf with new version
  creating database backup in /var/cache/dbconfig-common/backups/bareos-database-common_2003.2017-01-13-20.57.15.
  applying upgrade sql for 2003 -> 2004.
  error encountered processing /usr/share/dbconfig-common/data/bareos-database-common/upgrade/mysql/2004:
  mysql said: ERROR 1067 (42000) at line 2: Invalid default value for 'CreateTime'
  dbconfig-common: bareos-database-common configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing package bareos-database-common (--configure):
   subprocess installed post-installation script returned error exit status 1

This was a jessie -> sid test and it picked to upgrade mysql-5.5 -> mysql-5.7
Feel free to downgrade if this issue is specific to this weird combination.

cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bareos-database-mysql_16.2.4-3.log.gz
Type: application/gzip
Size: 52085 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-bareos-devel/attachments/20170116/5eed90b3/attachment-0001.bin>