Foreign key constraint violation on oVirt Node removal

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
participants (1)
-
Thomas Klute