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

[Eli Mesika]

----- 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');


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