----- Original Message ----- > > > El Domingo, 6 de Julio de 2014 07.06 CLT, Arik Hadas <aha...@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@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 > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users