----- Original Message ----- > From: "Eli Mesika" <[email protected]> > To: [email protected] > Cc: [email protected] > Sent: Monday, April 27, 2015 10:26:51 AM > Subject: Re: [ovirt-users] Unable to remove host (SQL error) > > > > ----- Original Message ----- > > From: [email protected] > > To: [email protected] > > 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');
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 ??? > > > > > > Kind regards > > > > Jannick > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.ovirt.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
