Problems with Next check and reschedule

[blanka]

Hi folks,

We have a problem with the next check problems, some are on the past, other are negative and other are empty.
Also, when we try to reschedule it won’t update the value of the “Next check”.

Our setup is HA master-master icinga servers with 3 satellites. The icingaweb with director are on a separate server.

Icinga masters:
icinga2 - The Icinga 2 network monitoring daemon (version: 2.11.3-1)
System information:
Platform: Red Hat Enterprise Linux
Platform version: 8.1 (Ootpa)
Kernel: Linux
Kernel version: 4.18.0-147.el8.x86_64
Architecture: x86_64

Icinga satelittes:
icinga2 - The Icinga 2 network monitoring daemon (version: r2.10.5-1)
System information:
Platform: Red Hat Enterprise Linux Server
Platform version: 7.4 (Maipo)
Kernel: Linux
Kernel version: 3.10.0-693.21.1.el7.x86_64
Architecture: x86_64

Icinga Web 2 2.7.3
Git Commit 06cabfe8ba28cf545a42c92f25484383191a4e51
PHP Version 7.2.24
MODULE VERSION
director 1.7.2
graphite 1.1.0
incubator 0.5.0
ipl v0.5.0
monitoring 2.7.3
reactbundle 0.7.0

Thanks and regards.

[rsx (Roland Sommer)]

I’d assume a performance bottleneck due to your high check latency values. Many details can be found here.

[blanka]

We find that we have many errors of IDO Mysql on icinga2.log. We have an HAProxy — Galera Cluster. Anyone have already this issue?

critical/IdoMysqlConnection: Error “Duplicate entry ‘18236-2020-06-19 16:32:46.6296’ for key ‘PRIMARY’” when executing query …
UPDATE…
UPDATE…
UPDATE…
UPDATE…
UPDATE…
…
…
…
;COMMIT;BEGIN"
critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!

[blanka]

No one knowns what causes this error?

[2020-06-20 15:31:41 +0100] critical/IdoMysqlConnection: Error “Duplicate entry ‘22909-2020-06-20 14:31:17.3661’ for key ‘PRIMARY’” when executing query "UPDATE icinga-hoststatus
…
…