[ZBX-11740] Event correlation will not work with empty tag values and Oracle database Created: 2017 Jan 25 Updated: 2017 May 30 Resolved: 2017 Feb 13 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 3.2.3 |
| Fix Version/s: | 3.2.4rc1, 3.4.0alpha1 |
| Type: | Incident report | Priority: | Major |
| Reporter: | Andris Zeila | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| 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. |
| Comments |
| Comment by Andris Zeila [ 2017 Jan 27 ] |
|
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-11740 |
| Comment by Vjaceslavs Bogdanovs [ 2017 Feb 01 ] |
|
Successfully tested. |
| Comment by Andris Zeila [ 2017 Feb 09 ] |
|
Released in:
|