[Pkg-nagios-devel] Bug#851585: 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'
lazyfrosch at debian.org
Tue Jan 31 16:41:14 UTC 2017
Hello Release team
- top post for referencing-
I'd like to ask you about views of this bug.
We can do the following:
1) Update icinga2 to 2.6.1 which includes some other useful changes (see below)
2) stretch-ignore the bug, since MySQL 5.7 won't be included in stretch
(Problem: backports might make a problem then)
I could also patch some of the crashing issues, but would rather prefer 2.6.1
as a cleaner update to maintain in stretch.
Note: I'm affiliated with upstream, but want to maintain the package as conform
In my perspective the cleanest way would be to use the minor release.
Please advise me, I left the diff out since it won't be helpful in discussion.
Interesting Icinga2 2.6.1 changes:
* Fixes an internal crash bug during check execution
* SIGPIPE crash (currently fixed in sysVinit script)
* Timestamp problems with PostgreSQL (incorrect datetime)
* Updating IDO schema to conform with MySQL >= 5.7 (big diff with lots of fields)
* Documentation and project links (that might be helpful for users)
Full issue list: https://github.com/Icinga/icinga2/milestone/60?closed=1
On 16.01.2017 17:33, Andreas Beckmann wrote:
> Package: icinga2-ido-mysql
> Version: 2.6.0-2
> Severity: serious
> User: debian-qa at lists.debian.org
> Usertags: piuparts
> during a test with piuparts I noticed your package fails to upgrade from
> 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.
> Pkg-nagios-devel mailing list
> Pkg-nagios-devel at lists.alioth.debian.org
markus at lazyfrosch.de / lazyfrosch at debian.org
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 488 bytes
Desc: OpenPGP digital signature
More information about the Pkg-nagios-devel