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

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

Thank you Federico