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

[Arik Hadas]

----- Original Message -----
> 
> 
> El Domingo, 6 de Julio de 2014 07.06 CLT, Arik Hadas <ahadas at redhat.com> Ha
> escrito:
> 
> 
> 
> 
> ----- 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
> &g t; 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 wrote:
> > >> Hello People:
> > >> 
> > >> I am trying t o 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 h ost. Please help and
> > > 
> > > Thanks!
> > > _______________________________________________
> > > Users mailing list
> > > Users at ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/user
> Indeed, you are right, is the same bug. I didn't find this bug when googled
> the problem. I have attached an extract of the logs when I tried to remove
> the host, it looks identical to the logs reported in the bug except that
> postgres transactions are logged in Spanish.

Thanks

> I will try to find the log entry when the vm was migrated and the value was
> not correctly updated in the "migrating_to_vds" field. I think that that is
> the more critical bug.

I was able to reproduce it on 3.4 branch and to understand the problem.
On master it was fixed by: http://gerrit.ovirt.org/#/c/24799/
I'll backport this patch and it will solve it on 3.4 as well.

> 
> Thank you
> 
> Federico
>