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;
本文来自希曼博客-www.ximan.tech,作者:希曼博客,转载请注明原文链接:https://www.cnblogs.com/lihuaichen/p/15215107.html