[ovirt-users] Foreign key constraint violation on oVirt Node removal

[Thomas Klute]

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