Migration Zabbix 5.0.1 vers 6.4 sur nouveau serveur

[DarkWall]

Bonjour,

J'ai fais un backup de la DB mysql sur zabbix 5.0.1 sur un ubuntu 18.04. J'ai monter un nouveau serveur ubuntu 22.04 installer Zabbix sur Nginx avec mysql fais un restore de la DB version 5 sur le nouveau server (22.04) et maintenant lorsque je demarre zabbix server jobtien ceci comme msg ds les logs de zabbix.

2100:20230512:132745.706 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]


2100:20230512:132745.689 Starting Zabbix Server. Zabbix 6.4.2 (revision dbfe71773cf).
2100:20230512:132745.689 ****** Enabled features ******
2100:20230512:132745.689 SNMP monitoring: YES
2100:20230512:132745.689 IPMI monitoring: YES
2100:20230512:132745.689 Web monitoring: YES
2100:20230512:132745.689 VMware monitoring: YES
2100:20230512:132745.689 SMTP authentication: YES
2100:20230512:132745.689 ODBC: YES
2100:20230512:132745.689 SSH support: YES
2100:20230512:132745.689 IPv6 support: YES
2100:20230512:132745.689 TLS support: YES
2100:20230512:132745.689 ******************************
2100:20230512:132745.689 using configuration file: /etc/zabbix/zabbix_server.conf
2100:20230512:132745.704 current database version (mandatory/optional): 05000000/05000000
2100:20230512:132745.704 required mandatory version: 06040000
2100:20230512:132745.705 mandatory patches were found
2100:20230512:132745.706 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]
2100:20230512:132745.706 cannot retrieve database time
2100:20230512:132745.706 Zabbix Server stopped. Zabbix 6.4.2 (revision dbfe71773cf).

Quelqu un peut m aider sur se cas?

[DarkWall]

Merci tout le monde j'ai trouver le probleme.

Merci

[levon74]

Merci tout le monde j'ai trouver le probleme.

Merci

Bonjour DarkWall, how did you fix the problem? I have the same problem upgrading from Zabbix 5.4 to 6.4.4

[DarkWall]

Si je me souvient bien c'était mon backup qui était corrompu comment as tu fait ton backup?

[levon74]

Si je me souvient bien c'était mon backup qui était corrompu comment as tu fait ton backup?

J'utilize mysqldump, je fait mysqldump -u zabbix -p --lock-tables=false zabbix --no-tablespaces -q > /database/dbdumps/zabbix01-$(date +%F).sql

The column ha_failover_delay is really missing in the 5.4 DB.
I'm not sure how the hell the 6.4 DB upgrader requires that column to be there if it perfectly knows that the 5.4 DB doesn't have it...