Hi everyone.

I've tried to update my Zabbix 5.4 to 6.4 version.

Scenario:

1 - We had an old Centos 7 with Zabbix 5.4

2 - I started up a new server Centos 9 

3 - Configured the new server with Zabbix Settings (6.4) to receive the Database from the Zabbix 5.4

4 - I finished the database import: mysql -u root zabbix < /bkpzabbix/zabbix_backup.sql

5 - update dbversion set mandatory=06040000,optional=06040000;

6 - The Zabbix Database Update automatic didn't occurr as expected

7 - Received the log below:

 24235:20230731:144350.606 using configuration file: /etc/zabbix/zabbix_server.conf
 24235:20230731:144350.817 current database version (mandatory/optional): 06040000/06040000
 24235:20230731:144350.817 required mandatory version: 06040000
 24235:20230731:144350.817 optional patches were found
 24235:20230731:144350.817 starting automatic database upgrade
 24235:20230731:144350.832 [Z3005] query failed: [1072] Key column 'cause_eventid' doesn't exist in table [create index problem_4 on problem (cause_eventid)]
 24235:20230731:144350.832 database upgrade failed on patch 06040001, exiting in 10 seconds

8 - It's not seems related with 'history' entries in database problems (I tried to prepare the database before de import again: mysql -u zabbix -p zabbix < /usr/share/zabbix-sql-scripts/mysql/history_pk_prepare.sql

9 - Same log errors as the step 7.

I don't know where to go here. Can someone help me to proceed please?

thanks.

I don't k