Migrate Zabbix 5.0 on ubuntu 18.04 to new server ubuntu 22.04 DB error not upgraded

[DarkWall]

Good morning,

I made a backup of the mysql DB on zabbix 5.0.1 on an ubuntu 18.04. I installed a new ubuntu 22.04 server install Zabbix on Nginx with mysql do a DB version 5 restore on the new server (22.04) and now when I start zabbix server I get this as msg in zabbix logs.

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



Here is the full log


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).

Thanks everyone in advanced

[DarkWall]

Thanks all but I found my issue thanks

[tim.mooney]

And what was the issue? Providing a little clue for what the issue was and how you fixed it may help someone else.

[DarkWall]

It was an issue with the backup file. I did it with webmin the dump instead of mysqldump...