[Pkg-nagios-devel] Bug#851585: icinga2-ido-mysql: fails to upgrade from 'jessie': mysql said: ERROR 1067 (42000) at line 10: Invalid default value for 'status_update_time'

[Andreas Beckmann]

Package: icinga2-ido-mysql
Version: 2.6.0-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 'sid' fails.

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

  Setting up icinga2-common (2.6.0-2) ...
  Installing new version of config file /etc/default/icinga2 ...
  Installing new version of config file /etc/icinga2/conf.d/commands.conf ...
  Installing new version of config file /etc/icinga2/conf.d/downtimes.conf ...
  Installing new version of config file /etc/icinga2/conf.d/groups.conf ...
  Installing new version of config file /etc/icinga2/conf.d/notifications.conf ...
  Installing new version of config file /etc/icinga2/conf.d/services.conf ...
  Installing new version of config file /etc/icinga2/conf.d/templates.conf ...
  Installing new version of config file /etc/icinga2/constants.conf ...
  Installing new version of config file /etc/icinga2/features-available/api.conf ...
  Installing new version of config file /etc/icinga2/icinga2.conf ...
  Installing new version of config file /etc/icinga2/scripts/mail-host-notification.sh ...
  Installing new version of config file /etc/icinga2/scripts/mail-service-notification.sh ...
  Installing new version of config file /etc/init.d/icinga2 ...
  Installing new version of config file /etc/logrotate.d/icinga2 ...
  Created symlink /etc/systemd/system/multi-user.target.wants/icinga2.service → /lib/systemd/system/icinga2.service.
  Running in chroot, ignoring request.
  invoke-rc.d: policy-rc.d denied execution of start.
  Setting up icinga2-bin (2.6.0-2) ...
  Setting up icinga2-ido-mysql (2.6.0-2) ...
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/icinga2-ido-mysql.conf
  Replacing config file /etc/dbconfig-common/icinga2-ido-mysql.conf with new version
  creating database backup in /var/cache/dbconfig-common/backups/icinga2-ido-mysql_2.1.1-1.2017-01-13-09.37.09.
  applying upgrade sql for 2.1.1-1 -> 2.2.0.
  error encountered processing /usr/share/dbconfig-common/data/icinga2-ido-mysql/upgrade/mysql/2.2.0:
  mysql said: ERROR 1067 (42000) at line 10: Invalid default value for 'status_update_time'
  dbconfig-common: icinga2-ido-mysql configure: aborted.
  dbconfig-common: flushing administrative password
  dpkg: error processing package icinga2-ido-mysql (--configure):
   subprocess installed post-installation script returned error exit status 1

This was observed during a jessie->sid upgrade which picked a mysql-5.5 -> mysql-5.7 upgrade for the database server.
Feel free to downgrade the severity if this bug is specific to that weird combination.


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: icinga2-ido-mysql_2.6.0-2.log.gz
Type: application/gzip
Size: 48545 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-nagios-devel/attachments/20170116/270e8a1f/attachment.bin>