Database upgrade from 3.4.8 to 4.0 failed

[taurix]

I'm upgrading my zabbix install to a clean install on a new Ubuntu 18.04 machine (MariaDB).
I imported the database, but the upgrade process fails with:

9332:20181010:174337.188 [Z3005] query failed: [1050] Table 'tag_filter' already exists [create table tag_filter (
`tag_filterid` bigint unsigned not null,
`usrgrpid` bigint unsigned not null,
`groupid` bigint unsigned not null,
`tag` varchar(255) default '' not null,
`value` varchar(255) default '' not null,
primary key (tag_filterid)

How can I fix this?

[ZabbPi]

A year since your post and am having the same issue with upgrading from 3.4.6 to 4.4 (mariadb > mysql, ubuntu 18.04 > ubuntu 19.04)
similar error:
[Z3005] query failed: [1050] Table 'tag_filter' already exists [create table tag_filter (
`tag_filterid` bigint unsigned not null,
`usrgrpid` bigint unsigned not null,
`groupid` bigint unsigned not null,
`tag` varchar(255) default '' not null,
`value` varchar(255) default '' not null,
primary key (tag_filterid)
) engine=innodb]
2370:20191104:104732.004 database upgrade failed

did you ever find an answer?

[dimir]

Looks like something is messed up in your database. You may delete the table and let server create it, connect to mysql, select zabbix database and execute:

drop table tag_filter;

You may want to back it up first.