El Domingo, 6 de Julio de 2014 07.06 CLT, Arik Hadas <ahadas(a)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(a)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.
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: