[Z3005] query failed: [1451] Cannot delete or update a parent row

[clayton940]

Hello,
I have a job that is supposed to run to delete a host if it see's that it's down for a period of time.

However I think the job isn't executing right as I'm seeing the following displayed in my log:
And I only see this when I stop/start the zabbix server but I think it's related

596:20160210:003303.139 [Z3005] query failed: [1451] Can
etween 5786 and 5790 or resourceid in (5932,5933,5934,5935));
delete from profiles where idx='web.favorite.graphids' and source='graphid' and (value_id between 5786 and 5790 or value_id in (5932,5933,5934,5935));
delete from graphs where (graphid between 5786 and 5790 or graphid in (5932,5933,5934,5935));
]
596:20160210:003303.160 [Z3005] query failed: [1451] Can
gerid' and (value_id between 24306 and 24318 or value_id in (16164,16165,16166,24530,24531,24532,24533));
delete from triggers where (triggerid between 24306 and 24318 or triggerid in (16164,16165,16166,24530,24531,24532,24533));
]
596:20160210:003303.207 [Z3005] query failed: [1451] Can
46880 or resourceid between 47479 and 47490 or resourceid in (29653,29654,29655));
delete from profiles where idx='web.favorite.graphids' and source='itemid' and (value_id between 46851 and 46880 or value_id between 47479 and 47490 or value_id in (29653,29654,29655));
delete from items where (itemid between 46851 and 46880 or itemid between 47479 and 47490 or itemid in (29653,29654,29655));
]
596:20160210:0
596:20160210:003303.616 [Z3005] query failed: [1451] Can
etween 5786 and 5790 or resourceid in (5932,5933,5934,5935));
delete from profiles where idx='web.favorite.graphids' and source='graphid' and (value_id between 5786 and 5790 or value_id in (5932,5933,5934,5935));
delete from graphs where (graphid between 5786 and 5790 or graphid in (5932,5933,5934,5935));
]
596:20160210:003303.635 [Z3005] query failed: [1451] Can
gerid' and (value_id between 24306 and 24318 or value_id in (16164,16165,16166,24530,24531,24532,24533));
delete from triggers where (triggerid between 24306 and 24318 or triggerid in (16164,16165,16166,24530,24531,24532,24533));
]
596:20160210:003303.648 [Z3005] query failed: [1451] Can
46880 or resourceid between 47479 and 47490 or resourceid in (29653,29654,29655));
delete from profiles where idx='web.favorite.graphids' and source='itemid' and (value_id between 46851 and 46880 or value_id between 47479 and 47490 or value_id in (29653,29654,29655));
delete from items where (itemid between 46851 and 46880 or itemid between 47479 and 47490 or itemid in (29653,29654,29655));
]
596:20160210:0


here is my action for removing the host:

(A) Discovery rule = WIN/LIN/UX Servers
(B) Uptime/Downtime >= 120
(C) Discovery status = Down
(D) Service type = ICMP ping

Operation:

Remove Host

can someone help with this?

[glebs.ivanovskis]

Something very similar was fixed in one of the latest minor releases. Could you tell which version you use?