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

[Luca Rodehutskors]

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