zabbix 3.0 升级数据库到zabbix3.4
错误信息：query failed: Can't DROP 'id'; check that column/key exists
slow query: 62.783980 sec, "alter table history_text drop column id"
解决方法如下：
1、登陆数据库，扩展zabbixhistory_text表的id 字段
use zabbix;
alter tablehistory_text add id bigint(20) unsigned NOT NULL;
2、杀掉zabbix_server 进程
ps -ef |grep zabbx_server|awk '{print $2}" |xargs kill -9
3、启动
/usr/local/zabbix/sbin/zabbix_server-c /usr/local/zabbix/etc/zabbix_server.conf
页:
[1]