[Pkg-nagios-devel] Bug#881503: icinga2-ido-mysql: With too many comments, Icinga reload process won't finish reconnecting to Database

Luca Rodehutskors lucar at mail.uni-paderborn.de
Sun Nov 12 14:10:46 UTC 2017

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

[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.

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

More information about the Pkg-nagios-devel mailing list