Calculated items, proxy issues?

[douglaz]

I'm trying to create calculated items. Some of them work and some don't. The only pattern I've found is that the problem occurs with items of proxied agents. The item shows on Latest data page without Last value (-).

They only reference for the item in zabbix server logs are entries like following (note: item key isn't mentioned anywhere in the log, only itemid):

  1791:20100129:164708.657 In calculate_item_nextcheck (25187,30,"",1264790827)
  1791:20100129:164708.657 End calculate_item_nextcheck (result:1264790837)

An more complete snippet:

  1791:20100129:164707.632 In DCsync_items()
  1791:20100129:164707.632 Query [txnlev:0] [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.snmp_port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999 order by i.itemid]
  1802:20100129:164707.815 Update IP [10.105.48.34 : 327.21 320.67 325.18]
  1802:20100129:164707.816 End of process_ping()
  1802:20100129:164707.816 End of do_ping():SUCCEED
  1802:20100129:164707.816 In process_values()
  1802:20100129:164707.816 In DCinit_nextchecks()
  1802:20100129:164707.816 Host [10.105.48.34] rcv=3 min/max/avg=0.320670/0.327210/0.324353
  1802:20100129:164707.816 In process_value()
  1802:20100129:164707.816 In calculate_item_nextcheck (25175,30,"",1264790825)
  1802:20100129:164707.817 End calculate_item_nextcheck (result:1264790855)
  1802:20100129:164707.817 In DCflush_nextchecks()
  1802:20100129:164707.817 In DCconfig_get_normal_poller_nextcheck() poller_type:3 poller_num:0
  1802:20100129:164707.817 End of DCconfig_get_normal_poller_nextcheck():1264790832
  1802:20100129:164707.817 Pinger spent 2.525648 seconds while processing 1 items. Nextcheck after 5 sec.
  1802:20100129:164707.817 In free_hosts()
  1811:20100129:164707.958 In process_escalations()
  1811:20100129:164707.958 Query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where status in (0,1) and nextcheck<=1264790827 and escalationid between 000000000000000 and 099999999999999]
  1811:20100129:164707.959 Escalator spent 0.001027 seconds while processing escalation items. Nextcheck after 3 sec.
  1806:20100129:164708.085 In get_values()
  1806:20100129:164708.085 In DCinit_nextchecks()
  1806:20100129:164708.085 In DCconfig_get_unreachable_poller_items() poller_type:1 poller_num:0
  1806:20100129:164708.085 End of DCconfig_get_unreachable_poller_items():0
  1806:20100129:164708.086 In DCflush_nextchecks()
  1806:20100129:164708.086 End of get_values()
  1806:20100129:164708.086 Poller #0 spent 0.000481 seconds while updating   0 values. Sleeping for 5 seconds
  1808:20100129:164708.219 In process_httptests()
  1808:20100129:164708.219 Query [txnlev:0] [select httptestid,name,applicationid,nextcheck,status,delay,macros,agent,authentication,http_user,http_password from httptest where status=0 and nextcheck<=1264790828 and mod(httptestid,1)=0 and httptestid between 000000000000000 and 099999999999999]
  1808:20100129:164708.220 End process_httptests()
  1808:20100129:164708.220 Spent 0 seconds while processing HTTP tests
  1808:20100129:164708.220 Query [txnlev:0] [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,1)=0 and t.httptestid between 000000000000000 and 099999999999999]
  1808:20100129:164708.221 Nextcheck:1264790839 Time:1264790828
  1808:20100129:164708.221 Sleeping for 5 seconds
  1795:20100129:164708.506 In get_values()
  1795:20100129:164708.506 In DCinit_nextchecks()
  1795:20100129:164708.506 In DCconfig_get_poller_items() poller_type:0 poller_num:3
  1795:20100129:164708.506 End of DCconfig_get_poller_items():0
  1795:20100129:164708.506 In DCflush_nextchecks()
  1795:20100129:164708.506 End of get_values()
  1795:20100129:164708.506 In DCconfig_get_normal_poller_nextcheck() poller_type:0 poller_num:3
  1795:20100129:164708.506 End of DCconfig_get_normal_poller_nextcheck():1264790833
  1795:20100129:164708.506 Poller #3 spent 0.000491 seconds while updating   0 values. Sleeping for 5 seconds
  1791:20100129:164708.657 In calculate_item_nextcheck (25187,30,"",1264790827)
  1791:20100129:164708.657 End calculate_item_nextcheck (result:1264790837)
  1791:20100129:164708.658 End of DCsync_items()
  1791:20100129:164708.659 End of DCsync_confguration() time:1.028807sec. pfree:63.749647%

Any ideas?

[pintonunes]

RE: Calculated items, proxy issues?

Hi douglaz,

I have exactly the same problem!!
Calculated items on proxy agents dont have any data...
I tried with zabbix agents and SNMP.

Have you found the solution??

Best,

Pedro Nunes

[douglaz]

The solution is to ignore the existence of calculated items =)