[ZBX-7224] Update host prototype failed Created: 2013 Oct 27 Updated: 2017 May 30 Resolved: 2013 Oct 30 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 2.1.8 |
| Fix Version/s: | 2.1.9 |
| Type: | Incident report | Priority: | Major |
| Reporter: | Joe | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | vmware | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Ubuntu 12.10/Mysql |
||
| Description |
|
Attempted to remove group prototype ' {#CLUSTER.NAME}(vm)' from Template Virt VMware and received the following error: Error in query [DELETE FROM group_prototype WHERE group_prototypeid='6'] [Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`group_discovery`, CONSTRAINT `c_group_discovery_2` FOREIGN KEY (`parent_group_prototypeid`) REFERENCES `group_prototype` (`group_prototypeid`))] This is a fresh install of 2.1.8 with a fresh database. |
| Comments |
| Comment by Alexander Vladishev [ 2013 Oct 30 ] |
|
PostgreSQL errors: 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)=(9) is still referenced from table "group_discovery". [host_prototypes.php:186 → CAPIObject->update() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CHostPrototype->update() → CHostPrototype->updateReal() → CHostPrototype->deleteGroupPrototypes() → DB::delete() → DBexecute() → pg_query() in /home/sasha/zabbix-svn/branches/dev/ZBX-7224/frontends/php/include/db.inc.php:547] Error in query [DELETE FROM group_prototype WHERE group_prototypeid='6'] [ERROR: update or delete on table "group_prototype" violates foreign key constraint "c_group_discovery_2" on table "group_discovery" DETAIL: Key (group_prototypeid)=(9) is still referenced from table "group_discovery".] SQL statement execution has failed "DELETE FROM group_prototype WHERE group_prototypeid='6'" |
| Comment by Alexander Vladishev [ 2013 Oct 30 ] |
|
I confirm the issue. |
| Comment by Eduards Samersovs (Inactive) [ 2013 Oct 30 ] |
|
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-7224 |
| Comment by Pavels Jelisejevs (Inactive) [ 2013 Oct 30 ] |
|
TESTED. |
| Comment by Eduards Samersovs (Inactive) [ 2013 Oct 31 ] |
|
Fixed in versions pre-2.1.9 (trunk) r.39672 |