Hi
Upgraded to version 2.2.0 on Server and on Proxies. I get the following message when forcing an config cache update or on a normal config update push from the server. Also some of the servers that used to be monitored shows on the server list but the proxy does not see it.
Below is the cache load error I am getting in the log
3207:20131119:091042.278 forced reloading of the configuration cache
3207:20131119:091042.301 Received configuration data from server. Datalen 30759
3207:20131119:091042.533 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix02/host_discovery`, CONSTRAINT `c_host_discovery_3` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`)) [delete from items where (itemid between 10055 and 10059 or itemid between 22700 and 22744 or itemid between 22755 and 22789 or itemid between 22796 and 22846 or itemid between 22851 and 22863 or itemid between 22867 and 22886 or itemid between 22891 and 22903 or itemid between 22907 and 22914 or itemid between 22920 and 22924 or itemid between 22938 and 22954 or itemid between 22980 and 22994 or itemid between 22996 and 23005 or itemid between 23011 and 23036 or itemid between 23058 and 23063 or itemid between 23067 and 23078 or itemid between 23108 and 23131 or itemid between 23134 and 23138 or itemid between 23158 and 23165 or itemid between 23167 and 23329 or itemid between 23340 and 23360 or itemid between 23542 and 23569 or itemid between 23575 and 23579 or itemid between 23595 and 23608 or itemid between 23628 and 23659 or itemid in (10009,10010,10013,10014,10016,10019,10020,10025,1 0026,10030,17318,17350,17352,17354,17356,17358,173 60,17362,22181,22183,22185,22187,22189,22191,22196 ,22199,22219,22231,22232,22396,22399,22400,22401,2 2402,22404,22406,22408,22410,22412,22414,22416,224 18,22420,22422,22424,22426,22428,22430,22444,22446 ,22448,22450,22452,22454,22456,22458,22665,22668,2 2671,22674,22677,22680,22683,22686,22689,22746,227 49,22793,22848,22888,22917,22918,22933,22934,22961 ,22962,22963,22965,22968,22971,22972,22973,22974,2 2978,23007,23039,23041,23042,23043,23053,23054,231 40,23143,23144,23145,23147,23148,23149,23150,23540 ,23572,23573,23585,23586,23587,23588,23593,23620,2 3625))]
3207:20131119:091042.545 failed to update local proxy configuration copy: database error
Please can someone help
Upgraded to version 2.2.0 on Server and on Proxies. I get the following message when forcing an config cache update or on a normal config update push from the server. Also some of the servers that used to be monitored shows on the server list but the proxy does not see it.
Below is the cache load error I am getting in the log
3207:20131119:091042.278 forced reloading of the configuration cache
3207:20131119:091042.301 Received configuration data from server. Datalen 30759
3207:20131119:091042.533 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix02/host_discovery`, CONSTRAINT `c_host_discovery_3` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`)) [delete from items where (itemid between 10055 and 10059 or itemid between 22700 and 22744 or itemid between 22755 and 22789 or itemid between 22796 and 22846 or itemid between 22851 and 22863 or itemid between 22867 and 22886 or itemid between 22891 and 22903 or itemid between 22907 and 22914 or itemid between 22920 and 22924 or itemid between 22938 and 22954 or itemid between 22980 and 22994 or itemid between 22996 and 23005 or itemid between 23011 and 23036 or itemid between 23058 and 23063 or itemid between 23067 and 23078 or itemid between 23108 and 23131 or itemid between 23134 and 23138 or itemid between 23158 and 23165 or itemid between 23167 and 23329 or itemid between 23340 and 23360 or itemid between 23542 and 23569 or itemid between 23575 and 23579 or itemid between 23595 and 23608 or itemid between 23628 and 23659 or itemid in (10009,10010,10013,10014,10016,10019,10020,10025,1 0026,10030,17318,17350,17352,17354,17356,17358,173 60,17362,22181,22183,22185,22187,22189,22191,22196 ,22199,22219,22231,22232,22396,22399,22400,22401,2 2402,22404,22406,22408,22410,22412,22414,22416,224 18,22420,22422,22424,22426,22428,22430,22444,22446 ,22448,22450,22452,22454,22456,22458,22665,22668,2 2671,22674,22677,22680,22683,22686,22689,22746,227 49,22793,22848,22888,22917,22918,22933,22934,22961 ,22962,22963,22965,22968,22971,22972,22973,22974,2 2978,23007,23039,23041,23042,23043,23053,23054,231 40,23143,23144,23145,23147,23148,23149,23150,23540 ,23572,23573,23585,23586,23587,23588,23593,23620,2 3625))]
3207:20131119:091042.545 failed to update local proxy configuration copy: database error
Please can someone help
Comment