Zabbix Calculated items

[kaf3773]

I am trying to create a calculated item using other items that have been setup with zabbix trapper as their type. For example i set up

item +++++++ type
=======================
uptime ++++ zabbix_trapper
truput ++++ zabbix_trapper

from the above i try to create a calculated item with this expression
sum(uptime,truput) but i keep getting this error Format error or unsupported operator.

i will appreciate if you anyone can help. thanks

[JBo]

Hi,

Have you tried

uptime+truput

Regards,
JBo

[kaf3773]

Yes i did but this is the error i get in the log file

1471:20120327:165642.649 item [VOIP:r_plus_u] became not supported: Format error or unsupported operator. Exp: [uptime]

Thnks

[JBo]

Hi,

Yes i did but this is the error i get in the log file

1471:20120327:165642.649 item [VOIP:r_plus_u] became not supported: Format error or unsupported operator. Exp: [uptime]

Sorry, I made a mistake.
It should have been

last("uptime")+last("truput")

assuming that uptime and truput are the key values of your items.
You can check the documentation for more details.

Regards,
JBo

[kaf3773]

After i tried this is what i get in the log file

1458:20120328:122608.695 [Z3005] query failed: [2006] MySQL server has gone away [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prev value,i.hostid,i.value_type,i.delta,i.prevorgvalue ,i.lastclock,i.units,i.multiplier,i.formula,i.stat us,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.dat a_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='VOIP' and i.key_='uptime') or (h.host='VOIP' and i.key_='truput')) and h.hostid between 000000000000000 and 099999999999999]

Thanks

[JBo]

Hi,

Your mysql server crashed.
You should check mysql logs.
However, I think that it is not related to your calculated item.
Just restart mysql server, zabbix server and check the logs again.

Regards,
JBo