-
Type:
Problem report
-
Resolution: Won't fix
-
Priority:
Trivial
-
None
-
Affects Version/s: 7.4.0beta1
-
Component/s: None
{}Steps to reproduce:{}
1) Create and save Host with Zabbix agent interface.
2) Open zabbix in one more tab.
3) In tab_1 - open created host in edit form.
4) In tab_2 navigate to created hosts Discovery rule page.
5) Create discovery rule that use Host interface.
6) In tab_2 - press Create discovery rule.
7) In tab_1 (where Hosts open in edit form) remove added interface and press Update.
Result:
Error message. Too informative.
pg_query(): Query failed: ERROR: update or delete on table "interface" violates foreign key constraint "c_items_4" on table "items"
DETAIL: Key (interfaceid)=(33) is still referenced from table "items". [zabbix.php:17 -> require_once() -> ZBase->run() -> ZBase->processRequest() -> CController->run() -> CControllerHostUpdate->doAction() -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CHost->update() -> CHost->updateForce() -> CHost->massUpdate() -> CHostInterface->replaceHostInterfaces() -> CHostInterface->delete() -> DB::delete() -> DBexecute() -> pg_query() -> CConfigFile->{closure}() in include/db.inc.php:255]
Expected:
Another type of error without sql
