Zabbix server process keeps stopping and starting

[iamvirtual]

On 6.2.9. Tried going to 7.4 on a cloned copy and that failed due to an error "database upgrade failed on patch 06020007." So I shut down the cloned VM copy and went back to the original virtual server. But started noticing that I was seeing in the GUI a message that 'Zabbix server is not running: Information displayed may not be current." I had not run the upgrade on this virtual server.

When I checked the /var/log/zabbix/zabbix_server.log file I saw the same "database upgrade failed on patch 06020007" message.

I even tried restoring a server from almost 3 weeks ago and saw the 'Zabbix server is not running: Information displayed may not be current" popping up. No one here had really been working with the Zabbix server and I was trying to see if I could clean it up, add more relevant monitoring to make it worth using. But before I can really do that, I need to get the system stabilized.

Any ideas on how to fix this? I search the Internet for that specific database upgrade error and could not find any reference to it.

[cyber]

No, it is not doing anything wrong.. Mandatory is what is minimal for it to work, patch 00006 is the last one installed if it tries to install more, it is OK.
Privileges are also mentioned in installation docs, so you can follow those..

https://www.zabbix.com/documentation/current/en/manual/appendix/install/db_scripts

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
You can disable it later, after your updates are done.

[cyber]

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/libs/zbxdbupgrade/dbupgrade_6020.c?at=refs%2Fheads%2Frelease%2F6.2#109-119

Heres your failing patch...
But to be honest, I have no idea, how to fix this... Sounds like some unattended upgrade has gone south... Some permission issues somewhere or... A bit too much for guesswork..

[iamvirtual]

From the log file:

137868:20250815:173652.994 Zabbix Server stopped. Zabbix 6.2.9 (revision 886cdd0ada3).
137905:20250815:173703.222 Starting Zabbix Server. Zabbix 6.2.9 (revision 886cdd0ada3).
137905:20250815:173703.222 ****** Enabled features ******
137905:20250815:173703.222 SNMP monitoring: YES
137905:20250815:173703.222 IPMI monitoring: YES
137905:20250815:173703.222 Web monitoring: YES
137905:20250815:173703.222 VMware monitoring: YES
137905:20250815:173703.222 SMTP authentication: YES
137905:20250815:173703.222 ODBC: YES
137905:20250815:173703.222 SSH support: YES
137905:20250815:173703.222 IPv6 support: YES
137905:20250815:173703.222 TLS support: YES
137905:20250815:173703.222 ******************************
137905:20250815:173703.222 using configuration file: /etc/zabbix/zabbix_server.conf
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
137905:20250815:173703.237 current database version (mandatory/optional): 06020000/06020006
137905:20250815:173703.237 required mandatory version: 06020000
137905:20250815:173703.237 optional patches were found
137905:20250815:173703.237 starting automatic database upgrade
137905:20250815:173703.239 [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)]
137905:20250815:173703.239 database upgrade failed on patch 06020007, exiting in 10 seconds
137905:20250815:173713.239 Zabbix Server stopped. Zabbix 6.2.9 (revision 886cdd0ada3).

============================================
So it looks like there are two issues. One is that the version that it is trying to upgrade to is beyond the mandatory and optional versions. Second issue is the permissions issues spelled out in the entry "137905:20250815:173703.239 [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."

Since I am relatively new to Zabbix, I am not sure whether I should look at getting the Super privilege indicated for the account launching the Zabbix server or where I would even consider doing the "less safe" recommendation.

But the whole thing where it is trying to update to a version past the optional or mandatory versions has me wondering why it is even trying to do the patch 06020007 upgade.

Any advice/clarification would be appreciated.

[cyber]

No, it is not doing anything wrong.. Mandatory is what is minimal for it to work, patch 00006 is the last one installed if it tries to install more, it is OK.
Privileges are also mentioned in installation docs, so you can follow those..

https://www.zabbix.com/documentation/current/en/manual/appendix/install/db_scripts

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
You can disable it later, after your updates are done.

[iamvirtual]

That seems to have worked. The database upgrade completed. Thanks! Should I assume that undoing the command would be SET GLOBAL log_bin_trust_function_creators = 0; ?

[cyber]

Should I assume that undoing the command would be SET GLOBAL log_bin_trust_function_creators = 0; ?

yes, that is how you revert it...

[iamvirtual]

Thanks! I really appreciate your help in getting things back up and running.