Uprgade Problems from Zabbix 6.0.10 to 6.0.13

[GooseMann]

Hello forum,
I am running a Linux VM with Ubuntu Linux 20.04.5, Zabbix server 6.0.10, Webmin 2.013 and MySQL version 8.0.32-0ubuntu0.20.04.2. When I want to update the Zabbix packages. the server does not start anymore.

I get the following error message from the logs:

  1973:20230215:144448.548 Starting Zabbix Server. Zabbix 6.0.13 (revision fdfa8cef9ce).
  1973:20230215:144448.549 ****** Enabled features ******
  1973:20230215:144448.549 SNMP monitoring:           YES
  1973:20230215:144448.549 IPMI monitoring:           YES
  1973:20230215:144448.549 Web monitoring:            YES
  1973:20230215:144448.549 VMware monitoring:         YES
  1973:20230215:144448.549 SMTP authentication:       YES
  1973:20230215:144448.549 ODBC:                      YES
  1973:20230215:144448.549 SSH support:               YES
  1973:20230215:144448.549 IPv6 support:              YES
  1973:20230215:144448.549 TLS support:               YES
  1973:20230215:144448.549 ******************************
  1973:20230215:144448.549 using configuration file: /etc/zabbix/zabbix_server.conf
  1973:20230215:144448.567 current database version (mandatory/optional): 06000000/06000010
  1973:20230215:144448.567 required mandatory version: 06000000
  1973:20230215:144448.567 optional patches were found
  1973:20230215:144448.567 starting automatic database upgrade
  1973:20230215:144448.568 [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)]
  1973:20230215:144448.568 database upgrade failed

--
-- The unit zabbix-server.service has entered the 'failed' state with result 'protocol'.
Feb 15 13:50:13 srv-zabbix systemd[1]: Failed to start Zabbix Server.
-- Subject: A start job for unit zabbix-server.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit zabbix-server.service has finished with a failure.
--
-- The job identifier is 3643 and the job result is failed.
Feb 15 13:50:17 srv-zabbix multipathd[765]: sda: add missing path
Feb 15 13:50:17 srv-zabbix multipathd[765]: sda: failed to get udev uid: Invalid argument
Feb 15 13:50:17 srv-zabbix multipathd[765]: sda: failed to get sysfs uid: Invalid argument
Feb 15 13:50:17 srv-zabbix multipathd[765]: sda: failed to get sgio uid: No such file or directory
Feb 15 13:50:22 srv-zabbix multipathd[765]: sda: add missing path
Feb 15 13:50:22 srv-zabbix multipathd[765]: sda: failed to get udev uid: Invalid argument
Feb 15 13:50:22 srv-zabbix multipathd[765]: sda: failed to get sysfs uid: Invalid argument
Feb 15 13:50:22 srv-zabbix multipathd[765]: sda: failed to get sgio uid: No such file or directory
Feb 15 13:50:23 srv-zabbix systemd[1]: zabbix-server.service: Scheduled restart job, restart counter is at 39.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support​

THX 4 help!

[pzn]

I'm not sure about my answer, but give it a try:

Open mysql and run the following query (as mysql root user):

SET GLOBAL log_bin_trust_function_creators = 1;​

[GooseMann]

pzn ,

thank you very much for your help. Your suggestion was spot on and solved my problem.

[cyber]

Just googling for error message would have given you the answer (answered here in forum tens of times already...)

I cannot stress enough, that RTFM is still a good approach...
It is always good to read upgrade notes, not just for latest version but all the in-between ones also... like https://www.zabbix.com/documentation...ade_notes_6011 where you can find exactly this answer...