Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-2733

Zabbix timer process evaluate same item triggers per 30 sec even if a trigger including "nodata()" is disabled.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.3, 1.9.0 (alpha)
    • 1.8.2, 1.9.0 (alpha)
    • Server (S)
    • 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.

                                                                      1. 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"));
                                                                        #######################################################################################################

      I think following is correct.

                                                                      1. 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"));
                                                                        #######################################################################################################

        1. zbx_03.png
          zbx_03.png
          61 kB
        2. zbx_04.png
          zbx_04.png
          59 kB
        3. zbx_05.png
          zbx_05.png
          75 kB
        4. zbx_01.png
          zbx_01.png
          38 kB
        5. zbx_02.png
          zbx_02.png
          45 kB
        6. trunk_r13332_FixTimerCheck.patch
          1 kB

            Unassigned Unassigned
            tsuzuki Takanori Suzuki
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: