update 5.0 -> 5.2

[bdronka]

Hello, I have a problem with updating the database, maybe some of you know how to solve the problem:

20453:20201219:201853.543 completed 53% of database upgrade
20453:20201219:201853.543 [Z3005] query failed: [1050] Tabela 'trigger_queue' exists [create table trigger_queue (
`objectid` bigint unsigned not null,
`type` integer default '0' not null,
`clock` integer default '0' not null,
`ns` integer default '0' not null
) engine=innodb]
20453:20201219:201853.543 database upgrade failed

next rename trigger_queue to trigger_queue_bak and restart zabbix

20534:20201219:202628.658 [Z3005] query failed: [1050] Tabela 'item_parameter' już istnieje [create table item_parameter (
`item_parameterid` bigint unsigned not null,
`itemid` bigint unsigned not null,
`name` varchar(255) default '' not null,
`value` varchar(2048) default '' not null,
primary key (item_parameterid)
) engine=innodb]
20534:20201219:202628.658 database upgrade failed

next rename item_parameter to item_parameter_bak and restart zabbix


20547:20201219:202815.804 completed 10% of database upgrade
20547:20201219:202815.962 [Z3005] query failed: [1005] Nie można stworzyć tabeli `zabbix`.`item_parameter` (Kod błędu: 121 "Duplicate key on write or update") [alter table `item_parameter` add constraint c_item_parameter_1 foreign key (`itemid`) references `items` (`itemid`) on delete cascade]
20547:20201219:202815.962 database upgrade failed

I have no idea what to do next......

[yurtesen]

It looks like some differences in database schema can cause these problems. Perhaps you could compare a fresh 5.0 database schema with yours.
https://www.zabbix.com/forum/zabbix-...-to-4-0-failed
https://www.zabbix.com/forum/zabbix-...-1-same-result