Unable to delete host

XMLWordPrintable

    • Type: Incident report
    • Resolution: Commercial support required
    • Priority: Trivial
    • None
    • Affects Version/s: 7.0.18
    • Component/s: Frontend (F)

      Steps to reproduce:

      1. 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

            Assignee:
            Unassigned
            Reporter:
            Rodrigo Mosconi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: