Database upgrade from Zabbix 5.0.15 to Zabbix 5.2.7 failed

I'm upgrading my zabbix  to a clean install on a new Centos8.4 machine (MariaDB).

After import old sql,restart zabbix-server ,Web page can open but can't login,watch zabbix log

tail -f /var/log/zabbix/zabbix_server.log

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)

Fix:

Login mysql

use zabbix;
drop table tag_filter;

 

posted @ 2021-09-01 16:14  希曼博客  阅读(242)  评论(0编辑  收藏  举报