Created attachment 825729 [details] engine.log Description of problem: Force removal of DataCenter fails to remove a vm_pool that was created on this DC from the vm_pool table in DB. After I force removed the DC, all the vms from that pool were deleted and the vm_pool was delted from the webadmin manue. I then tried to remove the cluster which was related to the deleted DC and that failed. looking at engine.log I saw the following ERROR: 2013-11-18 17:02:16,368 ERROR [org.ovirt.engine.core.bll.RemoveVdsGroupCommand] (pool-5-thread-50) [56101ce] Command org.ovirt.eng ine.core.bll.RemoveVdsGroupCommand throw exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCall back; SQL [{call deletevdsgroup(?)}]; ERROR: update or delete on table "vds_groups" violates foreign key constraint "fk_vds_groups _vm_pools" on table "vm_pools" Detail: Key (vds_group_id)=(feace1c4-bae7-412a-9684-24d20813fedc) is still referenced from table "vm_pools". Where: SQL statement "DELETE FROM vds_groups WHERE vds_group_id = $1 " PL/pgSQL function "deletevdsgroup" line 7 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: update o r delete on table "vds_groups" violates foreign key constraint "fk_vds_groups_vm_pools" on table "vm_pools" Detail: Key (vds_group_id)=(feace1c4-bae7-412a-9684-24d20813fedc) is still referenced from table "vm_pools". Where: SQL statement "DELETE FROM vds_groups WHERE vds_group_id = $1 " PL/pgSQL function "deletevdsgroup" line 7 at SQL statement...... I then saw the pool I once created was still existing in vm_pool table in DB. After manually deleting it, cluster removal worked just fine. Version-Release number of selected component (if applicable): RHEVM 3.3 IS23 Steps to Reproduce: 1.create DC-cluster-host-vmpool 2.create more dc's and cluster and detach the first one from any hosts. 3.force remove first Dc 4. remove cluster Actual results: 1. upon removal of DC vm's from pool and pool itself do not appear in webadmin. 2. vm pool isn't deleted from DB 3. remove cluster fails Expected results: 1. upon removal of DC vm's from pool and pool itself do not appear in webadmin. 2. vm pool is deleted from DB 3. remove cluster succeds
all patches merged
This bug is referenced in ovirt-engine-3.4.0-beta3 logs. Moving to ON_QA
Verified with ovirt-engine-3.4.0-0.11.beta3.el6.noarch. reproduced according to the steps mentioned on bz description: 1) created DC-cluster-host 2)created vm - template - vm pool 3) created a new DC-cluster 4) attached the host to the new DC-Cluster 5) Force removed original DC 6) Verified that the vm pool was deleted from DB 7) removed the original cluster - worked with no failure
Closing as part of 3.4.0