Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #4048] new restrictions and oracle: host and servicegroups weird (distinct) behaviour #1129

Closed
icinga-migration opened this issue May 4, 2013 · 11 comments
Closed

[dev.icinga.com #4048] new restrictions and oracle: host and servicegroups weird (distinct) behaviour #1129

icinga-migration opened this issue May 4, 2013 · 11 comments
Labels
bug Database & Queries

Comments

@icinga-migration
Copy link

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

Assignee: (none)
Status: Closed (closed on 2015-04-26 09:03:06 +00:00)
Target Version: (none)
Last Update: 2015-04-26 09:03:06 +00:00 (in Redmine)

Icinga Version: 1.9.0beta
Icinga Web Version: 1.9.0pre
IDO Version: 1.9.0beta
OS Version: Debian 6.0.7 x64
DB Type: Oracle
DB Version: 11.2
Browser Version: any

was testing #4002 with oracle with the new status cronk counter fix, when this came to mind. using

commit b982b4f53a33b6ea1efb43eace9cf7bbd29d5157
Author: Markus Frosch 
Date:   Tue Apr 30 17:44:21 2013 +0200

    Fix duplication problem in StatusSummary Cronk

    caused by 1-n credential joins

    refs #3715
    refs #4002
  • overlapping hostgroup
define hostgroup {
        hostgroup_name                  3715_all
        members                         3715localhost01,3715localhost02,3715localhost03,3715localhost04,3715localhost05
}

define hostgroup {
        hostgroup_name                  3715_35
        members                         3715localhost03,3715localhost05
}

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).

icinga_web_1.9_oracle_permissions_hg_overlapping_missing_3715localhost02.png

  • overlapping servicegroups
define servicegroup {
        servicegroup_name               3715sg_many
        members                         3715localhost01,3715dummy01,3715localhost02,3715dummy02,3715localhost02,3715dummy03,3715localhost05,3715dummy04,3715localhost02,3715dummy05,3715localhost01,3715dummy06
}

define servicegroup {
        servicegroup_name               3715sg_localhost02
        members                         3715localhost02,3715dummy01,3715localhost02,3715dummy02,3715localhost02,3715dummy03,3715localhost02,3715dummy04,3715localhost02,3715dummy05,3715localhost02,3715dummy06,3715localhost02,3715dummy07
}

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?).

icinga_web_1.9_oracle_permissions_sg_overlapping_missing_3715localhost02_3715dummy04_06.png

  • single servicegroup
define servicegroup {
        servicegroup_name               3715sg_localhost02
        members                         3715localhost02,3715dummy01,3715localhost02,3715dummy02,3715localhost02,3715dummy03,3715localhost02,3715dummy04,3715localhost02,3715dummy05,3715localhost02,3715dummy06,3715localhost02,3715dummy07
}

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.

icinga_web_1.9_oracle_permissions_sg_3715localhost02_only01_07.png

  • single hostgroup
define hostgroup {
        hostgroup_name                  3715_35
        members                         3715localhost03,3715localhost05
}

final test with only one hostgroup - weird, that one works.

icinga_web_1.9_oracle_permissions_hg_not_overlapping_ok.png

my guess - something with the oracle distinct making is heavily broken when applying service and hostgroup restrictions.

Attachments

Relations:
@icinga-migration
Copy link
Author

Updated by mfriedrich on 2013-05-04 13:49:42 +00:00

Some logs

[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"oh.name1"}},{"name":"IcingaService","type":"MultiLike","affects":"service","params":{"target":"IcingaService","column":"os.name2"}},{"name":"IcingaServicegroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"innerjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"h.hostgroups hg"},{"type":"innerjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaContactgroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"\n                    s.contactgroups cg\n                "},{"type":"orwhere","arg":"\n                    \n                    cg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"h","target":"host"}},{"name":"IcingaServiceCustomVariablePair","type":"CustomVariable","affects":"service","params":{"alias":"s","target":"service"}}]
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying dql sequence [{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"innerjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(s.servicegroups sg)
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(s.servicegroups sg): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->innerjoin(sg.object osg)
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->innerjoin(sg.object osg): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                )
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                ): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]] OR o3.name1 IN ('3715sg_localhost02')) 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_HOST for data retrieval

