Error import database from zabbix 5 to zabbix 6.4

[cronoping]

Hi all,
I have an issue related to import db from zabbix 5 to zabbix 6.4.
I have zabbix 6.4 and all works fine, I tried to import the database from zabbix 5 (that also works fine), follow zabbix documentation.
When I restarted zabbix server on the 6.4 I get this error in the log file

2281:20230713:192702.081 using configuration file: /etc/zabbix/zabbix_server.conf
2281:20230713:192702.087 current database version (mandatory/optional): 05000000/05000007
2281:20230713:192702.087 required mandatory version: 06040000
2281:20230713:192702.087 mandatory patches were found
2281:20230713:192702.087 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]
2281:20230713:192702.087 cannot retrieve database time
2281:20230713:192702.087 Zabbix Server stopped. Zabbix 6.4.4 (revision a749236b3d9).

Someone had the same error? Any idea how to solve it?
I'm looking on the network, I see other users with the same issue but without solution...
Thank you in advance, regards

[ipguy]

Did you have any success with this, we are facing the same issue

[cyber]

Do not import v5 data into v6.4 DB schema... that's all..
Topic starter said, that hist 6.4 was working ok and then he just overwrote everything with info from v5 database... resulting with

2281:20230713:192702.087 current database version (mandatory/optional): 05000000/05000007
2281:20230713:192702.087 required mandatory version: 06040000

Then started up 6.4, which tried to patch it to required version... but failed as there are still tables from 6.4 (v5 import did not erase any tables)...

2281:20230713:192702.087 mandatory patches were found
2281:20230713:192702.087 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]

Those patches need that DB is with correct schema and no extra tables...

If you really want your v5 to be upgraded to 6.4, then create empty DB (no schema creation for 6.4) and users and then import your v5 data. After that, starting server should find everything patchworthy and do its things...