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

Overview triggers filter tag bug

    XMLWordPrintable

Details

    • Team B
    • Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021)
    • 1

    Description

      Steps to reproduce:

      1. rhel 8
        php 7.2
        postgresql-12
        apache 2.4.37 

      Clean install.

      Tag filters don't work when trying to make a custom panel in the trigger overview
       

       

      used sql queries for different tags, and somehow it works strangely: This is a request with Recent problems:

      SELECT p.eventid,p.acknowledged,p.objectid,p.severity,p.r_eventid FROM problem p WHERE p.source='0' AND p.object='0' AND p.objectid IN (19249,19263,20170) AND EXISTS (SELECT NULL FROM problem_tag WHERE p.eventid=problem_tag.eventid AND problem_tag.tag='Application' AND UPPER(problem_tag.value) LIKE '%PRINTER%' ESCAPE '!') AND (p.r_eventid IS NULL OR p.r_clock>1627403603);

      This is a request with the Problems field I have:

      SELECT p.eventid,p.acknowledged,p.objectid,p.severity,p.r_eventid FROM problem p WHERE p.source='0' AND p.object='0' AND p.objectid IN (19249,19263,20170) AND EXISTS (SELECT NULL FROM problem_tag WHERE p.eventid=problem_tag.eventid AND problem_tag.tag='Application' AND UPPER(problem_tag.value) LIKE '%PRINTER%' ESCAPE '!') AND p.r_eventid IS NULL;

      And here it is with Any:

      SELECT p.eventid,p.acknowledged,p.objectid,p.severity,p.r_eventid FROM problem p WHERE p.source='0' AND p.object='0' AND p.objectid IN (13075,13436,13467,13468,13470,13471,13472,13473,13474,13475,13476,13477,13479,13480,13481,13482,13483,13484,13485,13486,13487,13488,13489,13490,13537,13558,13560,13563,13567,13570,13571,15854,15856,16046,16054,16056,16060,16062,16064,16066,16068,16199,16274,16565,16581,17537,17538,18136,18138,18454,18532,18533,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,18973,18974,19046,19047,19048,19049,19050,19051,19052,19054,19055,19056,19057,19058,19059,19090,19091,19092,19093,19094,19095,19096,19098,19099,19100,19101,19102,19103,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19133,19134,19135,19136,19137,19138,19139,19140,19141,19168,19169,19170,19171,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19230,19231,19232,19233,19234,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19252,19253,19254,19255,19256,19257,19259,19260,19261,19262,19263,19264,19266,19267,19268,19269,19270,19271,19273,19274,19275,19276,19277,19278,19280,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND EXISTS (SELECT NULL FROM problem_tag WHERE p.eventid=problem_tag.eventid AND problem_tag.tag='Application' AND UPPER(problem_tag.value) LIKE '%PRINTER%' ESCAPE '!') AND p.r_eventid IS NULL;

      As a result: the last request does not contain the required objectid and therefore dumps everything that is

      If you add the required objectid, then it issues the required event by the required filter
       

       
      The problem is that triggers are not filtered by the tag specified in the filters

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            exesition Dmitriy
            Votes:
            5 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated: