Am 20.08.2015 um 11:24 schrieb Christian Moreno Moreno: 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). I'd say your database backend cannot deal with the amount of updates (config and status queries), and performs poorly. I would analyze your database performance and identify bottlenecks over there. Icinga Web 2 is just the reading application, you may simulate its queries directly on the shell as well. How many objects are configured in this setup? Kind regards, Michael 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 GmbH Ritterstraße 11 10969 Berlin, Deutschland Tel.: +49 (0)30 40 30 10 33 Fax: +49 (0)30 221 94 33<tel:%2B49%20%280%2930%20221%2094%2033> - 21 E-Mail: <mailto:christian.mor...@idealo.de> christian.mor...@idealo.de<mailto:christian.mor...@idealo.de> Geschäftsführer: Dr. Albrecht von Sonntag, Dr. Philipp-Christopher Peitsch HRB 76749 – Amtsgericht Berlin-Charlottenburg [idealo Logo]<http://www.idealo.de/> _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org<mailto:icinga-users@lists.icinga.org> https://lists.icinga.org/mailman/listinfo/icinga-users -- Michael Friedrich, DI (FH) Application Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | michael.friedr...@netways.de ** OSBConf 2015 - September - osbconf.org ** ** OSMC 2015 - November - netways.de/osmc **
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
