From: "Eli Mesika" <emesika(a)redhat.com&gt; To: jdeloro(a)web.de Cc: users(a)ovirt.org Sent: Monday, April 27, 2015 10:26:51 AM Subject: Re: [ovirt-users] Unable to remove host (SQL error) ----- Original Message ----- > 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. Hi this should not happen, please open a bug for that and attach the full engine log > > What can I do to remove the host (via Webinterface) or database > interaction? from psql prompt > select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c');

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

From: "Jannick DelOro" <jdeloro(a)web.de&gt; To: "Eli Mesika" <emesika(a)redhat.com&gt; Cc: users(a)ovirt.org Sent: Monday, April 27, 2015 11:14:01 AM Subject: Re: [ovirt-users] Unable to remove host (SQL error) Hello Eli, > > > 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. > > > > Hi > > > > this should not happen, please open a bug for that and attach the full > > engine > > log > > > > > > > > What can I do to remove the host (via Webinterface) or database > > > interaction? > > > > from psql prompt > > > > > select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c'); > > > Looking again in the messages > Seems you still have running VMs on this hots , can you put it first to > maintenance and try the removale again before touching the DB ??? No, the host is in maintenance mode and no VM is running on this host. But here is what has happened before: - VM on host got unresponsive. Was unable to migrate or power off. - Host was restarted and clicked "Confirm "Host has been rebooted"". - Faulty VM was started on different host. - Host was put to maintenance mode. - Host was re-installed via Kickstart. - Trying to remove host from Cluster (due to change in address). Doesn't work. - Host was re-installed via oVirt web interface. - Trying to remove host from Cluster. Doesn't work.

update vm_dynamic set status=0, migrating_to_vds = null where migrating_to_vds = '629ca86d-f6a6-4702-bf0f-182af3df3b8c';

Kind regards Jannick