-
Documentation task
-
Resolution: Fixed
-
Trivial
-
6.0.14rc1
-
None
-
0.5
Steps to reproduce:
If you doing upgrade with mysql or mariadb.
Upgrade might be failed with
11785:20230216:084114.168 using configuration file: /etc/zabbix/zabbix_server.conf 11785:20230216:084114.207 current database version (mandatory/optional): 05000000/05000007 11785:20230216:084114.207 required mandatory version: 06000000 11785:20230216:084114.207 optional patches were found 11785:20230216:084114.207 starting automatic database upgrade 11785:20230216:084148.675 cannot convert calculated item "333743"formula 11785:20230216:084210.583 \[Z3005] query failed: \[1419] You do not have the SUPER privilege and binary logging is enabled (you _might_ want to use the less safe log_bin_trust_function_creators variable) \[create trigger hosts_name_upper_insert before insert on hosts for each row set new.name_upper=upper([new.name|http://new.name])] 11785:20230216:084210.587 database upgrade failed
Expected:
Need to do steps like we have in upgrade notes for 6.2 here
https://www.zabbix.com/documentation/6.2/en/manual/installation/upgrade_notes_620?hl=log_bin_trust_function_creators
Please add it there as well.