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.

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.2, 1.9.0 (alpha)
    • Fix Version/s: 1.8.3, 1.9.0 (alpha)
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Linux, Zabbix server

      Description

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

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: