21 Notas de actualización para 6.0.11

Cambios importantes

DB scheme 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, created 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.

Errores de análisis de JSONPath

En esta versión se producen errores de análisis de JSONPath en caso de espacios en blanco iniciales y una matriz/objeto vacío. Corregido en Zabbix 6.0.12.

Evaluación Y/O en filtros LLD

La evaluación de expresiones AND/OR en los filtros/anulaciones de descubrimiento de bajo nivel puede fallar en esta versión. Corregido en Zabbix 6.0.12.