[ovirt-users] Orphaned record in the engine DB prevents host removal

[Arik Hadas]

----- Original Message -----
> On 04/07/14 14:45, Oved Ourfali wrote:
> > Is there a migration of this VM in progress? Did it migrate recently?
> Thank you Oved, I have already solved the problem, I have posted the
> solution to the list.
> 
> However I don't understand how the data is recorded in the table
> "vm_dyanmic".
> 
> I guess that in this table the engine records the current status data of
> the vm's in the datacenter. In my engine DB almost all the registries in
> the "vm_dynamic" table have a vm id in the "migrating_to_vds" field,
> this id is the same in the "run_on_vds" field.
> 
> Is it right that the "migrating_to_vds" field have a value after the vm
> has been migrated??

Yes, we're about to fix it.

Note that there is an open bug for this issue:
https://bugzilla.redhat.com/show_bug.cgi?id=1112359
If you will be able to provide the info I've asked for there,
it could help us to solve it faster :)

Arik

> 
> My setup:
> 
> oVirt Engine Version: 3.4.0-1.el6
> Nodes (vds's, hosts, etc.): Centos 6.5 ovirt-node 3.4, vdsm-4.14.6-0.el6
> 
> Thank you, and happy weekend!
> 
> Federico
> > I suggest to attach the engine log here as well, if possible, for
> > examination. Cc-ing some guys that might help but bare in mind that for
> > some of them it is already weekend.
> >
> > Oved
> >
> > On Jul 4, 2014 6:07 PM, Federico Alberto Sayd <fsayd at uncu.edu.ar> wrote:
> >> Hello People:
> >>
> >> I am trying to remove a host from ovirt-engine but I have fouHello People:
> > I am trying to remove a host from ovirt-engine but I have found that a
> > orphaned record in the engine DB prevents the removal of the host.
> > The host is in maintenance mode, it doesn't have vm's running on it.
> > The engine logs says that there is a reference to the id of the host
> > (vds_id in the table vds_static) in the field "migrating_to_vds" in the
> > table "dynamic_vds". Obviously this is a orphaned record, but a
> > constraint in the table "dynamic_vds" prevents the removal of the host.
> > How can I solve this?
> > Someone that knows the internals of engine's DB that can confirm if I
> > can remove the problematic registry in order to remove the host??
> > Another solution?
> >
> > I really need to remove this host. Please help and
> >
> > Thanks!
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
> >
> 
>