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

Event correlation will not work with empty tag values and Oracle database

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.2.3
    • Fix Version/s: 3.2.4rc1, 3.4.0alpha1
    • Component/s: Server (S)
    • Labels:
      None

      Description

      Create a trigger with event correlation ('OK event closes' is set to 'All problems if tag values match').

      The event correlation will not work if the matching tag values are empty - Zabbix would try to match tag values with empty strings, while Oracle stores them as NULL values.

      Similar problem is with global event correlation 'event tag pair' and 'old event tag value' conditions.

      The DBadd_str_condition_alloc() must correctly handle empty values when working with Oracle database and correlation_condition_add_tag_match() must use ZBX_SQL_STRVAL_EQ() macro for tag value comparison.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            wiper Andris Zeila
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: