解决zabbix_server日志反复提示“Something

无意中查看Zabbix服务器日志，发现多个错误提示“Zabbix_server [28832]: ERROR [file:lld_item.c,line:719] Something impossible has just happened."

经查，这是由于孤立记录的存在，需要清除掉，方法也很简单，先登录上zabbix的MySql数据库

$ mysql -uroot -pxxxxxxx
mysql>use zabbix;
mysql>select count(*) from item_preproc where itemid not in (select itemid from items);
+------------------+
|   count(*)        |
+------------------+
|          169       |
+------------------+
1 row in set(0.01 sec)
mysql>delete from item_preproc where itemid not in (select itemid from items);
mysql>exit;
$ tail -f /tmp/zabbix_server.log  # 再观察一下是否还有类似错误出现

然后可以再观察一下是否还有类似错误出现。

参考： [ZBX-17116] ERROR [file:lld_item.c,line:866] Something impossible has just happened - ZABBIX SUPPORT