[dev.icinga.com #2131] In ServiceStatus Cronk only the first Host with problematic Services is displayed: #593
This issue has been migrated from Redmine: https://dev.icinga.com/issues/2131
Created by armin on 2011-12-01 08:38:34 +00:00
I have 3 Hosts with Warning Services which is correctly displayed in the status cronk, but only one host (the first in alphapetical order) is displayed in the ServiceStatus Cronk (Debian Squeeze with Icinga 1.5.1 from squeeze backports and latest 1.6 icinga-web. I had the same problem with 1.5.1 and 1.5.2 icinga-web).
I have a working system for testing (1.5.2) but if i change the database.xml to point to the production system it has the same error, so it is difficult for me to locate the error.
I have logged the queries in mysql, the first looks right and finds all open warnings:
the second query should have all Service ID's as criteria in the "WHERE (i.service_object_id IN ('977'))" clause i think but it only has one:
Updated by armin on 2011-12-01 14:08:06 +00:00
It may has to do with json under Debian:
I will try the virtual applicance with my database.
Updated by armin on 2011-12-12 11:13:20 +00:00
I found the reason for the error, it has to do with "check_multi", if i enable the option "-r 2" several HTML Tags are added to the Output of a Plugin and stored in the Table "icinga_servicestatus.output", Icinga has Problems with the verbose Output, as a second result the column "Duration" displays a "0" value as result for the only row displayed in the cronk as described above.
Updated by armin on 2011-12-12 13:47:21 +00:00
The type of the field "icinga_servicestatus.output" in the icinga Database is "varchar(255)" and is to short for the output of "check_multi -r 2". In my testsystem the type of the field is "text" and it works with the "-r 2" option.
Updated by armin on 2011-12-13 14:45:59 +00:00
I have updated my IDO Database, may you could include the following Database Update in new idodb versions:
ALTER TABLE `icinga_servicestatus` MODIFY COLUMN `output` text NULL;
Please close the issue when done!