Upgrade failed from 6.0.11 to 6.0.12

[SupportMD]

Hello,

I am on Debian buster/sid with mysql 5.7.40

I have upgraded Zabbix from 6.0.11 to 6.0.12 this morning but the service doesn't start.

This is the log :

26427:20221206:164348.598 database upgrade failed
26448:20221206:164400.799 Starting Zabbix Server. Zabbix 6.0.12 (revision 126aa2f53e9).
26448:20221206:164400.799 ****** Enabled features ******
26448:20221206:164400.799 SNMP monitoring: YES
26448:20221206:164400.799 IPMI monitoring: YES
26448:20221206:164400.799 Web monitoring: YES
26448:20221206:164400.799 VMware monitoring: YES
26448:20221206:164400.799 SMTP authentication: YES
26448:20221206:164400.799 ODBC: YES
26448:20221206:164400.799 SSH support: YES
26448:20221206:164400.799 IPv6 support: YES
26448:20221206:164400.799 TLS support: YES
26448:20221206:164400.799 ******************************
26448:20221206:164400.799 using configuration file: /etc/zabbix/zabbix_server.conf
26448:20221206:164400.840 current database version (mandatory/optional): 06000000/06000010
26448:20221206:164400.840 required mandatory version: 06000000
26448:20221206:164400.840 optional patches were found
26448:20221206:164400.840 starting automatic database upgrade
26448:20221206:164400.841 [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)]

I have set GLOBAL log_bin_trust_function_creators = 1; without effect.

Can you please help me to resolve ?

[Markku]

Note that your MySQL version 5.7.40 is not supported in Zabbix 6.0: https://www.zabbix.com/documentation...n/requirements

Maybe that is the reason for the problem?

(Also, Debian Buster ("oldstable") is different from Debian Sid ("unstable") so your setup sounds quite strange)

Markku