Removing hypervisor from RHEVM fails with error "could not remove host. related operation is currently in progress"
Issue
*Removing a hypervisor from RHEVM fails with the below error events message in engine.log
2018-03-02 12:32:35,406+01 INFO [org.ovirt.engine.core.bll.RemoveVdsCommand] (default task-53) [d907fbe3-a827-413f-83cb-e3d8df764403] Lock Acquired to object 'EngineLock:{exclusiveLocks='[80ad2344-ff07-489b-93fd-ba7d02f52475=VDS]', sharedLocks=''}'
2018-03-02 12:32:35,553+01 INFO [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] Running command: RemoveVdsCommand internal: false. Entities affected : ID: 80ad2344-ff07-489b-93fd-ba7d02f52475 Type: VDSAction group DELETE_HOST with role type ADMIN
2018-03-02 12:32:36,364+01 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] transaction rolled back
2018-03-02 12:32:36,364+01 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] Command 'org.ovirt.engine.core.bll.RemoveVdsCommand' failed: CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR: update or delete on table "vds_static" violates foreign key constraint "vds_static_vm_dynamic_m" on table "vm_dynamic"
2018-03-02 12:32:36,365+01 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] Exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR: update or delete on table "vds_static" violates foreign key constraint "vds_static_vm_dynamic_m" on table "vm_dynamic"
2018-03-02 12:32:36,404+01 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] EVENT_ID: USER_FAILED_REMOVE_VDS(106), Correlation ID: d907fbe3-a827-413f-83cb-e3d8df764403, Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Failed to remove Host host1.example.com (User: admin@internal.com).
2018-03-02 12:32:36,407+01 INFO [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-7-thread-6) [d907fbe3-a827-413f-83cb-e3d8df764403] Lock freed to object 'EngineLock:{exclusiveLocks='[80ad2344-ff07-489b-93fd-ba7d02f52475=VDS]', sharedLocks=''}'
Environment
- Red Hat Enterprise Virtualization Manager 3.x
- Red Hat Virtualization 4.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.