21 Upgrade notes for 6.0.11

Breaking changes

DB schema update

A new column name_upper has been added to the database table items. The column contains a capitalized version of the item name or the LLD rule name. This change has been implemented to allow the use of the index with case-insensitive search for API query optimization.

Optimized API queries

API database queries, used when searching through names in the hosts and items tables, have been optimized and will now be processed more efficiently. As a result of this change, deterministic triggers need to be created during an upgrade.

On MySQL and MariaDB, this requires GLOBAL log_bin_trust_function_creators = 1 to be set if binary logging is enabled and there is no superuser privileges and log_bin_trust_function_creators = 1 is not set in MySQL configuration file. To set the variable using MySQL console, run:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;

Once the upgrade has been successfully completed, log_bin_trust_function_creators can be disabled:

mysql> SET GLOBAL log_bin_trust_function_creators = 0;

Triggers are also created for PostgreSQL and Oracle database.

JSONPath parsing errors

JSONPath parsing errors occur in this version in case of leading whitespace and empty array/object. Fixed in Zabbix 6.0.12.

AND/OR evaluation in LLD filters

The evaluation of AND/OR expressions in the low-level discovery filters/overrides may fail in this version. Fixed in Zabbix 6.0.12.