Database upgrade failed on patch 06030084

[zaben]

Due to hardware failure we had to migrate Zabbix from an old to a new server. On the new server we installed the current Zabbix version and transferred the old database. The server migrated the database up to 06030083, but patch 06030084 fails. I tried to follow [1] and set log_bin [2] as suggested. As this did not help I did a
manual upgrade of history tables to primary keys as described in [1], despite I think I already did this on the old server some version upgrades ago. But this did also not fix the issue.

Help, I am stuck with my patches ... stepforum?

[1] https://www.zabbix.com/documentation...rade_notes_600
[2] SET GLOBAL log_bin_trust_function_creators = 1;

[zaben]

Fixed the issue. The first attempt of the server to upgrade the database without log_bin_trust_function_creators = 1 broke something in the database and got further patches stuck somehow.

FIX: Stop the server. Set global log_bin_trust_function_creators = 1 and grant priv user to zabbix user (beside I think this should not be necessary); then drop database zabbix and reimport from old server backup. Start the server and wait for upgrades to finish. Reset log_bin_trust_function_creators = 0 and remove priv user rights.

[zaben]

Fixed the issue. The first attempt of the server to upgrade the database without log_bin_trust_function_creators = 1 broke something in the database and got further patches stuck somehow.

FIX: Stop the server. Set global log_bin_trust_function_creators = 1 and grant priv user to zabbix user (beside I think this should not be necessary); then drop database zabbix and reimport from old server backup. Start the server and wait for upgrades to finish. Reset log_bin_trust_function_creators = 0 and remove priv user rights.