-
Incident report
-
Resolution: Fixed
-
Major
-
1.8.2, 1.9.0 (alpha)
-
None
-
Linux, Zabbix server
Zabbix timer process evaluate same item triggers per 30 sec even if a trigger including "nodata()" is disabled.
I have following item and triggers.
- "Host uptime(in sec)" item updated every 3000 sec (see zbx_05.png)
- "nodata trigger" with "Normal + multiple PROBLEM events" (see zbx_04.png)
- "error occurs with nodata trigger" with "Normal + multiple PROBLEM events" (see zbx_03.png)
I think only if "nodata trigger" is enabled, "nodata trigger" and "error occurs with nodata trigger" should be reported. (see zbx_01.png)
But, even if "nodata trigger" is disabled, "error occurs with nodata trigger" is still reported. (see zbx_02.png)
The following SQL in "process_time_functions()" executed by timer process dosen't check if triggers are enable or disable.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- in process_time_functions() ##############################################
result = DBselect("select distinct %s,functions f where h.hostid=i.hostid and h.status=%d"
" and i.status=%d and f.function in ('nodata','date','dayofweek','time','now')"
" and i.itemid=f.itemid and (h.maintenance_status=%d or h.maintenance_type=%d)" DB_NODE,
ZBX_SQL_ITEM_SELECT,
HOST_STATUS_MONITORED,
ITEM_STATUS_ACTIVE,
HOST_MAINTENANCE_STATUS_OFF, MAINTENANCE_TYPE_NORMAL,
DBnode_local("h.hostid"));
#######################################################################################################
- in process_time_functions() ##############################################
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
I think following is correct.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- in process_time_functions() ##############################################
result = DBselect("select distinct %s,functions f, triggers t where h.hostid=i.hostid and h.status=%d"
" and i.status=%d and f.triggerid=t.triggerid and t.status=%d and f.function in ('nodata','date','dayofweek','time','now')"
" and i.itemid=f.itemid and (h.maintenance_status=%d or h.maintenance_type=%d)" DB_NODE,
ZBX_SQL_ITEM_SELECT,
HOST_STATUS_MONITORED,
ITEM_STATUS_ACTIVE,
TRIGGER_STATUS_ENABLED,
HOST_MAINTENANCE_STATUS_OFF, MAINTENANCE_TYPE_NORMAL,
DBnode_local("h.hostid"));
#######################################################################################################
- in process_time_functions() ##############################################
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-