Hi,
I’m seeing this error in the icinga2.log
critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
critical/IdoMysqlConnection: Schema does not provide any valid version! Verify your schema installation.
I’ve icinga2 2.16 ( newly installed ) running with 2 masters and 2 satellites zones with 2x IDO Maria DB (10.11.14) hosts with ‘enable_ha = true’ and Icingaweb2 v2.13
After creating the ‘icinga’ and ‘icingaweb2’ DBs. I applied the schemas
/usr/share/icinga2-ido-mysql/schema/mysql.sql
/usr/share/icingaweb2/schema/mysql.schema.sql
Took the dump of DB using and copied to the slave DB.
mysqldump --master-data=2 -u root -p --no-data --databases icinga icingaweb2 > /tmp/dbsbackup.sql
Enabled the DB replication (GTID enabled) from the active DB host to inactive DB ( start slave;) and the replIcation appered working normal. Later on I enabled the replication other way around which I appreared working normal. Then I restarted ‘icinga2’ service on both masters and both of them are showing the above errors. On the active DB, somehow ‘icinga_dbversion’ table don’t have the version entry. The entry exist on the slave.
MariaDB [icinga]> select * from icinga_dbversion;
Empty set (0.000 sec)MariaDB [icinga]>
MariaDB [icinga]> select * from icinga_dbversion
→ ;
±-------------±---------±--------±--------------------±--------------------+
| dbversion_id | name | version | create_time | modify_time |
±-------------±---------±--------±--------------------±--------------------+
| 1 | idoutils | 1.15.1 | 2026-04-28 14:11:55 | 2026-04-28 14:11:55 |
±-------------±---------±--------±--------------------±--------------------+
1 row in set (0.001 sec)MariaDB [icinga]>
Any idea what would cause this trouble?
Thanks