How to delete 16000 discovered items?

[smcgraw]

Problem: I installed a third-party template and linked it to a host. The template's discovery rules added about 16000 items to the host. When I try to "clear and unlink" the template from the host, the web page becomes gray (except the header) and nothing happens. Going back to the host page again show the template still linked and the items still there. Trying to delete the template on the Template page produces similar results.

I found a few references to this, for example:

https://support.zabbix.com/browse/ZBX-10420

but no answers of how to resolve it.

I don't want to lose the host which has history I want to keep, just lose the items and their data (and other stuff added by the template: graphs, triggers, etc).

Can I go directly into the zabbix database and just blow away the relevant rows in the "items" table? I see some foreign keys with cascading deletes but I don't know if they are complete. Is there a recipe for this? What to do?!?

I am using Zabbix-3.4.11 with Postgresql-10 on Ubuntu-18.04.

Thanks.

[DmitryL]

Hello,

Set "Keep lost resources" to 0 in LLD rule and add some filtering on LLD macro that will never be true.
After the next LLD cycle, those items will be gone.

[smcgraw]

Thank you!!!