Package: icinga2-ido-mysql Version: 2.6.0-2 Severity: important Dear Maintainer,
sometimes, when reloading the icinga2 daemon, the IDO database won't be updated. Apparently, this happens, when there is a huge amount of comments/downtimes stored in the database. The logfile contains the following entries: [2016-08-30 06:40:00 -0400] critical/IdoMysqlConnection: Error "Commands out of sync; you can't run this command now" when executing query "DELETE FROM icinga_comments WHERE ... ... Very Long SQL Statement ... ... [2016-08-30 06:40:44 -0400] critical/IdoMysqlConnection: Error "MySQL server has gone away" when executing query "DELETE FROM icinga_comments WHERE instance_id = 1 AND session_token <> 1472520438" [2016-08-30 06:40:44 -0400] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational! [2016-08-30 06:40:44 -0400] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational! This was a known issue in icinga2, which has been fixed in a rather simple fix in version 2.6.3, see: Issue: https://github.com/icinga/icinga2/issues/4603 PR: https://github.com/Icinga/icinga2/pull/5025 for further information on this bug. Hopefully you consider backporting this fix to 2.6.0 as the appearance of this bug is quite unpredictable but nasty. Thank you. Regards, Luca Rodehutskors -- System Information: Debian Release: 9.2 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.9.0-4-amd64 (SMP w/4 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages icinga2-ido-mysql depends on: ii dbconfig-common 2.0.8 ii debconf [debconf-2.0] 1.5.61 ii icinga2-bin 2.6.0-2 ii icinga2-common 2.6.0-2 ii libboost-atomic1.62.0 1.62.0+dfsg-4 ii libboost-chrono1.62.0 1.62.0+dfsg-4 ii libboost-date-time1.62.0 1.62.0+dfsg-4 ii libboost-program-options1.62.0 1.62.0+dfsg-4 ii libboost-regex1.62.0 1.62.0+dfsg-4 ii libboost-system1.62.0 1.62.0+dfsg-4 ii libboost-thread1.62.0 1.62.0+dfsg-4 ii libc6 2.24-11+deb9u1 ii libgcc1 1:6.3.0-18 ii libicinga2 2.6.0-2 ii libmariadbclient18 10.1.26-0+deb9u1 ii libssl1.1 1.1.0f-3+deb9u1 ii libstdc++6 6.3.0-18 ii libyajl2 2.1.0-2+b3 ii ucf 3.0036 Versions of packages icinga2-ido-mysql recommends: ii mariadb-client-10.1 [virtual-mysql-client] 10.1.26-0+deb9u1 Versions of packages icinga2-ido-mysql suggests: ii default-mysql-server 1.0.2 ii mysql-server 5.5.9999+default -- debconf information excluded
