Expression [...] cannot be evaluated

[befortin]

Hi,

I'm getting the following error in the zabbix server's log :

004869:20060629:074701 Evaluation of expression [(0.000000>0)&(0.000000>0)&(0.000000>{11786})] failed [Unable to get value for functionid [11786]]

004869:20060629:074701 Expression [({11783}>0) & ({11784}>0) & ({11785} > {11786})] cannot be evaluated [Unable to get value for functionid [11786]]

Any idea?

[befortin]

I have some details about my problem.

The error says "[Unable to get value for functionid [11786]]". Here's what functionid[11786] contains :

mysql> select * from functions where functionid = 11786;
+------------+--------+-----------+-----------+----------+-----------+
| functionid | itemid | triggerid | lastvalue | function | parameter |
+------------+--------+-----------+-----------+----------+-----------+
| 11786 | 18206 | 12569 | NULL | max | 150 |
+------------+--------+-----------+-----------+----------+-----------+



And here's what itemid[18206] is :

mysql> select * from items where itemid = 18206;
+--------+------+----------------+-----------------------------------------+-----------+--------+--------------------------+---------------------------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
| itemid | type | snmp_community | snmp_oid | snmp_port | hostid | description | key_ | delay | history | trends | nextcheck | lastvalue | lastclock | prevvalue | status | value_type | trapper_hosts | units | multiplier | delta | prevorgvalue | snmpv3_securityname | snmpv3_securitylevel | snmpv3_authpassphrase | snmpv3_privpassphrase | formula | error | lastlogsize | logtimefmt | templateid | valuemapid |
+--------+------+----------------+-----------------------------------------+-----------+--------+--------------------------+---------------------------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
| 18206 | 0 | public | interfaces.ifTable.ifEntry.ifInOctets.1 | 161 | 10037 | DHCP log (CGINet -> BNC) | vfs.file.size[C:\Zabbix\AlerteDHCP\DHCPAlert.txt] | 60 | 30 | 730 | 1151679360 | 112.000000 | 1151679301 | 112.000000 | 0 | 1 | | | 0 | 0 | NULL | | 0 | | | 1 | | 0 | | 0 | 0 |
+--------+------+----------------+-----------------------------------------+-----------+--------+--------------------------+---------------------------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
1 row in set (0.00 sec)



I don't know if that may also help, but here's the trigger I have for this item :

({server00:vfs.file.size[C:\Zabbix\AlerteDHCP\DHCPAlert.txt].diff(0)}>0) & ({server00:vfs.file.size[C:\Zabbix\AlerteDHCP\DHCPAlert.txt].last(0)}>0) & ({server00:vfs.file.size[C:\Zabbix\AlerteDHCP\DHCPAlert.txt].last(0)} > {server00:vfs.file.size[C:\Zabbix\AlerteDHCP\DHCPAlert.txt].max(150)})



Is there anything wrong with my trigger? Or maybe something else I'm not doing the right way?

[befortin]

My bad... The item was defined as "character", and since it's a vfs.filesize, it needs to be defined as a number, not as character.

It works now.