Icinga UI shows icinga is currently not up and running after deleting status_update_time and restarting icinga

Icinga 2
1

Hi team,

Icinga UI shows icinga is currently not up and running after deleting status_update_time and restarting icinga, we had to delete the Update time as the UI was showing backend is down, after the deletion and restart of icinga, the UI shows " icinga is currently not up and running"

2

What’s the output of systemctl status icinga2? ie; did Icinga2 actually start up when you restarted it?

3

Yes the icinga service is started and from the logs, got the following as well
[2021-10-25 21:40:25 +0530] information/WorkQueue: #7 (IdoMysqlConnection, ido-mysql) items: 0, rate: 992.433/s (59546/min 292
029/5min 858238/15min);
, however, in the db →

MariaDB [icinga]> select status_update_time from icinga_programstatus;
Empty set (0.00 sec)
,

ido-mysql file contents are as follows -

/**

  • The db_ido_mysql library implements IDO functionality
  • for MySQL.
    */

library “db_ido_mysql”

object IdoMysqlConnection “ido-mysql” {
//user = “icinga”
//password = “*****”
//host = “localhost”
//database = “icinga”
enable_ha = true

4

● icinga2.service - Icinga host/service/network monitoring system
Loaded: loaded (/usr/lib/systemd/system/icinga2.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2021-10-25 20:03:57 IST; 1h 39min ago
Process: 112911 ExecReload=/usr/lib/icinga2/safe-reload /etc/sysconfig/icinga2 (code=exited, status=0/SUCCESS)
Process: 63908 ExecStart=/usr/sbin/icinga2 daemon -d -e ${ICINGA2_ERROR_LOG} (code=exited, status=0/SUCCESS)
Process: 63829 ExecStartPre=/usr/lib/icinga2/prepare-dirs /etc/sysconfig/icinga2 (code=exited, status=0/SUCCESS)
Main PID: 63958 (icinga2)
CGroup: /system.slice/icinga2.service
├─63935 /usr/lib64/icinga2/sbin/icinga2 --no-stack-rlimit daemon -d -e /var/log/icinga2/error.log
└─63958 /usr/lib64/icinga2/sbin/icinga2 --no-stack-rlimit daemon -d -e /var/log/icinga2/error.log