Steps to reproduce:

1. Create a new host with LLD (set Delete lost resources to Immediate for faster result)
2. Add this host as a target for action operation
3. Change LLD data so that the host is not discovered, rerun the rule

Result:

1. The host is not deleted
2. zabbix_server.log contains the error:

517972:20240830:160229.283 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix7`.`opcommand_hst`, CONSTRAINT `c_opcommand_hst_2` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`)) [delete from host_tag where hostid=10631;

Expected:

1. Host deleted
2. Action is either disabled or marked as incomplete