[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_HOST for data retrieval
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT
                a.current_state,
                a.has_been_checked,
                a.should_be_scheduled,
                a.scheduled_downtime_depth,
                a.problem_has_been_acknowledged,
                a.passive_checks_enabled,
                a.active_checks_enabled,
                count(DISTINCT x.host_object_id) as count
            FROM IcingaHosts x
            LEFT JOIN x.status a
            LEFT JOIN x.object o
            GROUP BY a.current_state,
                     a.has_been_checked,
                     a.should_be_scheduled, a.scheduled_downtime_depth,
                     a.problem_has_been_acknowledged, a.passive_checks_enabled,
                     a.active_checks_enabled


[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"o.name1"}},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"x.hostgroups hg"},{"type":"leftjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaContactgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"\n                    x.contactgroups cg\n                "},{"type":"orwhere","arg":"\n                    \n                    cg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"x","target":"host"}}]
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' AND ( o3.name1 IN ('3715sg_localhost02') ))
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::parseDependencies()@84 : Merge dependency detected: TARGET_SERVICE -> TARGET_SERVICE_BLOBFIELDS 
[Sat May  4 13:43:14 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT h2.current_state AS h2__current_state, h2.has_been_checked AS h2__has_been_checked, h2.should_be_scheduled AS h2__should_be_scheduled, h2.scheduled_downtime_depth AS h2__scheduled_downtime_depth, h2.problem_has_been_acknowledged AS h2__problem_has_been_acknowledged, h2.passive_checks_enabled AS h2__passive_checks_enabled, h2.active_checks_enabled AS h2__active_checks_enabled, COUNT(DISTINCT h.host_object_id) AS h__0 FROM hosts h LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id LEFT JOIN objects o ON h.host_object_id = o.object_id GROUP BY h2.current_state,                      h2.has_been_checked,                      h2.should_be_scheduled, h2.scheduled_downtime_depth,                      h2.problem_has_been_acknowledged, h2.passive_checks_enabled,                      h2.active_checks_enabled, h2.current_state, h2.has_been_checked, h2.should_be_scheduled, h2.scheduled_downtime_depth, h2.problem_has_been_acknowledged, h2.passive_checks_enabled, h2.active_checks_enabled
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_SERVICE for data retrieval

[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT
                a.current_state,
                a.has_been_checked,
                a.should_be_scheduled,
                a.scheduled_downtime_depth,
                a.problem_has_been_acknowledged,
                a.passive_checks_enabled,
                a.active_checks_enabled,
                count(DISTINCT x.service_object_id) as count,
                hs.current_state,
                hs.scheduled_downtime_depth,
                hs.problem_has_been_acknowledged
            FROM IcingaServices x
            LEFT JOIN x.object o
            LEFT JOIN x.status a
            LEFT JOIN x.host h
            LEFT JOIN h.status hs
            GROUP BY hs.current_state,
                     hs.scheduled_downtime_depth,
                     hs.problem_has_been_acknowledged,
                     a.current_state,
                     a.has_been_checked,
                     a.should_be_scheduled, a.scheduled_downtime_depth,
                     a.problem_has_been_acknowledged, a.passive_checks_enabled,
                     a.active_checks_enabled


[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"o.name1"}},{"name":"IcingaService","type":"MultiLike","affects":"service","params":{"target":"IcingaService","column":"o.name2"}},{"name":"IcingaServicegroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"x.servicegroups sg"},{"type":"leftjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"h.hostgroups hg"},{"type":"leftjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaContactgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"\n                    x.contactgroups cg\n                "},{"type":"orwhere","arg":"\n                    \n                    cg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"h","target":"host"}},{"name":"IcingaServiceCustomVariablePair","type":"CustomVariable","affects":"service","params":{"alias":"x","target":"service"}}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying dql sequence [{"type":"leftjoin","arg":"x.servicegroups sg"},{"type":"leftjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(x.servicegroups sg)
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(x.servicegroups sg): SELECT s2.current_state AS s2__current_state, s2.has_been_checked AS s2__has_been_checked, s2.should_be_scheduled AS s2__should_be_scheduled, s2.scheduled_downtime_depth AS s2__scheduled_downtime_depth, s2.problem_has_been_acknowledged AS s2__problem_has_been_acknowledged, s2.passive_checks_enabled AS s2__passive_checks_enabled, s2.active_checks_enabled AS s2__active_checks_enabled, h2.current_state AS h2__current_state, h2.scheduled_downtime_depth AS h2__scheduled_downtime_depth, h2.problem_has_been_acknowledged AS h2__problem_has_been_acknowledged, COUNT(DISTINCT s.service_object_id) AS s__0 FROM services s LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]]) GROUP BY h2.current_state,                      h2.scheduled_downtime_depth,                      h2.problem_has_been_acknowledged,                      s2.current_state,                      s2.has_been_checked,                      s2.should_be_scheduled, s2.scheduled_downtime_depth,                      s2.problem_has_been_acknowledged, s2.passive_checks_enabled,                      s2.active_checks_enabled, s2.current_state, s2.has_been_checked, s2.should_be_scheduled, s2.scheduled_downtime_depth, s2.problem_has_been_acknowledged, s2.passive_checks_enabled, s2.active_checks_enabled, h2.current_state, h2.scheduled_downtime_depth, h2.problem_has_been_acknowledged 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(sg.object osg)
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_HOST_COUNTS for data retrieval
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 

