Michael,

Thanks for your response. I will have a look at MySQL more closely and set up some monitoring graphs monitoring. I see debug options in icinga.cfg, ido2db.cfg and in idomo.cfg. Which one(s) will be most interesting?

On 5-10-2011 12:17, Michael Friedrich wrote:
M. Diemel wrote:
Alexander and others,

Thanks for your reply.
If MySQL is the problem, removing it is of course a way of solving. Because MySQL is our main database, using an another introduces others problems we might not prefer (we simply have more knowledge with MySQL). Icinga states it supports MySQL, PostgreSQL and Oracle (and states it in this order). Does it really? Is there a preferred or best tested databases? And is it not MySQL? I'm curious in what other people use as a database back-end and the experiences with it.

on my dev and test stages, all 3 work fine with a test config of 200 hosts and 4k services. the main change on the config dumps was bulk queries for various data to be inserted. probably the mysql server has some buffer issues? it would be interesting how the debug log reflects the queries to be inserted and how your mysql server peforms on that - any monitoring of that available? preferrably graphs.


Regards,
Maarten


On 5-10-2011 9:09, David Gerbec wrote:
Hi!

We have had the same issues with 1.5.x and MYSQL while on 1.4.x and MYSQL on the same amount of hosts/services things were running smooth.

Even tho the hardware stayed the same, the core OS has changed meaning the MYSQL version changed also so i can't really point a finger @Icinga for the issues.

I solved my problem with ditching MYSQL and using PostgreSQL. Things now work as they should.




Regards,
D.

On 10/05/2011 08:38 AM, alexander.hofm...@dfs.de wrote:
Hi,

we have the same problem at our site. It occurred the first time as we updated Icinga
to 1.5 and _loaded_ idomod. Without idomod everything works fine.



Mit freundlichen Grüßen

Alexander Hofmann, TM/SID
Datacenter
Tel.: (+49)6103 707 4505




Maarten Diemel <m.die...@hva.nl> schrieb am 04.10.2011 16:17:55:

> Von: Maarten Diemel <m.die...@hva.nl>
> An: icinga-users@lists.sourceforge.net
> Datum: 04.10.2011 16:52
> Betreff: [icinga-users] 442 seconds 'Status data OUTDATED' after reload
>
> Dear Icinga users and developers,
>
>
> After doing a 'service icinga reload'
> it looks like it takes about 442 seconds before the status data is 'updated'.
>
>
> Current Network Status
>
> Last Updated: Tue Oct 4 12:54:38 CEST 2011 - Updated every 90 seconds [pause]
>
> Icinga 1.5.1 - Logged in as Uncle.X
>
> Warning: Status data OUTDATED! Last status data update was 442 seconds ago!
>
>
> Should it take so long? Is this normal behavior for Icinga?
>
>
>
> System: HP blade 460c G7, with 2 Six-Core Intel Xeon, 2267 MHz and
> 8192 Mb memory.
> OS: Red Hat Enterprise Linux Server release 6.1 (Santiago)
> Icinga version 1.5.1 , RPM installation (RPM's are locally made from
> icinga.spec found in the official tarball)
> DB: MySQL 5.1.52
>
> Configuration is kept as close to the defaults as possible.
> Only icinga.cfg attached, other config files (ido stuff) unchanged
> except for db_socket and password.
>
> 476 hosts and
> 1691 services are being checked
>
> Machine seems not really busy, neither does our old server with
> exact configuration doing Nagios, running on a HP DL-385 (AMD), 2048
> Mb mem, on RHEL4.
>
> sar output of Icinga machine (period of reloading Icinga):
>
>                  CPU     %user     %nice   %system   %iowait    %
> steal     %idle
> 12:40:01 PM     all      1.71      0.00      0.60      1.09      0.
> 00     96.60
> 12:45:01 PM     all      1.80      0.00      0.63      1.24      0.
> 00     96.33
> 12:50:01 PM     all      1.16      0.00      0.37      2.34      0.
> 00     96.13
> 12:55:01 PM     all      0.61      0.00      0.08      2.43      0.
> 00     96.88
>
>
> Regards,
> Maarten
>
>
>
>
> [Anhang "icinga.cfg" gelöscht von Alexander Hofmann/DFS]
> ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users


DFS Deutsche Flugsicherung GmbH
Am DFS-Campus 10
D - 63225 Langen

Tel.: +49-(0)6103-707-0

Sitz der Gesellschaft: Langen/Hessen
Zuständiges Registergericht: AG Offenbach am Main, HRB 34977
Vorsitzender des Aufsichtsrates: Prof. Klaus-Dieter Scheurle
Geschäftsführer: Dieter Kaden (Vors.), Ralph Riedle, Jens Bergmann

Internet: http://www.dfs.de
Public-Key der DFS: http://www.dfs.de/dfs/public_key.asc


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

--
David Gerbec, sistemska podpora

Predlog! Obis(c(ite prenovljeno spletno stranhttp://www.agenda.si

ODPRTA KODA IN LINUX
STORITVE : POSLOVNE RESITVE : UPRAVLJANJE IT : INFRASTRUKTURA IT : 
IZOBRAZEVANJE : PROGRAMSKA OPREMA

Visit our updated web page athttp://www.agenda.si

OPEN SOURCE AND LINUX
SERVICES : BUSINESS SOLUTIONS : IT MANAGEMENT : IT INFRASTRUCTURE : TRAINING : 
SOFTWARE

"Windows is a 32-bit shell for a 16-bit extension to an 8-bit operating system 
designed for a 4-bit microprocessor by a 2-bit company that can't stand one bit of 
competition."


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users


--
Maarten Diemel
ITS - Stichting Hogeschool van Amsterdam
Amsteldijk 166
1079 LH Amsterdam
The Netherlands
+31 20 595 37 42


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users


--
DI (FH) Michael Friedrich

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

email:  michael.friedr...@univie.ac.at
phone:  +43 1 4277 14359
mobile: +43 664 60277 14359
fax:    +43 1 4277 14338
web:    http://www.univie.ac.at/zid
        http://www.aco.net

Icinga Core&  IDOUtils Developer
http://www.icinga.org


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users


--
Maarten Diemel
ITS - Stichting Hogeschool van Amsterdam
Amsteldijk 166
1079 LH Amsterdam
The Netherlands
+31 20 595 37 42

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

Reply via email to