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

Details

    • Problem report
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 5.0.11
    • None
    • Server (S)
    • None

    Description

      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))]
      

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            wiper Andris Zeila
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: