Trouble upgrading from 2.4.8 to 3.4.4

[SBO]

Hi guys,

I'm trying to uprade our old zabbix server, currently running Zabbix 2.4.4 (with partitioned tables), to 3.4.4.

We have the DB running on MariaDB, on a separate server, so I made a snapshot before starting the upgrade operation.

After installing Zabbix 3.4.4, I start it, and in the zabbix-server logs, I can see that the database is upgrading. However, it blocks at 56% with the following error message :

[Z3005] query failed: [1034] Incorrect key file for table 'alerts'; try to repair it [alter table alerts add p_eventid bigint unsigned]

So I stopped the zabbix-server process, started the mysql console, did the alter table as written in the error message, started again ZBX, and it still blocks, with a different message this time, but still asking to do the same alter table :

[Z3005] query failed: [1060] Duplicate column name 'p_eventid' [alter table alerts add p_eventid bigint unsigned]

I'm really no expert in SQL so I don't know how to solve this.
Can someone help me out please ?

EDIT : I've found out this : https://support.zabbix.com/browse/ZBX-11381
Seems to be the same situation as me, but I just don't get what the resolution is, the page is a total mess.

[kaspars.mednis]

Also you can try to look here

https://www.zabbix.com/forum/showthread.php?t=59674

[SBO]

Will give it a try Thanks !