[ZBX-19351] Global event correlation might result in SQL errors with Oracle Created: 2021 May 11  Updated: 2024 Apr 10  Resolved: 2022 Jan 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 5.0.11
Fix Version/s: 5.0.20rc1, 5.4.10rc1, 6.0.0beta2, 6.0 (plan)

Type: Problem report Priority: Trivial
Reporter: Andris Zeila Assignee: Sergey Simonenko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Team: Team B
Sprint: Sprint 83 (Dec 2021), Sprint 84 (Jan 2022)
Story Points: 0.1

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


 Comments   
Comment by Sergey Simonenko (Inactive) [ 2021 Dec 16 ]

Fixed in:

Generated at Tue Jun 03 18:23:48 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.