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

[Vered Volansky]

Hi Federico,

If we are to debug this issue engine.log should be helpful, as Oved suggested.
Please attach it if you still have it.

Vered

----- Original Message -----
> From: "Federico Alberto Sayd" <fsayd at uncu.edu.ar>
> To: "Oved Ourfali" <oourfali at redhat.com>
> Cc: "Arik Hadas" <ahadas at redhat.com>, "users" <users at ovirt.org>, "Michal Skrivanek" <mskrivan at redhat.com>
> Sent: Friday, July 4, 2014 11:56:18 PM
> Subject: Re: [ovirt-users] Orphaned record in the engine DB prevents host removal
> 
> 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??
> 
> 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
> >
> >
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>