Re: [ovirt-users] Unable to remove host (SQL error)

From: jdeloro(a)web.de To: users(a)ovirt.org Sent: Sunday, April 26, 2015 10:36:59 PM Subject: [ovirt-users] Unable to remove host (SQL error) Hello, I'm unable to remove a re-installed host from oVirt 3.5 cluster. The engine.log states: 2015-04-26 21:19:27,795 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-8-thread-43) [34db91ae] Command org.ovirt.engine.core.bll.RemoveVdsCommand throw 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)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = $1 " PL/pgSQL function "deletevdsstatic" 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)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still referenced from table "vm_dynamic". Where: SQL statement "DELETE FROM vds_static WHERE vds_id = $1 " PL/pgSQL function "deletevdsstatic" line 11 at SQL statement at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE] [...] The host re-installed (Kickstart) before.

What can I do to remove the host (via Webinterface) or database interaction?

select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c');

Kind regards Jannick _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users