7.0.0alpha8 upgrade dailed

[mellis]

I am running a yesy system on a handfull of raspberry pi systems, using a pi4m 8gb, Server version: 10.5.21-MariaDB-0+deb11u1-log Raspbian 11. I downloaded and updated my 7.0.0alpha7 and now i am getting a database version error :

• The Zabbix database version does not match current requirements. Your database version: 6050154. Required version: 6050158. Please contact your system administrator.

In the log file has :

18114:20231128:054420.302 In zbx_db_connect() flag:0
18114:20231128:054420.303 End of zbx_db_connect():0
18114:20231128:054420.303 In zbx_dbms_version_info_extract()
18114:20231128:054420.303 MariaDB fork detected
18114:20231128:054420.303 End of zbx_dbms_version_info_extract() version:100521
18114:20231128:054420.304 In zbx_db_check_version_and_upgrade()
18114:20231128:054420.304 In zbx_db_connect() flag:0
18114:20231128:054420.305 End of zbx_db_connect():0
18114:20231128:054420.305 query [txnlev:0] [show tables like 'dbversion']
18114:20231128:054420.306 query [txnlev:0] [select mandatory,optional from dbversion]
18114:20231128:054420.307 current database version (mandatory/optional): 06050154/06050154
18114:20231128:054420.307 required mandatory version: 06050158
18114:20231128:054420.307 mandatory patches were found
18114:20231128:054420.307 query [txnlev:0] [show tables like 'ha_node']
18114:20231128:054420.309 query [txnlev:1] [begin;]
18114:20231128:054420.309 query [txnlev:1] [select unix_timestamp(),ha_failover_delay from config]
18114:20231128:054420.310 query [txnlev:1] [select lastaccess,name from ha_node where status not in (1,2) order by ha_nodeid for update]
18114:20231128:054420.311 query [txnlev:1] [commit;]
18114:20231128:054420.311 starting automatic database upgrade
18114:20231128:054420.311 query [txnlev:1] [begin;]
18114:20231128:054420.312 query [txnlev:1] [select optional,mandatory from dbversion for update]
18114:20231128:054420.312 query [txnlev:1] [drop trigger items_name_upper_insert]
18114:20231128:054420.313 [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) [drop trigger items_name_upper_insert]
18114:20231128:054420.313 query [drop trigger items_name_upper_insert] failed, setting transaction as failed
18114:20231128:054420.313 query [txnlev:1] [rollback;]
18114:20231128:054420.313 database upgrade failed on patch 06050155, exiting in 10 seconds
18114:20231128:054430.313 End of zbx_db_check_version_and_upgrade():FAIL
18114:20231128:054430.314 Zabbix Server stopped. Zabbix 7.0.0alpha8 (revision 78774f702f8).

Anyone have an idea how to fix this issue?

[cyber]

your log says....
18114:20231128:054420.313 [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) [drop trigger items_name_upper_insert]
it failed with DB upgrade...

https://www.zabbix.com/documentation/devel/en/manual/appendix/install/db_scripts?hl=log_bin_trust_function_creators