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

Global event correlation might result in SQL errors with Oracle

XMLWordPrintable

    • Sprint 83 (Dec 2021), Sprint 84 (Jan 2022)
    • 0.1

      1. Create global correlation rule with two conditions and 'A or B' type of calculation:
        • event tag pair
        • old event tag name
      2. Create trigger with tag that is different from the new even tag specified in 'event tag pair' condition.
      3. Fire the trigger

      Observe SQL error in Zabbix log, like

       [Z3005] query failed: [-1] ORA-00920: invalid relational operator [select p.eventid,p.objectid,c.correlationid from correlation c,problem p where p.r_eventid is null and p.source=0 and (c.correlationid=1 and (exists (select null from problem_tag pt where p.eventid=pt.eventid and pt.tag='enabled') or 0))]

            ssimonenko Sergey Simonenko (Inactive)
            wiper Andris Zeila
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: