Host cannot be deleted from frontend - Low Level Discovery Problem

[vintagegamingsystems]

I have a host that I accidentally configured Low Level Discovery incorrectly. Now I cannot delete the host. My LLD rule created 1610 triggers. I believe that that is the problem. How else can you delete the host? When I click to delete the host, the next screen only displays the main Zabbix Web Page header and the history link below it. Below the link is just the normal Zabbix background color with no data. I would really like to rewrite my discovery rule but now I can't because I cannot modify the host at all. Any help would be appreciated.

[Pada]

Hi, could you please tell us what version of Zabbix you're using?

[vintagegamingsystems]

Zabbix 2.0

I am running Zabbix 2.0. The frontend version is 2.0.5. I will get more information about the problem once I arrive at work. I may have to delete the host via the API.

[vintagegamingsystems]

API will not work as well

I tried to delete the host via the API and it will not work as well. I am not sure what to do. Any help is appreciated. This appears to be a rather large problem.

The zabbix_server binary is version 2.0.8.
The zabbix_agent binary on the server is 2.0.8.
The frontend version is 2.0.8.

This is not very pleasant.

[Pada]

I can probably help you to manually delete the host by giving you SQL queries, but that should only be the last resort!

Does the Zabbix server or Apache HTTPd server (error) log files show anything?

I just managed to delete my host that had LLD items + triggers + graphs in it, but I'm on v2.1.5.
I have to add that I was unable to delete the triggers, because they were still linked to the discovery template. So perhaps if you unlink (without clearing) the template, you can then perhaps delete the triggers, items, graphs, etc. and the host.

If you can give us as much info as possible, it would really help.
Like what OS (Ubuntu 10.04 LTS), DB (MySQL 5.1) and what LLD template you were using (only interface items + triggers).

[vintagegamingsystems]

Here is how I fixed it.

This seems to work well. It sucks to have to directly go into the database, but oh well.
mysql>delete from triggers where triggerid between <beginning id number> and <ending id number>;

Thanks to all that helped.