Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-27026

Unable to delete host

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • 7.0.18
    • 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

            Unassigned Unassigned
            mosconi.trt1 Rodrigo Mosconi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: