I'm running an external script check on the the internet root dns servers. As shown in the screenshot, some are working, while others (f, i, j, and m) are not.
The script is executed by various zabbix proxies. For the root server f specifically, the proxy assigned to check it is collecting the data:
The hosts were cloned from each other. Root servers i and j are monitored by the same proxy, while m is monitored by yet another. We use the exact same script and proxies to monitor our internal dns servers without issues. Why would some be working but others not? Please let me know if I need to supply more debugging information.
The script is executed by various zabbix proxies. For the root server f specifically, the proxy assigned to check it is collecting the data:
Code:
12015:20100218:124501 /var/lib/zabbix/externalscripts/getdnsresponsetime.sh f.root-servers.net
12033:20100218:124501 Query [select httptestid,name,applicationid,nextcheck,status,delay,macros,agent from httptest where status=0 and nextcheck<=1266515101 and mod(httptestid,1)
=0]
12033:20100218:124501 End process_httptests()
12033:20100218:124501 Spent 0 seconds while processing HTTP tests
12033:20100218:124501 Query [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,1)=0]
12033:20100218:124501 No httptests to process in get_minnextcheck.
12033:20100218:124501 Nextcheck:-1 Time:1266515101
12033:20100218:124501 Sleeping for 5 seconds
12015:20100218:124501 Result [32]
12015:20100218:124501 End get_value()
12015:20100218:124501 Query [begin;]
12015:20100218:124501 In proxy_process_new_value(getdnsresponsetime.sh[]) 12015:20100218:124501 In proxy_add_history(itemid:69301,key:"getdnsresponsetime.sh[]",value_type:0,DOUBLE:32.000000)
12015:20100218:124501 In proxy_add_history()
12015:20100218:124501 Query [insert into proxy_history (itemid,clock,value) values (69301,1266515101,'32.000000')]
12015:20100218:124501 End of proxy_add_history
12015:20100218:124501 In proxy_update_item()
12015:20100218:124501 In calculate_item_nextcheck (69301,600,"",1266515101)
12015:20100218:124501 End calculate_item_nextcheck (result:1266515701)
12015:20100218:124501 Query [update items set nextcheck=1266515701 where itemid=69301]
12015:20100218:124501 End proxy_update_item() 12015:20100218:124501 Query [commit;] 12015:20100218:124501 End get_values()
12015:20100218:124501 Poller spent 0.251194 seconds while updating 1 values. Sleeping for 5 seconds
12011:20100218:124502 In history_sender() 12011:20100218:124502 In get_history_data() [table:proxy_history]
12011:20100218:124502 In get_lastid() [proxy_history.history_lastid]
12011:20100218:124502 Query [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
12011:20100218:124502 End of get_lastid() [proxy_history.history_lastid]:5620370
12011:20100218:124502 Query [select p.id,h.host,i.key_,p.clock,p.timestamp,p.source,p.severity,p.value from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p
.itemid and p.id>5620370 order by p.id limit 1000]
12011:20100218:124502 In dhistory_sender()
12011:20100218:124502 In get_dhistory_data() [table:proxy_dhistory] 12011:20100218:124502 In get_lastid() [proxy_dhistory.dhistory_lastid] 12011:20100218:124502 Query [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid'] 12011:20100218:124502 End of get_lastid() [proxy_dhistory.dhistory_lastid]:104 12011:20100218:124502 Query [select id,clock,druleid,type,ip,port,key_,value,status from proxy_dhistory where id>104 order by id limit 1000] 12011:20100218:124502 Datasender spent 0.017575 seconds while processing 0 values. 12011:20100218:124502 Sleeping for 1 seconds 12016:20100218:124502 In get_values() 12016:20100218:124502 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.params,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i.ipmi_sensor,i.lastlogsize from hosts h, items i where i.nextcheck<=1266515107 and h.hostid=i.hostid and h.status=0 and i.status
in (0,3) and ((h.disable_until<=1266515102 and h.errors_from=0 and i.type in (0,1,4,6)) or i.type in (3,5,8,10,11)) and (h.proxy_hostid=0 or i.type in (5,8)) and mod(i.itemid,5)=2 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck]
12016:20100218:124502 End get_values()
12016:20100218:124502 Poller spent 0.007593 seconds while updating 0 values. Sleeping for 5 seconds
12011:20100218:124503 In history_sender()
12011:20100218:124503 In get_history_data() [table:proxy_history]
12011:20100218:124503 In get_lastid() [proxy_history.history_lastid]
12011:20100218:124503 Query [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
12011:20100218:124503 End of get_lastid() [proxy_history.history_lastid]:5620370
Comment