[ZBX-22377] Add note about log_bin_trust_function_creators during upgrade to 6.0 Created: 2023 Feb 17  Updated: 2025 Mar 18  Resolved: 2023 Mar 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 6.0.14rc1
Fix Version/s: 7.0 (plan)

Type: Documentation task Priority: Trivial
Reporter: Andrei Gushchin (Inactive) Assignee: Marina Generalova
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
Team: Team A
Story Points: 0.5

 Description   

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.



 Comments   
Comment by Marina Generalova [ 2023 Feb 24 ]

Added to Upgrade notes for 6.0.0 

Generated at Sat May 10 08:07:14 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.