-
Incident report
-
Resolution: Commercial support required
-
Trivial
-
None
-
7.0.18
Steps to reproduce:
- Delete a host and trigger some constraint:
pg_query(): Query failed: ERROR: update or delete on table "triggers" violates foreign key constraint "c_trigger_discovery_2" on table "trigger_discovery" DETAIL: Key (triggerid)=(795300) is still referenced from table "trigger_discovery". [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 (795300,795301,795302,795303,795304,795305,795306,795307,795308,805745)] [ERROR: update or delete on table "triggers" violates foreign key constraint "c_trigger_discovery_2" on table "trigger_discovery" DETAIL: Key (triggerid)=(795300) is still referenced from table "trigger_discovery".] A execução do comando SQL falhou "DELETE FROM triggers WHERE triggerid IN (795300,795301,795302,795303,795304,795305,795306,795307,795308,805745)"
Result:
See screenshot
Expected:
Host deleted