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.
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:
Once the upgrade has been successfully completed,
log_bin_trust_function_creators can be disabled:
Triggers are also created for PostgreSQL and Oracle database.
JSONPath parsing errors occur in this version in case of leading whitespace and empty array/object. Fixed in Zabbix 6.0.12.
The evaluation of AND/OR expressions in the low-level discovery filters/overrides may fail in this version. Fixed in Zabbix 6.0.12.