-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
4.4.3
I removed from host all items, triggers, graphs and so on.
But when i try to delete this host I get this error in Web UI:
Cannot delete host - Error in query [DELETE FROM hosts WHERE hostid='10417'] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`))] - SQL statement execution has failed "DELETE FROM hosts WHERE hostid='10417'" [hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DB::exception() in include/classes/db/DB.php:847]
Debug information in file debug_output.txt
Expected:
Succesfully delete the host.
