Dear oVirt Users, using the most recent (stable) hosted engine release (4.0.4) we are unable to remove an oVirt node using the GUI:
Engine.log says: ----- 2016-10-25 17:14:59,300 INFO [org.ovirt.engine.core.bll.RemoveVdsCommand] (default task-10) [4bde1aa7] Lock Acquired to object 'EngineLock:{exclusiveLocks='[1014c79a-5565-430d-8076-778893948f0f=<VDS, ACTION_TYPE_FAILED_OBJECT_LOCKED>]', sharedLocks='null'}' 2016-10-25 17:14:59,324 INFO [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-8-thread-36) [4bde1aa7] Running command: RemoveVdsCommand internal: false. Entities affected : ID: 1014c79a-5565-430d-8076-778893948f0f Type: VDSAction group DELETE_HOST with role type ADMIN 2016-10-25 17:14:59,369 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (org.ovirt.thread.pool-8-thread-36) [4bde1aa7] transaction rolled back 2016-10-25 17:14:59,370 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-8-thread-36) [4bde1aa7] 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" Detail: Key (vds_id)=(1014c79a-5565-430d-8076-778893948f0f) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = v_vds_id" PL/pgSQL function deletevdsstatic(uuid) line 11 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "vds_static" violates foreign key constraint "vds_static_vm_dynamic_m" on table "vm_dynamic" Detail: Key (vds_id)=(1014c79a-5565-430d-8076-778893948f0f) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = v_vds_id" PL/pgSQL function deletevdsstatic(uuid) line 11 at SQL statement 2016-10-25 17:14:59,370 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-8-thread-36) [4bde1aa7] 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" Detail: Key (vds_id)=(1014c79a-5565-430d-8076-778893948f0f) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = v_vds_id" PL/pgSQL function deletevdsstatic(uuid) line 11 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "vds_static" violates foreign key constraint "vds_static_vm_dynamic_m" on table "vm_dynamic" Detail: Key (vds_id)=(1014c79a-5565-430d-8076-778893948f0f) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = v_vds_id" PL/pgSQL function deletevdsstatic(uuid) line 11 at SQL statement at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) [spring-jdbc.jar:4.2.4.RELEASE] ---- The RPMs installed are: ovirt-engine-jboss-as-7.1.1-1.el7.centos.x86_64 ovirt-vmconsole-proxy-1.0.4-1.el7.centos.noarch ovirt-engine-lib-4.0.4.4-1.el7.centos.noarch ovirt-engine-setup-plugin-ovirt-engine-4.0.4.4-1.el7.centos.noarch ovirt-engine-extension-aaa-jdbc-1.1.0-1.el7.noarch ovirt-host-deploy-java-1.5.2-1.el7.centos.noarch ovirt-engine-wildfly-overlay-10.0.0-1.el7.noarch ovirt-engine-wildfly-10.0.0-1.el7.x86_64 ovirt-iso-uploader-4.0.1-1.el7.centos.noarch ovirt-engine-webadmin-portal-4.0.4.4-1.el7.centos.noarch ovirt-engine-restapi-4.0.4.4-1.el7.centos.noarch ovirt-guest-agent-common-1.0.12-3.el7.noarch ovirt-vmconsole-1.0.4-1.el7.centos.noarch ovirt-engine-dwh-4.0.2-1.el7.centos.noarch ovirt-release36-3.6.6-1.noarch ovirt-engine-dashboard-1.0.3-1.el7.centos.noarch ovirt-engine-tools-4.0.4.4-1.el7.centos.noarch ovirt-engine-backend-4.0.4.4-1.el7.centos.noarch ovirt-engine-4.0.4.4-1.el7.centos.noarch ovirt-setup-lib-1.0.2-1.el7.centos.noarch ovirt-engine-setup-base-4.0.4.4-1.el7.centos.noarch ovirt-engine-setup-plugin-vmconsole-proxy-helper-4.0.4.4-1.el7.centos.noarch ovirt-engine-setup-4.0.4.4-1.el7.centos.noarch ovirt-imageio-common-0.4.0-1.el7.noarch ovirt-imageio-proxy-setup-0.4.0-0.201608310602.gita9b573b.el7.centos.noarch ovirt-image-uploader-4.0.1-1.el7.centos.noarch ovirt-engine-sdk-python-3.6.9.1-1.el7.centos.noarch ovirt-engine-extensions-api-impl-4.0.4.4-1.el7.centos.noarch ovirt-release40-4.0.4-1.noarch ovirt-engine-dwh-setup-4.0.2-1.el7.centos.noarch ovirt-engine-cli-3.6.8.1-1.el7.centos.noarch ovirt-engine-setup-plugin-ovirt-engine-common-4.0.4.4-1.el7.centos.noarch ovirt-engine-setup-plugin-websocket-proxy-4.0.4.4-1.el7.centos.noarch python-ovirt-engine-sdk4-4.0.1-1.el7.centos.x86_64 ovirt-host-deploy-1.5.2-1.el7.centos.noarch ovirt-imageio-proxy-0.4.0-0.201608310602.gita9b573b.el7.centos.noarch ovirt-engine-websocket-proxy-4.0.4.4-1.el7.centos.noarch ovirt-engine-vmconsole-proxy-helper-4.0.4.4-1.el7.centos.noarch ovirt-engine-tools-backup-4.0.4.4-1.el7.centos.noarch ovirt-engine-userportal-4.0.4.4-1.el7.centos.noarch ovirt-engine-dbscripts-4.0.4.4-1.el7.centos.noarch ovirt-guest-tools-iso-4.0-1.fc23.noarch Thanks for help! Best regards, Thomas _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users