-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.9.7 (beta)
-
None
Error when i am trying delete items from zabbix gui:
Error in query [DELETE FROM items WHERE (itemid IN ('1017542','1017543','1017531','1017541','1017540','1017532','1017534','1017535','1017583','1017620','1017621','1017619','1017600','1017617','1017789','1017787','1017785','1017784','1017790','1017786','1017796','1017783','1017800','1017798','1017797','1017791','1017782','1017774','1017775','1017773','1017772','1017771','1017776','1017770','1017777','1017781','1017780','1017778','1017779','1017659','1017660','1017658','1017655','1017661','1017656','1017657','1017664','1017667','1017650','1017666','1017665','1017663','1017662','1017637','1017638','1017639','1017635','1017634','1017633','1017649','1017640','1017636','1017641','1017645','1017646','1017644','1017643','1017642','1017710','1017709','1017708','1017707','1017704','1017702','1017711','1017703','1017705','1017706','1017719','1017720','1017721','1017701','1017718','1017717','1017713','1017714','1017716','1017712','1017715','1017684','1017686','1017687','1017688','1017683','1017682','1017700','1017680','1017681','1017689','1017685','1017697','1017698','1017690','1017699','1017695','1017696','1017694','1017691','1017693','1017692','1017513','1017514','1017515','1017512','1017516','1017507','1017517','1017508','1017509','1017510','1017511','1017529','1017526','1017527','1017528','1017506','1017525','1017524','1017519','1017521','1017522','1017523','1017518','1017520','1017489','1017488','1017490','1017491','1017492','1017487','1017486','1017505','1017483','1017484','1017485','1017493','1017482','1017502','1017503','1017504','1017494','1017500','1017501','1017499','1017495','1017497','1017496','1017498','1017753','1017754','1017756','1017757','1017755','1017747','1017748','1017749','1017750','1017751','1017752','1017763','1017767','1017766','1017768','1017769','1017746','1017765','1017764','1017759','1017760','1017761','1017762','1017758','1017734','1017728','1017729','1017730','1017731','1017727','1017726','1017722','1017723','1017724','1017725','1017745','1017732','1017741','1017742','1017743','1017744','1017733','1017740','1017735','1017739','1017736','1017737','1017738')) ] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`graphs`, CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`))]
?????? ??? ?????????? SQL ??????? "DELETE FROM items WHERE (itemid IN ('1017542','1017543','1017531','1017541','1017540','1017532','1017534','1017535','1017583','1017620','1017621','1017619','1017600','1017617','1017789','1017787','1017785','1017784','1017790','1017786','1017796','1017783','1017800','1017798','1017797','1017791','1017782','1017774','1017775','1017773','1017772','1017771','1017776','1017770','1017777','1017781','1017780','1017778','1017779','1017659','1017660','1017658','1017655','1017661','1017656','1017657','1017664','1017667','1017650','1017666','1017665','1017663','1017662','1017637','1017638','1017639','1017635','1017634','1017633','1017649','1017640','1017636','1017641','1017645','1017646','1017644','1017643','1017642','1017710','1017709','1017708','1017707','1017704','1017702','1017711','1017703','1017705','1017706','1017719','1017720','1017721','1017701','1017718','1017717','1017713','1017714','1017716','1017712','1017715','1017684','1017686','1017687','1017688','1017683','1017682','1017700','1017680','1017681','1017689','1017685','1017697','1017698','1017690','1017699','1017695','1017696','1017694','1017691','1017693','1017692','1017513','1017514','1017515','1017512','1017516','1017507','1017517','1017508','1017509','1017510','1017511','1017529','1017526','1017527','1017528','1017506','1017525','1017524','1017519','1017521','1017522','1017523','1017518','1017520','1017489','1017488','1017490','1017491','1017492','1017487','1017486','1017505','1017483','1017484','1017485','1017493','1017482','1017502','1017503','1017504','1017494','1017500','1017501','1017499','1017495','1017497','1017496','1017498','1017753','1017754','1017756','1017757','1017755','1017747','1017748','1017749','1017750','1017751','1017752','1017763','1017767','1017766','1017768','1017769','1017746','1017765','1017764','1017759','1017760','1017761','1017762','1017758','1017734','1017728','1017729','1017730','1017731','1017727','1017726','1017722','1017723','1017724','1017725','1017745','1017732','1017741','1017742','1017743','1017744','1017733','1017740','1017735','1017739','1017736','1017737','1017738')) "