-
Incident report
-
Resolution: Won't fix
-
Major
-
None
-
3.0.8
-
None
My zabbix server keeps throwing insert errors on graphs_items because of foreign key constraints. I finally managed to track down the error to the insert statement below. When I tried to do further diagnosis; I find that the graphid and itemid don't exist at all in my server. How is the server trying to insert data for a graphid that doesn't even exist?
insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values (183241,84078,512467,0,0,'2774A4',0,2,0),(183242,84078,512466,0,1,'A54F10',0,2,0)
mysql> select * from items where itemid=512467;
Empty set (0.00 sec)
mysql> select * from items where itemid=512466;
Empty set (0.00 sec)
mysql> select * from graphs where graphid=84078;
Empty set (0.00 sec)