Join GitHub today
GitHub is home to over 31 million developers working together to host and review code, manage projects, and build software together.Sign up
[dev.icinga.com #4048] new restrictions and oracle: host and servicegroups weird (distinct) behaviour #1129
This issue has been migrated from Redmine: https://dev.icinga.com/issues/4048
Created by mfriedrich on 2013-05-04 12:15:59 +00:00
was testing #4002 with oracle with the new status cronk counter fix, when this came to mind. using
there are 01 - 05 in the overlapping 2 hostgroups. 02 is a member of _all, but is is not shown (not counted and not in grid).
basically all services for localhost02 as well as 01-01, 01-06 and 05-04 should be shown. they are not, 04 and 06 are missing for localhost02 (wtf?).
one could think - ok, overlapping problem. but apparently, it isn't. when i drop the overlapping, and let just restrict it by a single servicegroup, it's still broken - it only shows dummy01 and 07 instead of all for localhost02.
final test with only one hostgroup - weird, that one works.
my guess - something with the oracle distinct making is heavily broken when applying service and hostgroup restrictions.
Updated by mfriedrich on 2013-05-04 13:49:42 +00:00
Updated by mfriedrich on 2013-05-04 13:55:07 +00:00
ok, screw that. attached is the debug log with the queries from today. i cannot directly identify which query does what, but the identifier for the servicegroup is 3715sg_localhost02
Updated by mfrosch on 2013-05-05 20:00:51 +00:00
I wasn't really able to understand the problem here.
The same setup of credentials and Icinga config just work fine with MySQL backend.
Also the queries used by Icinga Web are more or less the same:
Does Oracle interpred IN differently?
Updated by mfrosch on 2013-10-02 16:10:14 +00:00
This issue is kind of hard to test and debug.
If anyone has this problem or could test this issue properly, we would appreciate input.
For now we can't assign a target version for a fix.