On 11.02.2014 16:59, CHRISTOPHE M.R. BURNOTTE wrote:
Hello,
I have a question as I'm having big troubles with Icinga since I
upgraded it to 1.10.2 (from 1.9.3).
The symptoms:
- Icinga core is starting up as quickly as before
- Icinga-web and NagiosBP takes hours to show something normal
(icinga-web shows nothing and NagiosBP is showing everything as critical)
- Ido2db give me lines like this in syslog:
Feb 11 16:33:48 kratos ido2db: IDO2DB proxy stats (p=0x1571de0):
left=60535614 bytes, right=0 bytes; iostats=80588552 bytes
That would mean that the mysql database is busy with queries not
processing any updates on the "right" sidewhile the queue on the left
explodes.
- Icinga is on a cluster (bi-xeon E5-2630), the Mysql db is on a
separate T4 server with lot of power and nearly all tables in ram.
There are 600 hosts, 17k services and about 120 users.
- On the mysql, as for debug, I can view lot of process like:
| 1267016 | nagios | icinga:46902 | nagios | Query | 0 |
Updating | UPDATE icinga_commenthistory SET comment_type=2,
entry_type=2, object_id=19961, author_name='user1', |
- This didn't happen with 1.9.3 (well, these symptomes lasted for
about 20 seconds)
Well I fucked up when changing a unique key on the commenthistory table
in 1.10 and the result was that a valid index being dropped. So far Tom
was the only one having that problem at a customer, so that schema
change was addressed for 1.11 and everyone. As a quickfix, you may still
apply the missing index creation manually.
https://dev.icinga.org/issues/4544 => https://dev.icinga.org/issues/4985
CREATE INDEX commenthistory_delete_idx ON icinga_commenthistory
(instance_id, comment_time, internal_comment_id);
[...]
Thanks a lot for your answers!
Thanks for the detailed information. Happens not that often ;-)
--
DI (FH) Michael Friedrich
michael.friedr...@gmail.com || icinga open source monitoring
https://twitter.com/dnsmichi || lead core developer
dnsmi...@jabber.ccc.de || https://www.icinga.org/team
irc.freenode.net/icinga || dnsmichi
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
