Trigger problem

[befortin]

Hi,

I'm trying to configure the following trigger :

Description : test
Expression : ({SERVER:filesize[C:\\Zabbix\\AlerteSQL\\SQLMaintenanceSucceeded.txt].last(0)})=({SERVER:filesize[C:\\Zabbix\\AlerteSQL\\SQLMaintenanceSucceeded.txt].max(90000)})

(which means : file size of SQLMaintenanceSucceded.txt has not changed in the last 25 hours)

I can add this trigger with no errors, but I can't see it in the View / Triggers webpage. It just doesn't appears there. I tried to add this trigger a few times but I still can't see it.

So I went in the MySQL console and tried the following :

================================================== =========
mysql> select * from triggers where description like 'test';
+-----------+---------------------+-------------+-----+--------+-------+----------+------------+-----------+----------+
| triggerid | expression | description | url | status | value | priority | lastchange | dep_level | comments |
+-----------+---------------------+-------------+-----+--------+-------+----------+------------+-----------+----------+
| 12531 | ({11603})=({11604}) | test | | 0 | 2 | 0 | 0 | 0 | |
+-----------+---------------------+-------------+-----+--------+-------+----------+------------+-----------+----------+
1 row in set (0.00 sec)

================================================== =========

mysql> select * from functions where functionid = 11603;
+------------+--------+-----------+-----------+----------+-----------+
| functionid | itemid | triggerid | lastvalue | function | parameter |
+------------+--------+-----------+-----------+----------+-----------+
| 11603 | 17724 | 12531 | NULL | last | 0 |
+------------+--------+-----------+-----------+----------+-----------+
1 row in set (0.00 sec)

================================================== =========

mysql> select * from functions where functionid = 11604;
+------------+--------+-----------+-----------+----------+-----------+
| functionid | itemid | triggerid | lastvalue | function | parameter |
+------------+--------+-----------+-----------+----------+-----------+
| 11604 | 17724 | 12531 | NULL | max | 90000 |
+------------+--------+-----------+-----------+----------+-----------+
1 row in set (0.01 sec)

================================================== =========

+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+--------------------------------------------------------------+-------+---------+--------+-----------+-----------+-----------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+
| 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 |
+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+--------------------------------------------------------------+-------+---------+--------+-----------+-----------+-----------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+
| 17724 | 0 | public | interfaces.ifTable.ifEntry.ifInOctets.1 | 161 | 10026 | SQL Maintenance Succeeded | filesize[C:\\Zabbix\\AlerteSQL\\SQLMaintenanceSucceeded.txt] | 5 | 60 | 365 | 0 | NULL | NULL | NULL | 3 | 0 | | B | 0 | 0 | NULL | | 0 | | | 1 | | 0 |
+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+--------------------------------------------------------------+-------+---------+--------+-----------+-----------+-----------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+
1 row in set (0.00 sec)

================================================== =========

What's wrong? Is there something else I should try or modify?

Thanks!

Benoît

[James Wells]

Greetings,

You will not see it from the view / triggers page, unless it goes TRUE, which in your case means that it goes TRUE if, and only if the current, size is equal to the maximum size returned over the last 90,000 seconds.


EDIT: Additionally, it appears that you are using character instead of numeric, which will always fail the MAX test.