-
Incident report
-
Resolution: Cannot Reproduce
-
Critical
-
None
-
2.0.11
-
None
We just made the upgrade zabbix server from 1.8.20 to 2.0.11.
During this upgrade zabbix proxy binaries has been updated as well. Agents across all monitored boxes we still have zabbix agents in 1.8.x versions.
After recreate database on each proxy (drop database -> create empty one and import 2.0. schema.sql file) now we are observing several errors in proxy logs like below:
27911:20140326:173402.285 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestit em_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into httptestitem (httptestitemid,httptestid,itemid,type) values (1850,254,1616655,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (1851,263,1639726,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (1852,263,1639727,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (1853,263,1639728,4);
As DB backend on these proxies is mysql 5.1.
{71,73}.
We are not sure what exact impact is of this errors.