Upgrading Zabbix Docker Error when Upgrading Mysql container

[sliu40731]

Hello. I am new here.

I am using Zabbix 6.2 Docker with watchtower (auto-update tool for docker container). Everything goes well since I started to use Zabbix three months ago.

But last night when Zabbix Docker was auto-upgrading, something wrong with mysql docker happened. Today I found every other docker container runs normally except for mysql. The mysql docker restarted continuously.

I tried to check the container logs and found this:

     9:20221201:033702.593 Starting Zabbix Server. Zabbix 6.2.5 (revision c6d01ae).
     9:20221201:033702.593 ****** Enabled features ******
     9:20221201:033702.593 SNMP monitoring:           YES
     9:20221201:033702.593 IPMI monitoring:           YES
     9:20221201:033702.593 Web monitoring:            YES
     9:20221201:033702.593 VMware monitoring:         YES
     9:20221201:033702.593 SMTP authentication:       YES
     9:20221201:033702.593 ODBC:                      YES
     9:20221201:033702.593 SSH support:               YES
     9:20221201:033702.593 IPv6 support:              YES
     9:20221201:033702.593 TLS support:               YES
     9:20221201:033702.593 ******************************
     9:20221201:033702.593 using configuration file: /etc/zabbix/zabbix_server.conf
     9:20221201:033702.647 current database version (mandatory/optional): 06020000/06020006
     9:20221201:033702.647 required mandatory version: 06020000
     9:20221201:033702.647 optional patches were found
     9:20221201:033702.647 starting automatic database upgrade
     9:20221201:033702.649 [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)]
     9:20221201:033702.649 database upgrade failed​

Since I am not familiar with mysql or any other database softwares, would anyone please teach me how to deal with this problem?

Many thanks guys.

[robertronq]

Try the tips suggested in this post https://www.zabbix.com/forum/zabbix-...-documentation.
I was finally able to upgrade from 6.0.10 to 6.2.5.

[sliu40731]

It works. Many thanks.

Try the tips suggested in this post https://www.zabbix.com/forum/zabbix-...-documentation.
I was finally able to upgrade from 6.0.10 to 6.2.5.