I can't delete host in Zabbix

[Thaynara Soares Campos]

I was trying to delete a host in Zabbix, but I'm getting this error:

My Zabbix version: 7.0.18

Error:

pg_query(): Query failed: ERROR: update or delete in table "triggers" violates foreign key constraint "c_trigger_discovery_2" in "trigger_discovery"
DETAIL: Key (triggerid)=(61650) is still referenced by the "trigger_discovery" table. [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostMassDelete->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CHost::deleteForce() → CDiscoveryRule::deleteForce() → CDiscoveryRule::deleteAffectedItemPrototypes() → CItemPrototype::deleteForce() → CItemGeneral::deleteAffectedTriggers() → CTriggerPrototypeManager::delete() → DB::delete() → DB::deleteByPkIds() → DB::deleteByIdField() → DBexecute() → pg_query() in include/db.inc.php:368] Error in query [DELETE FROM triggers WHERE triggerid IN (61648,61649,61650,61651,61652,61653,61654,61655,6 2501)] [ERROR: Update or delete on table "triggers" violates foreign key constraint "c_trigger_discovery_2" in "trigger_discovery" DETAIL: Key (triggerid)=(61650) is still referenced by [Table "trigger_discovery".] The execution of the SQL command "DELETE FROM triggers WHERE triggerid IN (61648,61649,61650,61651,61652,61653,61654,61655,6 2501)" failed.

[mosconi.trt1]

I have the same problem

I opened a ticket about the issue:

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

[mosconi.trt1]

Resolved applying this constraint:

ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_1 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE;

But before applying, need to remove all rows that violated that constraint

[Thaynara Soares Campos]

I will test it, thanks for the help