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

27 Apr 2015


      ----- Original Message -----
...
From: "Eli Mesika" <emesika@redhat.com>
To: jdeloro@web.de
Cc: users@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@web.de
To: users@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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users