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

[Jannick DelOro]

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.

Kind regards

Jannick