[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT
                COUNT(DISTINCT CASE WHEN hs.active_checks_enabled = 1
                                    THEN hs.host_object_id
                                    ELSE NULL END
                ) AS host_checks_active,
                COUNT(DISTINCT CASE WHEN hs.passive_checks_enabled = 1
                                    AND hs.active_checks_enabled = 0
                                    THEN hs.host_object_id
                                    ELSE NULL END
                ) AS host_checks_passive,
                COUNT(DISTINCT CASE WHEN hs.passive_checks_enabled = 0
                                    AND hs.active_checks_enabled = 0
                                    THEN hs.host_object_id
                                    ELSE NULL END
                ) AS host_checks_disabled
            FROM IcingaHosts h
            LEFT JOIN h.object o
            LEFT JOIN h.status hs


[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(sg.object osg): SELECT s2.current_state AS s2__current_state, s2.has_been_checked AS s2__has_been_checked, s2.should_be_scheduled AS s2__should_be_scheduled, s2.scheduled_downtime_depth AS s2__scheduled_downtime_depth, s2.problem_has_been_acknowledged AS s2__problem_has_been_acknowledged, s2.passive_checks_enabled AS s2__passive_checks_enabled, s2.active_checks_enabled AS s2__active_checks_enabled, h2.current_state AS h2__current_state, h2.scheduled_downtime_depth AS h2__scheduled_downtime_depth, h2.problem_has_been_acknowledged AS h2__problem_has_been_acknowledged, COUNT(DISTINCT s.service_object_id) AS s__0 FROM services s LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]]) GROUP BY h2.current_state,                      h2.scheduled_downtime_depth,                      h2.problem_has_been_acknowledged,                      s2.current_state,                      s2.has_been_checked,                      s2.should_be_scheduled, s2.scheduled_downtime_depth,                      s2.problem_has_been_acknowledged, s2.passive_checks_enabled,                      s2.active_checks_enabled, s2.current_state, s2.has_been_checked, s2.should_be_scheduled, s2.scheduled_downtime_depth, s2.problem_has_been_acknowledged, s2.passive_checks_enabled, s2.active_checks_enabled, h2.current_state, h2.scheduled_downtime_depth, h2.problem_has_been_acknowledged 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                )
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"o.name1"}},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"h.hostgroups hg"},{"type":"leftjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostContactgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"\n                    h.contactgroups hcg\n                "},{"type":"orwhere","arg":"\n                    \n                    hcg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"h","target":"host"}}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                ): SELECT s2.current_state AS s2__current_state, s2.has_been_checked AS s2__has_been_checked, s2.should_be_scheduled AS s2__should_be_scheduled, s2.scheduled_downtime_depth AS s2__scheduled_downtime_depth, s2.problem_has_been_acknowledged AS s2__problem_has_been_acknowledged, s2.passive_checks_enabled AS s2__passive_checks_enabled, s2.active_checks_enabled AS s2__active_checks_enabled, h2.current_state AS h2__current_state, h2.scheduled_downtime_depth AS h2__scheduled_downtime_depth, h2.problem_has_been_acknowledged AS h2__problem_has_been_acknowledged, COUNT(DISTINCT s.service_object_id) AS s__0 FROM services s LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]] OR o2.name1 IN ('3715sg_localhost02')) GROUP BY h2.current_state,                      h2.scheduled_downtime_depth,                      h2.problem_has_been_acknowledged,                      s2.current_state,                      s2.has_been_checked,                      s2.should_be_scheduled, s2.scheduled_downtime_depth,                      s2.problem_has_been_acknowledged, s2.passive_checks_enabled,                      s2.active_checks_enabled, s2.current_state, s2.has_been_checked, s2.should_be_scheduled, s2.scheduled_downtime_depth, s2.problem_has_been_acknowledged, s2.passive_checks_enabled, s2.active_checks_enabled, h2.current_state, h2.scheduled_downtime_depth, h2.problem_has_been_acknowledged 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT s2.current_state AS s2__current_state, s2.has_been_checked AS s2__has_been_checked, s2.should_be_scheduled AS s2__should_be_scheduled, s2.scheduled_downtime_depth AS s2__scheduled_downtime_depth, s2.problem_has_been_acknowledged AS s2__problem_has_been_acknowledged, s2.passive_checks_enabled AS s2__passive_checks_enabled, s2.active_checks_enabled AS s2__active_checks_enabled, h2.current_state AS h2__current_state, h2.scheduled_downtime_depth AS h2__scheduled_downtime_depth, h2.problem_has_been_acknowledged AS h2__problem_has_been_acknowledged, COUNT(DISTINCT s.service_object_id) AS s__0 FROM services s LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ( o2.name1 IN ('3715sg_localhost02') ) GROUP BY h2.current_state,                      h2.scheduled_downtime_depth,                      h2.problem_has_been_acknowledged,                      s2.current_state,                      s2.has_been_checked,                      s2.should_be_scheduled, s2.scheduled_downtime_depth,                      s2.problem_has_been_acknowledged, s2.passive_checks_enabled,                      s2.active_checks_enabled, s2.current_state, s2.has_been_checked, s2.should_be_scheduled, s2.scheduled_downtime_depth, s2.problem_has_been_acknowledged, s2.passive_checks_enabled, s2.active_checks_enabled, h2.current_state, h2.scheduled_downtime_depth, h2.problem_has_been_acknowledged
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT COUNT(DISTINCT CASE WHEN h2.active_checks_enabled = 1                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__0, COUNT(DISTINCT CASE WHEN h2.passive_checks_enabled = 1                                     AND h2.active_checks_enabled = 0                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__1, COUNT(DISTINCT CASE WHEN h2.passive_checks_enabled = 0                                     AND h2.active_checks_enabled = 0                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__2 FROM hosts h LEFT JOIN objects o ON h.host_object_id = o.object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_SERVICE_COUNTS for data retrieval
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT
                COUNT(DISTINCT CASE WHEN ss.active_checks_enabled = 1
                                    THEN ss.service_object_id
                                    ELSE NULL END
                ) AS service_checks_active,
                COUNT(DISTINCT CASE WHEN ss.passive_checks_enabled = 1
                                    AND ss.active_checks_enabled = 0
                                    THEN ss.service_object_id ELSE NULL END
                ) AS service_checks_passive,
                COUNT(DISTINCT CASE WHEN ss.passive_checks_enabled = 0
                                    AND ss.active_checks_enabled = 0
                                    THEN ss.service_object_id
                                    ELSE NULL END
                ) AS service_checks_disabled
            FROM IcingaServices s
            LEFT JOIN s.host h
            LEFT JOIN s.object o
            LEFT JOIN s.status ss


[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"o.name1"}},{"name":"IcingaService","type":"MultiLike","affects":"service","params":{"target":"IcingaService","column":"o.name2"}},{"name":"IcingaServicegroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"leftjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"h.hostgroups hg"},{"type":"leftjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostContactgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"\n                    h.contactgroups hcg\n                "},{"type":"orwhere","arg":"\n                    \n                    hcg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaServiceContactgroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"\n                    s.contactgroups cg\n                "},{"type":"orwhere","arg":"\n                    \n                    cg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"h","target":"host"}},{"name":"IcingaServiceCustomVariablePair","type":"CustomVariable","affects":"service","params":{"alias":"s","target":"service"}}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying dql sequence [{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"leftjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(s.servicegroups sg)
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(s.servicegroups sg): SELECT COUNT(DISTINCT CASE WHEN s2.active_checks_enabled = 1                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__0, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 1                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id ELSE NULL END) AS s2__1, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 0                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__2 FROM services s LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(sg.object osg)
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(sg.object osg): SELECT COUNT(DISTINCT CASE WHEN s2.active_checks_enabled = 1                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__0, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 1                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id ELSE NULL END) AS s2__1, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 0                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__2 FROM services s LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                )
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                ): SELECT COUNT(DISTINCT CASE WHEN s2.active_checks_enabled = 1                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__0, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 1                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id ELSE NULL END) AS s2__1, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 0                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__2 FROM services s LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ([[CREDSTART]] [[CREDEND]] [[CREDSTART]] OR o2.name1 IN ('3715sg_localhost02')) 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT COUNT(DISTINCT CASE WHEN s2.active_checks_enabled = 1                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__0, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 1                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id ELSE NULL END) AS s2__1, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 0                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__2 FROM services s LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ( o2.name1 IN ('3715sg_localhost02') )
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getResult()@53 : Processing query SELECT COUNT(DISTINCT CASE WHEN h2.active_checks_enabled = 1                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__0, COUNT(DISTINCT CASE WHEN h2.passive_checks_enabled = 1                                     AND h2.active_checks_enabled = 0                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__1, COUNT(DISTINCT CASE WHEN h2.passive_checks_enabled = 0                                     AND h2.active_checks_enabled = 0                                     THEN h2.host_object_id                                     ELSE NULL END) AS h2__2 FROM hosts h LEFT JOIN objects o ON h.host_object_id = o.object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getResult()@53 : Result for view TARGET_SUMMARY_HOST_COUNTS : [{"host_checks_active":"272","host_checks_passive":"0","host_checks_disabled":"0"}]
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getResult()@54 : Processing query SELECT COUNT(DISTINCT CASE WHEN s2.active_checks_enabled = 1                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__0, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 1                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id ELSE NULL END) AS s2__1, COUNT(DISTINCT CASE WHEN s2.passive_checks_enabled = 0                                     AND s2.active_checks_enabled = 0                                     THEN s2.service_object_id                                     ELSE NULL END) AS s2__2 FROM services s LEFT JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN objects o ON s.service_object_id = o.object_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id LEFT JOIN objects o2 ON s3.servicegroup_object_id = o2.object_id WHERE ( o2.name1 IN ('3715sg_localhost02') ) 
[Sat May  4 13:43:15 2013] [debug] API_Views_ApiDQLViewModel::getResult()@54 : Result for view TARGET_SUMMARY_SERVICE_COUNTS : [{"service_checks_active":"2","service_checks_passive":"0","service_checks_disabled":"0"}]
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SERVICE for data retrieval
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [["${retained_flag}"],["retained_flag"]] 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT DISTINCT
                s.icon_image AS SERVICE_ICON_IMAGE,
                i.instance_name AS INSTANCE_NAME,
                h.host_object_id AS HOST_OBJECT_ID,
                s.service_object_id AS SERVICE_OBJECT_ID,
                oh.name1 AS HOST_NAME,
                h.alias AS HOST_ALIAS,
                h.display_name AS HOST_DISPLAY_NAME,
                os.name2 AS SERVICE_NAME,
                s.display_name AS SERVICE_DISPLAY_NAME,
                ss.process_performance_data AS SERVICE_PROCESS_PERFORMANCE_DATA,
                COALESCE(ss.current_state,0) AS SERVICE_CURRENT_STATE,
                COALESCE(ss.current_state,0) AS SERVICE_STATUS,
                ss.last_hard_state AS SERVICE_HARD_STATE,
                hs.last_hard_state AS HOST_HARD_STATE,
                COALESCE(hs.current_state,0) AS HOST_CURRENT_STATE,
                (CASE WHEN ss.last_state_change<='1970-01-01 00:00:00' THEN ps.program_start_time ELSE ss.last_state_change END) as DURATION_START,
                ps.program_start_time AS SERVICE_PROGRAM_START_TIME,
                ss.last_check AS SERVICE_LAST_CHECK,
                ss.next_check AS SERVICE_NEXT_CHECK,
                ss.current_check_attempt AS SERVICE_CURRENT_CHECK_ATTEMPT,
                ss.max_check_attempts AS service_max_attempt,
                i.instance_id AS SERVICE_INSTANCE_ID,
                s.service_id AS SERVICE_ID,
                ss.notifications_enabled as notifications_enabled,
                ss.problem_has_been_acknowledged as problem_acknowledged,
                ss.scheduled_downtime_depth as scheduled_downtime_depth,
                s.action_url AS SERVICE_ACTION_URL,
                h.notes as HOST_NOTES,
                h.notes_url AS HOST_NOTES_URL,
                s.notes as SERVICE_NOTES,
                s.notes_url AS SERVICE_NOTES_URL,
                COALESCE(ss.has_been_checked,0) as service_has_been_checked
            FROM IcingaServices s
            INNER JOIN s.instance i
            LEFT JOIN s.status ss
            INNER JOIN s.host h
            LEFT JOIN h.status hs
            INNER JOIN h.object oh
            INNER JOIN s.object os
            INNER JOIN i.programstatus as ps

            WHERE s.config_type = '1'


[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: [{"name":"IcingaHost","type":"MultiLike","affects":"host","params":{"target":"IcingaHost","column":"oh.name1"}},{"name":"IcingaService","type":"MultiLike","affects":"service","params":{"target":"IcingaService","column":"os.name2"}},{"name":"IcingaServicegroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"innerjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaHostgroup","type":"dql","affects":"host","calls":[{"type":"leftjoin","arg":"h.hostgroups hg"},{"type":"innerjoin","arg":"hg.object ohg"},{"type":"orwhere","arg":"\n                    \n                        ohg.name1 IN (${credential_value})\n                    \n                "}]},{"name":"IcingaContactgroup","type":"dql","affects":"service","calls":[{"type":"leftjoin","arg":"\n                    s.contactgroups cg\n                "},{"type":"orwhere","arg":"\n                    \n                    cg.contactgroup_id  IN (${TARGET_CONTACTGROUPS.contactgroup_id})\n                    \n                "}]},{"name":"IcingaHostCustomVariablePair","type":"CustomVariable","affects":"host","params":{"alias":"h","target":"host"}},{"name":"IcingaServiceCustomVariablePair","type":"CustomVariable","affects":"service","params":{"alias":"s","target":"service"}}]
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying dql sequence [{"type":"leftjoin","arg":"s.servicegroups sg"},{"type":"innerjoin","arg":"sg.object osg"},{"type":"orwhere","arg":"\n                    \n                        osg.name1 IN (${credential_value})\n                    \n                "}]
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->leftjoin(s.servicegroups sg)
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->leftjoin(s.servicegroups sg): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->innerjoin(sg.object osg)
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->innerjoin(sg.object osg): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]]) 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [[],[]] 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : Applying call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                )
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyDQLCalls()@238 : After call query->orwhere(

                        osg.name1 IN ('3715sg_localhost02')

                ): SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' [[CREDSTART]] [[CREDEND]] [[CREDSTART]] OR o3.name1 IN ('3715sg_localhost02')) 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' AND ( o3.name1 IN ('3715sg_localhost02') ))
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::parseDependencies()@84 : Merge dependency detected: TARGET_SERVICE -> TARGET_SERVICE_BLOBFIELDS 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getResult()@82 : Processing query SELECT a.* FROM ( SELECT DISTINCT s.icon_image AS s__0, i.instance_name AS i__1, h.host_object_id AS h__2, s.service_object_id AS s__3, o.name1 AS o__4, h.alias AS h__5, h.display_name AS h__6, o2.name2 AS o2__7, s.display_name AS s__8, s2.process_performance_data AS s2__9, COALESCE(s2.current_state, 0) AS s2__10, COALESCE(s2.current_state, 0) AS s2__11, s2.last_hard_state AS s2__12, h2.last_hard_state AS h2__13, COALESCE(h2.current_state, 0) AS h2__14, (CASE WHEN s2.last_state_change<='1970-01-01 00:00:00' THEN p.program_start_time ELSE s2.last_state_change END) AS s__15, p.program_start_time AS p__16, s2.last_check AS s2__17, s2.next_check AS s2__18, s2.current_check_attempt AS s2__19, s2.max_check_attempts AS s2__20, i.instance_id AS i__21, s.service_id AS s__22, s2.notifications_enabled AS s2__23, s2.problem_has_been_acknowledged AS s2__24, s2.scheduled_downtime_depth AS s2__25, s.action_url AS s__26, h.notes AS h__27, h.notes_url AS h__28, s.notes AS s__29, s.notes_url AS s__30, COALESCE(s2.has_been_checked, 0) AS s2__31 FROM services s INNER JOIN instances i ON s.instance_id = i.instance_id LEFT JOIN servicestatus s2 ON s.service_object_id = s2.service_object_id INNER JOIN hosts h ON s.host_object_id = h.host_object_id LEFT JOIN hoststatus h2 ON h.host_object_id = h2.host_object_id INNER JOIN objects o ON h.host_object_id = o.object_id INNER JOIN objects o2 ON s.service_object_id = o2.object_id INNER JOIN programstatus p ON i.instance_id = p.instance_id LEFT JOIN servicegroup_members s4 ON (s.service_object_id = s4.service_object_id) LEFT JOIN servicegroups s3 ON s3.servicegroup_id = s4.servicegroup_id INNER JOIN objects o3 ON s3.servicegroup_object_id = o3.object_id WHERE (s.config_type = '1' AND ( o3.name1 IN ('3715sg_localhost02') )) ORDER BY o.name1 ASC ) a WHERE ROWNUM <= 25 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getResult()@82 : Result for view TARGET_SERVICE : [{"SERVICE_ICON_IMAGE":null,"INSTANCE_NAME":"icinga-dev","HOST_OBJECT_ID":"4488","SERVICE_OBJECT_ID":"4502","HOST_NAME":"3715localhost02","HOST_ALIAS":"3715localhost02","HOST_DISPLAY_NAME":"3715localhost02","SERVICE_NAME":"3715dummy01","SERVICE_DISPLAY_NAME":"3715dummy01","SERVICE_PROCESS_PERFORMANCE_DATA":"1","SERVICE_CURRENT_STATE":"0","SERVICE_STATUS":"0","SERVICE_HARD_STATE":"0","HOST_HARD_STATE":"0","HOST_CURRENT_STATE":"0","DURATION_START":"2013-04-28 20:37:25","SERVICE_PROGRAM_START_TIME":"2013-05-04 13:43:21","SERVICE_LAST_CHECK":"2013-05-04 15:38:46","SERVICE_NEXT_CHECK":"2013-05-04 15:45:46","SERVICE_CURRENT_CHECK_ATTEMPT":"1","service_max_attempt":"3","SERVICE_INSTANCE_ID":"2","SERVICE_ID":"112790","notifications_enabled":"1","problem_acknowledged":"0","scheduled_downtime_depth":"0","SERVICE_ACTION_URL":null,"HOST_NOTES":null,"HOST_NOTES_URL":null,"SERVICE_NOTES":null,"SERVICE_NOTES_URL":null,"service_has_been_checked":"1"},{"SERVICE_ICON_IMAGE":null,"INSTANCE_NAME":"icinga-dev","HOST_OBJECT_ID":"4488","SERVICE_OBJECT_ID":"4508","HOST_NAME":"3715localhost02","HOST_ALIAS":"3715localhost02","HOST_DISPLAY_NAME":"3715localhost02","SERVICE_NAME":"3715dummy07","SERVICE_DISPLAY_NAME":"3715dummy07","SERVICE_PROCESS_PERFORMANCE_DATA":"1","SERVICE_CURRENT_STATE":"0","SERVICE_STATUS":"0","SERVICE_HARD_STATE":"0","HOST_HARD_STATE":"0","HOST_CURRENT_STATE":"0","DURATION_START":"2013-04-28 20:37:26","SERVICE_PROGRAM_START_TIME":"2013-05-04 13:43:21","SERVICE_LAST_CHECK":"2013-05-04 15:41:31","SERVICE_NEXT_CHECK":"2013-05-04 15:48:31","SERVICE_CURRENT_CHECK_ATTEMPT":"1","service_max_attempt":"3","SERVICE_INSTANCE_ID":"2","SERVICE_ID":"112796","notifications_enabled":"1","problem_acknowledged":"0","scheduled_downtime_depth":"0","SERVICE_ACTION_URL":null,"HOST_NOTES":null,"HOST_NOTES_URL":null,"SERVICE_NOTES":null,"SERVICE_NOTES_URL":null,"service_has_been_checked":"1"}]
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SERVICE_BLOBFIELDS for data retrieval
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::initialize()@441 : Switching to connection icinga
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getQueryTokens()@354 : Replacing tokens [["${TARGET_SERVICE.SERVICE_OBJECT_ID}"],["TARGET_SERVICE.SERVICE_OBJECT_ID"]] 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::resolveReferenceToken()@368 : View TARGET_SERVICE_BLOBFIELDS requires field SERVICE_OBJECT_ID from view TARGET_SERVICE
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Parsing DQL Query: 

            SELECT
                ss.service_object_id AS SERVICE_OBJECT_ID,
                ss.output AS SERVICE_OUTPUT,
                ss.long_output AS SERVICE_LONG_OUTPUT,
                ss.perfdata AS SERVICE_PERFORMANCE_DATA
            FROM IcingaServicestatus ss
            WHERE ss.service_object_id IN ('4502','4508')


[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::applyCredentials()@202 : Parsing credentials: []
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::createDQL()@183 : Query : SELECT s.service_object_id AS s__0, s.output AS s__1, s.long_output AS s__2, s.perfdata AS s__3 FROM servicestatus s WHERE (s.service_object_id IN ('4502', '4508'))
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getResult()@48 : Processing query SELECT s.service_object_id AS s__0, s.output AS s__1, s.long_output AS s__2, s.perfdata AS s__3 FROM servicestatus s WHERE (s.service_object_id IN ('4502', '4508')) 
[Sat May  4 13:43:16 2013] [debug] API_Views_ApiDQLViewModel::getResult()@48 : Result for view TARGET_SERVICE_BLOBFIELDS : [{"SERVICE_OBJECT_ID":"4502","SERVICE_OUTPUT":"OK","SERVICE_LONG_OUTPUT":null,"SERVICE_PERFORMANCE_DATA":null},{"SERVICE_OBJECT_ID":"4508","SERVICE_OUTPUT":"OK","SERVICE_LONG_OUTPUT":null,"SERVICE_PERFORMANCE_DATA":null}]
[Sat May  4 13:44:14 2013] [debug] API_Views_ApiDQLViewModel::validateTarget()@66 : Template uses view TARGET_SUMMARY_HOST for data retrieval

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2013-05-04 13:55:07 +00:00

  • File added icinga-web-1-9-oracle-debug-2013-05-04.log.tar.gz

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

@icinga-migration
Copy link
Author

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:

i6.name1 IN ('3715_35', '3715_all')

Does Oracle interpred IN differently?

@icinga-migration
Copy link
Author

Updated by mfrosch on 2013-05-05 20:06:06 +00:00

Well at least the docs of Oracle state that the behavior should be fine...

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2013-05-06 08:09:50 +00:00

  • Target Version changed from 1.9 to 1.9.1

@icinga-migration
Copy link
Author

Updated by mfrosch on 2013-09-08 15:34:02 +00:00

  • Target Version changed from 1.9.1 to 1.9.2

Moved for now, more testing required.

@icinga-migration
Copy link
Author

Updated by mfrosch on 2013-09-10 15:17:48 +00:00

  • Assigned to deleted mfrosch

@icinga-migration
Copy link
Author

Updated by jmosshammer on 2013-09-30 15:52:12 +00:00

  • Assigned to set to jmosshammer

I'm going to hate myself for this

@icinga-migration
Copy link
Author

Updated by mfrosch on 2013-10-02 16:10:14 +00:00

  • Status changed from Assigned to Feedback
  • Assigned to deleted jmosshammer
  • Target Version deleted 1.9.2

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.

Stalled

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2015-03-12 19:43:31 +00:00

  • Status changed from Feedback to New

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2015-04-26 09:03:06 +00:00

  • Status changed from New to Closed

Since I am the only one - closed.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
bug Database & Queries
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@icinga-migration