-
Incident report
-
Resolution: Incomplete
-
Trivial
-
None
-
6.0.1
-
None
-
None
Hi,
- I update from 5.4 to 6.0
- I imported the current vmware template.
I got this error (the only template with this error):
* pg_query(): Query failed: ERROR: update or delete on table "group_prototype" violates foreign key constraint "c_group_discovery_2" on table "group_discovery"
* DETAIL: Key (group_prototypeid)=(215) is still referenced from table "group_discovery". [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerPopupImport->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CConfiguration->import() → CConfigurationImport->import() → CConfigurationImport->processDiscoveryRules() → CHostPrototype->update() → CHostPrototype->updateForce() → CHostPrototype::updateGroupPrototypes() → DB::delete() → DBexecute() → pg_query() in include/db.inc.php:349]
* Error in query [DELETE FROM group_prototype WHERE (group_prototypeid IN ('209','211'))] [ERROR: update or delete on table "group_prototype" violates foreign key constraint "c_group_discovery_2" on table "group_discovery"
* DETAIL: Key (group_prototypeid)=(215) is still referenced from table "group_discovery".]
* SQL statement execution has failed "DELETE FROM group_prototype WHERE (group_prototypeid IN ('209','211'))"
Kind regards
Tuor