I am using Zabbix Server Version 2.0.7 on Red Hat Enterprise Linux 6.4.
This error occurred when I attempted to add a Zabbix proxy server as host manually while it was being discovered by Zabbix. I didn't know that Zabbix would find the host as it had been unsuccessful in the past. Yet, when it was discovered it added the host without a string for the name field in the hosts table in the database. Anyways, when I attempt to delete the hosts I get the message below.
I basically have a host that I cannot get rid of in the front end. This is annoying to see. Plus, the Configuration of Hosts page does not display the page that allows you enter the name of the host, specify its group and configure the agent interfaces. I am not sure what has happened.
This error occurred when I attempted to add a Zabbix proxy server as host manually while it was being discovered by Zabbix. I didn't know that Zabbix would find the host as it had been unsuccessful in the past. Yet, when it was discovered it added the host without a string for the name field in the hosts table in the database. Anyways, when I attempt to delete the hosts I get the message below.
Error in query [DELETE FROM hosts WHERE hostid='10641'] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`drules`, CONSTRAINT `c_drules_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`))]
SQL statement execution has failed "DELETE FROM hosts WHERE hostid='10641'"
SQL statement execution has failed "DELETE FROM hosts WHERE hostid='10641'"
Comment