Hi All,

We use Icinga2 with icingaweb2:

Icinga2: Two nodes (cluster) and every node with the module ido-pgsql.
Icingaweb2: With two Backends in PGSQL(Backend IcingaDB and Backend
IcingawebDB)
Database: PGSQL

Version:
Icinga2:  2.3.8-1~debmon70+1
icingaweb2: 2.0.0~rc1-1~debmon70+1
Postgresql: 9.4.1-1.pgdg70+1

All runs correctly, but every time that we do one reload/restart of icinga2
then we have for some minutes the next Problems with Icingaweb2:
- Alarm "Backend Down"
- We cant see the Hostgroups, Downtimes, and some Custom variables.

After some minutes, then all looks one more time good.

I saw with "Icinga Cluster Check" that after one reload/restart, PGSQL get
a lot of more queries "idopgsqlconnection_pgsql-ido_query_queue_items"
(sometime sometimes until 250-300K, normally it has any or only 20-30).

Is this one Bug or I do something wrong? I have the feeling that PGSQL is
blocked for icingaweb2 until that the queries go down.
Wath type of rights needs icingaweb2's user for the Icinga2 DB? Are
sufficient read rights? I was thinking about use one of the Postgresql
Slave for the icinga2 Backend.

Best Regards,
Christian


Christian Moreno Moreno
System Engineer Offers

idealo internet GmbHRitterstraße 11
10969 Berlin, DeutschlandTel.: +49 (0)30 40 30 10 33Fax: +49 (0)30 221 94 33
- 21E-Mail: christian.moreno@idealo.deGeschäftsführer:Dr. Albrecht von
Sonntag, Dr. Philipp-Christopher PeitschHRB 76749 – Amtsgericht
Berlin-Charlottenburg[image: idealo Logo] <http://www.idealo.de/>
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users

Reply via email to