[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: |
|
||||
Team: | |||||
Story Points: | 0.5 |
Description |
Steps to reproduce: 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 Please add it there as well. |
Comments |
Comment by Marina Generalova [ 2023 Feb 24 ] |
Added to Upgrade notes for 6.0.0 |