[ovirt-users] Unable to remove host (SQL error)
Eli Mesika
emesika at redhat.com
Mon Apr 27 07:29:25 UTC 2015
----- Original Message -----
> From: "Eli Mesika" <emesika at redhat.com>
> To: jdeloro at web.de
> Cc: users at 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 at web.de
> > To: users at 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');
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
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
More information about the Users
mailing list