错误信息:
[Z3005] query failed: [1091] Can't DROP 'id'; check that column/key exists [alter table history_text drop column id]
slow query: 62.783980 sec, "alter table history_text drop column id"
解决方法如下:
1、登陆数据库,扩展zabbix history_text表的id 字段
use zabbix;
alter table history_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
转载于:https://blog.51cto.com/ttxjs/2103615