Monitoring backend 'icinga' is not running. after server migration

Icinga 2
1

I have migrated my icinga2 from one instance to another, after importing the backup I am getting “Monitoring backend ‘icinga’ is not running.” in dashboard and in logs I am getting.

 Reconnecting to MySQL IDO database 'ido-mysql'
 Exception during database operation: Verify that your database is operational!
Schema version '1.14.2' does not match the required version '1.14.3' (or newer)! Please >
                                                                   Context:

while checking in the db with this

select instance_id,program_version,is_currently_running,endpoint_name,status_update_time from icinga_programstatus;
+-------------+-----------------+----------------------+---------------------+---------------------+
| instance_id | program_version | is_currently_running | endpoint_name       | status_update_time  |
+-------------+-----------------+----------------------+---------------------+---------------------+
|           1 | r2.7.0-1        |                    1 |icinga1.cloud.com | 2023-03-10 06:00:01 |
+-------------+-----------------+----------------------+---------------------+---------------------+

the new hostname is icinga2.cloud.com and the last update is also not changing,
what can be done to solve this?

2

Hi @hrai ,
First things first, there is this schema warning in the output you provided, could you upgrade the db schema?
https://icinga.com/docs/icinga-2/latest/doc/16-upgrading-icinga-2/#upgrading-mysql-db

3

thanks but when I do that all of the data in icingaweb2 is wiped out here arethe version details
new: (version: 2.13.2-1)
old: (version: r2.13.7-1)

4

sorry for the late response. The database should definitively not be wiped. How were you trying to update the scheme.