# Trigger expression: # {host:some.exit_status.last()}=204 # Trigger stays in PROBLEM state disregarding receiving proper new values for items, which don't meet the criteriea anymore. # Debug info from hystory syncer on receiving such new value added below. # select * from triggers where triggerid = 5359369; # triggerid expression description url status value priority lastchange comments error templateid type state flags recovery_mode recovery_expression correlation_mode correlation_tag manual_close # 5359369 {15663961}=204 UploadError 0 1 4 1497010644 5232615 0 0 0 0 0 0 # select * from functions where functionid = 15663961; # functionid itemid triggerid function parameter # 15663961 5964293 5359369 last # select * from items where itemid = 5964293; # itemid type snmp_community snmp_oid hostid name key_ delay history trends status value_type trapper_hosts units multiplier delta snmpv3_securityname snmpv3_securitylevel snmpv3_authpassphrase snmpv3_privpassphrase formula error lastlogsize logtimefmt templateid valuemapid delay_flex params ipmi_sensor data_type authtype username password publickey privatekey mtime flags interfaceid port description inventory_link lifetime snmpv3_authprotocol snmpv3_privprotocol state snmpv3_contextname evaltype # 5964293 2 25957 Some exit code some.exit_status 0 7 0 0 3 0 0 0 1 0 5846420 NULL 0 0 0 0 NULL 0 30 0 0 0 0 # select * from events where eventid = 126150109; # eventid source object objectid clock value acknowledged ns # 126150109 0 0 5359369 1497010644 1 1 411332396 $ tailf /var/log/zabbix-server/zabbix_server.log | egrep '5964293|#_itemid|5359369|#_triggerid|15663961|#_expressionid' # trigger in false problem # zabbix_sender -s host-z 127.0.0.1 -k some.exit_status -o 0 70061:20170610:200156.074 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (5964293,1497124881,126042104,0); 70061:20170610:200156.273 In zbx_vc_add_value() itemid:5964293 value_type:3 timestamp:1497124881.126042104 70061:20170610:200156.430 In substitute_simple_macros() data:'{15663961}=204' 70061:20170610:200156.431 End substitute_simple_macros() data:'{15663961}=204' 70061:20170610:200156.518 In substitute_simple_macros() data:'{15663961}=204' 70061:20170610:200156.518 End substitute_simple_macros() data:'{15663961}=204' 70061:20170610:200202.442 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:0 count:1 timestamp:1497124881 70061:20170610:200205.388 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:3600 count:1 timestamp:1497124925 70061:20170610:200209.552 zbx_substitute_functions_results() expression[274]:'{15663961}=204' => '0=204' 70061:20170610:200211.056 In zbx_process_trigger() triggerid:5359369 value:0(0) new_value:3 # trigger in false problem # zabbix_sender -s host-z 127.0.0.1 -k some.exit_status -o 0 70086:20170610:200535.805 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (5964293,1497124953,976302621,0); 70086:20170610:200535.849 In zbx_vc_add_value() itemid:5964293 value_type:3 timestamp:1497124953.976302621 70086:20170610:200536.806 In substitute_simple_macros() data:'{15663961}=204' 70086:20170610:200536.806 End substitute_simple_macros() data:'{15663961}=204' 70086:20170610:200536.887 In substitute_simple_macros() data:'{15663961}=204' 70086:20170610:200536.887 End substitute_simple_macros() data:'{15663961}=204' 70086:20170610:200542.184 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:0 count:1 timestamp:1497124953 70086:20170610:200542.745 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:3600 count:1 timestamp:1497125142 70086:20170610:200545.964 zbx_substitute_functions_results() expression[197]:'{15663961}=204' => '0=204' 70086:20170610:200546.136 In zbx_process_trigger() triggerid:5359369 value:0(0) new_value:3 # trigger in real problem # zabbix_sender -s host-z 127.0.0.1 -k some.exit_status -o 204 # sent it several times, first two with big interval didn't reach history syncer # new event generated after that # select * from events where eventid in (126150109, 126877841); # eventid source object objectid clock value acknowledged ns # 126150109 0 0 5359369 1497010644 1 1 411332396 # 126877841 0 0 5359369 1497125199 1 0 325991658 70089:20170610:201920.005 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (5964293,1497125199,325991658,204); 70089:20170610:201920.342 In zbx_vc_add_value() itemid:5964293 value_type:3 timestamp:1497125199.325991658 70089:20170610:201920.440 In substitute_simple_macros() data:'{15663961}=204' 70089:20170610:201920.440 End substitute_simple_macros() data:'{15663961}=204' 70089:20170610:201920.476 In substitute_simple_macros() data:'{15663961}=204' 70089:20170610:201920.476 End substitute_simple_macros() data:'{15663961}=204' 70089:20170610:201922.560 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:0 count:1 timestamp:1497125199 70089:20170610:201928.006 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:3600 count:1 timestamp:1497125967 70089:20170610:201932.230 zbx_substitute_functions_results() expression[138]:'{15663961}=204' => '204=204' 70089:20170610:201933.704 In zbx_process_trigger() triggerid:5359369 value:0(0) new_value:1 70089:20170610:201933.727 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (126877841,0,0,5359369,1497125199,325991658,1); 70089:20170610:201933.728 query [txnlev:1] [insert into problem (eventid,source,object,objectid,clock,ns) values (126877841,0,0,5359369,1497125199,325991658); 70089:20170610:201933.732 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.735 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.735 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.739 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201933.742 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.746 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.758 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.761 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.763 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.764 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.769 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.772 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70089:20170610:201933.777 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.778 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.779 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.784 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70089:20170610:201933.786 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=80] 70089:20170610:201933.789 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.799 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.801 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70089:20170610:201933.803 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70089:20170610:201933.805 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70089:20170610:201933.806 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70089:20170610:201933.807 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.808 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.814 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.829 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=216] 70089:20170610:201933.833 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=21] 70089:20170610:201933.835 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=299] 70089:20170610:201933.837 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201933.839 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.840 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70089:20170610:201933.841 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.841 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.843 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.844 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.845 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.846 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.847 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.848 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.849 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.851 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70089:20170610:201933.852 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70089:20170610:201933.853 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70089:20170610:201933.854 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70089:20170610:201933.856 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70089:20170610:201933.857 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70089:20170610:201933.858 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=234] 70089:20170610:201933.859 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70089:20170610:201933.860 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70089:20170610:201933.861 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70089:20170610:201933.862 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70089:20170610:201933.864 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70089:20170610:201933.864 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70089:20170610:201933.866 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70089:20170610:201933.867 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=168] 70089:20170610:201933.868 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70089:20170610:201933.869 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70089:20170610:201933.871 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70089:20170610:201933.872 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201933.873 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70089:20170610:201933.874 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70089:20170610:201933.875 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70089:20170610:201933.876 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70089:20170610:201933.877 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70089:20170610:201933.878 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=115] 70089:20170610:201933.879 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=98] 70089:20170610:201933.880 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=91] 70089:20170610:201933.882 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70089:20170610:201933.883 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70089:20170610:201933.884 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70089:20170610:201933.885 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70089:20170610:201933.886 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=53] 70089:20170610:201933.887 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201933.888 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=50] 70089:20170610:201933.889 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=32] 70089:20170610:201933.890 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=25] 70089:20170610:201933.891 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70089:20170610:201933.892 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=18] 70089:20170610:201933.893 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70089:20170610:201933.894 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70089:20170610:201933.895 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=318] 70089:20170610:201933.897 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.899 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.900 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.902 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201933.904 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.905 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70089:20170610:201933.907 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70089:20170610:201933.908 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70089:20170610:201933.909 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70089:20170610:201933.914 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.914 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.916 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=219] 70089:20170610:201933.917 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201933.920 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=90] 70089:20170610:201933.921 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201933.923 query [txnlev:1] [select distinct i.hostid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and i.hostid=27281] 70089:20170610:201933.925 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70089:20170610:201933.926 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201933.927 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.927 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.930 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.932 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=237] 70089:20170610:201933.934 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70089:20170610:201933.935 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70089:20170610:201933.935 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70089:20170610:201933.938 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201933.938 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201933.939 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201933.940 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70089:20170610:201933.941 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70089:20170610:201933.943 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70089:20170610:201933.944 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=294] 70089:20170610:201933.945 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=293] 70089:20170610:201933.945 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=284] 70089:20170610:201933.946 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70089:20170610:201933.947 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70089:20170610:201933.948 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70089:20170610:201933.949 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=271] 70089:20170610:201933.950 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=270] 70089:20170610:201933.951 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70089:20170610:201933.952 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=256] 70089:20170610:201933.953 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=246] 70089:20170610:201933.954 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=242] 70089:20170610:201933.955 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70089:20170610:201933.957 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70089:20170610:201933.958 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=238] 70089:20170610:201933.959 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=232] 70089:20170610:201933.960 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=231] 70089:20170610:201933.961 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70089:20170610:201933.962 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70089:20170610:201933.963 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=211] 70089:20170610:201933.964 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=210] 70089:20170610:201933.965 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70089:20170610:201933.966 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70089:20170610:201933.967 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=203] 70089:20170610:201933.968 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70089:20170610:201933.969 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=198] 70089:20170610:201933.971 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70089:20170610:201933.972 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=191] 70089:20170610:201933.973 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=190] 70089:20170610:201933.974 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=189] 70089:20170610:201933.975 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=187] 70089:20170610:201933.976 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=186] 70089:20170610:201933.977 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70089:20170610:201933.978 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70089:20170610:201933.979 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70089:20170610:201933.980 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70089:20170610:201933.981 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70089:20170610:201933.982 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70089:20170610:201933.983 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70089:20170610:201933.985 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201933.986 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70089:20170610:201933.987 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70089:20170610:201933.988 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=135] 70089:20170610:201933.989 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70089:20170610:201933.990 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70089:20170610:201933.992 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70089:20170610:201934.002 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70089:20170610:201934.011 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70089:20170610:201934.014 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=102] 70089:20170610:201934.016 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201934.017 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.018 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.020 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201934.021 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.021 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.023 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201934.024 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.025 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.026 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.027 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.029 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201934.031 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201934.032 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201934.033 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70089:20170610:201934.035 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201934.037 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.037 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.039 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=216] 70089:20170610:201934.040 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=21] 70089:20170610:201934.041 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=299] 70089:20170610:201934.043 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.044 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.045 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201934.046 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70089:20170610:201934.047 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70089:20170610:201934.048 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70089:20170610:201934.050 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70089:20170610:201934.052 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70089:20170610:201934.053 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=259] 70089:20170610:201934.054 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70089:20170610:201934.055 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70089:20170610:201934.056 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70089:20170610:201934.057 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70089:20170610:201934.058 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=185] 70089:20170610:201934.059 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70089:20170610:201934.061 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=163] 70089:20170610:201934.062 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201934.063 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70089:20170610:201934.064 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70089:20170610:201934.065 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=80] 70089:20170610:201934.066 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70089:20170610:201934.067 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70089:20170610:201934.068 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70089:20170610:201934.069 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70089:20170610:201934.071 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70089:20170610:201934.072 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70089:20170610:201934.073 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70089:20170610:201934.074 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70089:20170610:201934.075 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70089:20170610:201934.076 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70089:20170610:201934.077 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=234] 70089:20170610:201934.078 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70089:20170610:201934.079 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=210] 70089:20170610:201934.080 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70089:20170610:201934.081 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70089:20170610:201934.082 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70089:20170610:201934.083 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=190] 70089:20170610:201934.084 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70089:20170610:201934.085 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70089:20170610:201934.086 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70089:20170610:201934.087 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70089:20170610:201934.088 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=168] 70089:20170610:201934.089 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70089:20170610:201934.090 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70089:20170610:201934.091 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70089:20170610:201934.092 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70089:20170610:201934.093 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70089:20170610:201934.094 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=135] 70089:20170610:201934.095 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70089:20170610:201934.096 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70089:20170610:201934.097 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70089:20170610:201934.098 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70089:20170610:201934.099 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=101] 70089:20170610:201934.100 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70089:20170610:201934.101 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=91] 70089:20170610:201934.102 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70089:20170610:201934.103 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70089:20170610:201934.104 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=64] 70089:20170610:201934.105 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70089:20170610:201934.106 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70089:20170610:201934.107 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70089:20170610:201934.108 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=53] 70089:20170610:201934.109 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=50] 70089:20170610:201934.110 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=32] 70089:20170610:201934.111 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=25] 70089:20170610:201934.112 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70089:20170610:201934.113 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=18] 70089:20170610:201934.114 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70089:20170610:201934.115 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70089:20170610:201934.116 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=318] 70089:20170610:201934.118 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201934.121 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70089:20170610:201934.122 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70089:20170610:201934.124 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70089:20170610:201934.125 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70089:20170610:201934.126 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70089:20170610:201934.128 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70089:20170610:201934.128 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70089:20170610:201934.130 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70089:20170610:201934.131 query [txnlev:1] [insert into escalations (escalationid,actionid,status,triggerid,itemid,eventid,r_eventid) values (56048139,459,0,5359369,null,126877841,null),(56048140,237,0,5359369,null,126877841,null),(56048141,407,0,5359369,null,126877841,null); 70089:20170610:201934.132 query [txnlev:1] [select serviceid,triggerid,status,algorithm from services where triggerid=5359369] 70089:20170610:201934.133 query [txnlev:1] [update triggers set lastchange=1497125199,value=1 where triggerid=5359369; # I've tried to send 0 then, but failed - server performance dropped too much because of logging, I've got 0 - 204 - 0 - 204 - 0 in last item history and no log entry for it. # Trigger switched to OK after first 0, both events are gone. # Here are events afterwards # eventid source object objectid clock value acknowledged ns # 126150109 0 0 5359369 1497010644 1 1 411332396 # 126877841 0 0 5359369 1497125199 1 0 325991658 # 126881785 0 0 5359369 1497125715 1 0 336196511 # UPD: I've returned my replica to initial slate where trigger in PROBLEM and many "0" in history. # trigger in real problem # zabbix_sender -s host-z 127.0.0.1 -k some.exit_status -o 204 70102:20170611:051112.108 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (5964293,1497157851,550686311,204); 70102:20170611:051112.181 In zbx_vc_add_value() itemid:5964293 value_type:3 timestamp:1497157851.550686311 70102:20170611:051112.500 In substitute_simple_macros() data:'{15663961}=204' 70102:20170611:051112.500 End substitute_simple_macros() data:'{15663961}=204' 70102:20170611:051112.570 In substitute_simple_macros() data:'{15663961}=204' 70102:20170611:051112.570 End substitute_simple_macros() data:'{15663961}=204' 70102:20170611:051117.378 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:0 count:1 timestamp:1497157851 70102:20170611:051118.136 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:3600 count:1 timestamp:1497157878 70102:20170611:051120.729 zbx_substitute_functions_results() expression[152]:'{15663961}=204' => '204=204' 70102:20170611:051120.847 In zbx_process_trigger() triggerid:5359369 value:0(0) new_value:1 70102:20170611:051120.853 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (126907865,0,0,5359369,1497157851,550686311,1); 70102:20170611:051120.853 query [txnlev:1] [insert into problem (eventid,source,object,objectid,clock,ns) values (126907865,0,0,5359369,1497157851,550686311); 70102:20170611:051120.855 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.856 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051120.856 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051120.858 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051120.859 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051120.861 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.865 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051120.867 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.868 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051120.869 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051120.871 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.873 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70102:20170611:051120.875 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.876 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051120.876 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051120.878 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70102:20170611:051120.880 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=80] 70102:20170611:051120.881 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.893 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051120.910 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70102:20170611:051120.922 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70102:20170611:051120.934 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70102:20170611:051120.946 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70102:20170611:051120.958 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051120.976 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051120.991 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.009 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=216] 70102:20170611:051121.022 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=21] 70102:20170611:051121.035 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=299] 70102:20170611:051121.063 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051121.101 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.120 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70102:20170611:051121.150 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.153 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.173 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.188 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.204 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.220 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.236 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.252 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.268 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.297 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70102:20170611:051121.311 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70102:20170611:051121.324 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70102:20170611:051121.337 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70102:20170611:051121.349 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70102:20170611:051121.362 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70102:20170611:051121.376 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=234] 70102:20170611:051121.389 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70102:20170611:051121.404 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70102:20170611:051121.418 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70102:20170611:051121.427 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70102:20170611:051121.431 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70102:20170611:051121.434 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70102:20170611:051121.437 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70102:20170611:051121.440 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=168] 70102:20170611:051121.442 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70102:20170611:051121.444 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70102:20170611:051121.447 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70102:20170611:051121.450 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051121.452 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70102:20170611:051121.455 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70102:20170611:051121.457 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70102:20170611:051121.459 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70102:20170611:051121.461 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70102:20170611:051121.464 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=115] 70102:20170611:051121.466 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=98] 70102:20170611:051121.468 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=91] 70102:20170611:051121.471 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70102:20170611:051121.473 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70102:20170611:051121.475 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70102:20170611:051121.478 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70102:20170611:051121.481 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=53] 70102:20170611:051121.483 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.486 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=50] 70102:20170611:051121.488 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=32] 70102:20170611:051121.491 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=25] 70102:20170611:051121.493 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70102:20170611:051121.496 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=18] 70102:20170611:051121.499 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70102:20170611:051121.502 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70102:20170611:051121.515 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=318] 70102:20170611:051121.542 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.572 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.586 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.611 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.616 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.619 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70102:20170611:051121.625 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70102:20170611:051121.627 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70102:20170611:051121.629 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70102:20170611:051121.642 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.642 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.646 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=219] 70102:20170611:051121.648 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.653 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=90] 70102:20170611:051121.657 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.661 query [txnlev:1] [select distinct i.hostid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and i.hostid=27281] 70102:20170611:051121.666 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70102:20170611:051121.669 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.672 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.673 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.693 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.727 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=237] 70102:20170611:051121.731 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70102:20170611:051121.733 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70102:20170611:051121.735 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70102:20170611:051121.741 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.741 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.744 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.746 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70102:20170611:051121.749 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70102:20170611:051121.755 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70102:20170611:051121.757 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=294] 70102:20170611:051121.759 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=293] 70102:20170611:051121.761 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=284] 70102:20170611:051121.762 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70102:20170611:051121.764 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70102:20170611:051121.765 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70102:20170611:051121.767 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=271] 70102:20170611:051121.769 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=270] 70102:20170611:051121.770 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70102:20170611:051121.772 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=256] 70102:20170611:051121.774 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=246] 70102:20170611:051121.776 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=242] 70102:20170611:051121.777 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70102:20170611:051121.779 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70102:20170611:051121.781 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=238] 70102:20170611:051121.794 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=232] 70102:20170611:051121.808 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=231] 70102:20170611:051121.814 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70102:20170611:051121.816 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70102:20170611:051121.817 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=211] 70102:20170611:051121.818 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=210] 70102:20170611:051121.819 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70102:20170611:051121.820 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70102:20170611:051121.821 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=203] 70102:20170611:051121.823 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70102:20170611:051121.824 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=198] 70102:20170611:051121.825 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70102:20170611:051121.826 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=191] 70102:20170611:051121.827 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=190] 70102:20170611:051121.828 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=189] 70102:20170611:051121.829 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=187] 70102:20170611:051121.830 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=186] 70102:20170611:051121.832 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70102:20170611:051121.833 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70102:20170611:051121.834 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70102:20170611:051121.835 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70102:20170611:051121.836 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70102:20170611:051121.837 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70102:20170611:051121.838 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70102:20170611:051121.839 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051121.846 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70102:20170611:051121.855 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70102:20170611:051121.858 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=135] 70102:20170611:051121.860 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70102:20170611:051121.861 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70102:20170611:051121.862 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70102:20170611:051121.863 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70102:20170611:051121.866 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70102:20170611:051121.868 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=102] 70102:20170611:051121.869 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.871 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.871 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.873 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051121.874 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.875 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.877 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.878 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.878 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.880 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.880 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.884 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.885 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.887 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.888 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70102:20170611:051121.890 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051121.892 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.892 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.894 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=216] 70102:20170611:051121.896 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=21] 70102:20170611:051121.897 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=299] 70102:20170611:051121.899 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051121.900 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051121.901 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051121.903 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=230] 70102:20170611:051121.904 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=208] 70102:20170611:051121.905 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=129] 70102:20170611:051121.907 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70102:20170611:051121.909 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70102:20170611:051121.910 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=259] 70102:20170611:051121.911 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70102:20170611:051121.913 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=241] 70102:20170611:051121.915 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70102:20170611:051121.920 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70102:20170611:051121.923 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=185] 70102:20170611:051121.925 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70102:20170611:051121.927 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=163] 70102:20170611:051121.928 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051121.929 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70102:20170611:051121.930 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70102:20170611:051121.931 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=80] 70102:20170611:051121.932 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70102:20170611:051121.933 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=51] 70102:20170611:051121.935 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70102:20170611:051121.936 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70102:20170611:051121.938 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=301] 70102:20170611:051121.939 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=280] 70102:20170611:051121.940 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=279] 70102:20170611:051121.941 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=274] 70102:20170611:051121.942 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=257] 70102:20170611:051121.943 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=239] 70102:20170611:051121.944 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=234] 70102:20170611:051121.945 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=226] 70102:20170611:051121.947 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=210] 70102:20170611:051121.948 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=205] 70102:20170611:051121.950 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=201] 70102:20170611:051121.962 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=195] 70102:20170611:051121.974 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=190] 70102:20170611:051121.985 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=178] 70102:20170611:051121.997 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=175] 70102:20170611:051122.010 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=174] 70102:20170611:051122.023 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=173] 70102:20170611:051122.036 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=168] 70102:20170611:051122.049 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=165] 70102:20170611:051122.062 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=155] 70102:20170611:051122.075 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=141] 70102:20170611:051122.087 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=137] 70102:20170611:051122.100 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=136] 70102:20170611:051122.112 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=135] 70102:20170611:051122.123 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=133] 70102:20170611:051122.135 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=130] 70102:20170611:051122.147 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=117] 70102:20170611:051122.160 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=113] 70102:20170611:051122.172 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=101] 70102:20170611:051122.184 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70102:20170611:051122.197 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=91] 70102:20170611:051122.210 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70102:20170611:051122.222 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=65] 70102:20170611:051122.234 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=64] 70102:20170611:051122.246 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=59] 70102:20170611:051122.259 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=55] 70102:20170611:051122.272 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=54] 70102:20170611:051122.284 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=53] 70102:20170611:051122.297 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=50] 70102:20170611:051122.311 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=32] 70102:20170611:051122.325 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=25] 70102:20170611:051122.338 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70102:20170611:051122.352 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=18] 70102:20170611:051122.365 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=6] 70102:20170611:051122.378 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=5] 70102:20170611:051122.391 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=318] 70102:20170611:051122.419 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051122.453 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=138] 70102:20170611:051122.470 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=94] 70102:20170611:051122.507 query [txnlev:1] [select templateid from triggers where triggerid=5359369] 70102:20170611:051122.513 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=85] 70102:20170611:051122.517 query [txnlev:1] [select distinct hg.groupid from hosts_groups hg,hosts h,items i,functions f,triggers t where hg.hostid=h.hostid and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369 and hg.groupid=20] 70102:20170611:051122.527 query [txnlev:1] [select parent_triggerid from trigger_discovery where triggerid=5359369] 70102:20170611:051122.528 query [txnlev:1] [select distinct i.hostid,t.templateid from items i,functions f,triggers t where i.itemid=f.itemid and f.triggerid=t.templateid and t.triggerid=5359369] 70102:20170611:051122.536 query [txnlev:1] [select count(*) from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and h.maintenance_status=0 and i.itemid=f.itemid and f.triggerid=t.triggerid and t.triggerid=5359369] 70102:20170611:051122.540 query [txnlev:1] [insert into escalations (escalationid,actionid,status,triggerid,itemid,eventid,r_eventid) values (56058231,459,0,5359369,null,126907865,null),(56058232,237,0,5359369,null,126907865,null),(56058233,407,0,5359369,null,126907865,null); 70102:20170611:051122.544 query [txnlev:1] [select serviceid,triggerid,status,algorithm from services where triggerid=5359369] 70102:20170611:051122.548 query [txnlev:1] [update triggers set lastchange=1497157851,value=1 where triggerid=5359369; # trigger switch to OK # zabbix_sender -s host-z 127.0.0.1 -k some.exit_status -o 0 70059:20170611:051309.055 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (5964293,1497157887,883539815,0); 70059:20170611:051311.156 In zbx_vc_add_value() itemid:5964293 value_type:3 timestamp:1497157887.883539815 70059:20170611:051311.289 In substitute_simple_macros() data:'{15663961}=204' 70059:20170611:051311.289 End substitute_simple_macros() data:'{15663961}=204' 70059:20170611:051311.420 In substitute_simple_macros() data:'{15663961}=204' 70059:20170611:051311.420 End substitute_simple_macros() data:'{15663961}=204' 70059:20170611:051313.859 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:3600 count:1 timestamp:1497157993 70059:20170611:051324.723 In zbx_vc_get_value_range() itemid:5964293 value_type:3 seconds:0 count:1 timestamp:1497157887 70059:20170611:051330.044 zbx_substitute_functions_results() expression[466]:'{15663961}=204' => '0=204' 70059:20170611:051332.259 In zbx_process_trigger() triggerid:5359369 value:1(0) new_value:0 70059:20170611:051332.285 query [txnlev:1] [select eventid,source,object,objectid from problem where r_eventid is null and ( (source=0 and object=0 and objectid=5359369))] 70059:20170611:051332.289 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (126907879,0,0,5359369,1497157887,883539815,0); 70059:20170611:051332.302 query [txnlev:1] [select serviceid,triggerid,status,algorithm from services where triggerid=5359369] 70059:20170611:051332.306 query [txnlev:1] [update triggers set lastchange=1497157887,value=0 where triggerid=5359369;