<br /><br />El Domingo, 6 de Julio de 2014 07.06 CLT, Arik Hadas <ahadas@redhat.com> Ha escrito:<br /> <blockquote><br /><br />----- Original Message -----<br />> On 04/07/14 14:45, Oved Ourfali wrote:<br />> > Is there a migration of this VM in progress? Did it migrate recently?<br />> Thank you Oved, I have already solved the problem, I have posted the<br />> solution to the list.<br />><br />> However I don't understand how the data is recorded in the table<br />> "vm_dyanmic".<br />><br />> I guess that in this table the engine records the current status data of<br />> the vm's in the datacenter. In my engine DB almost all the registries in<br />> the "vm_dynamic" table have a vm id in the "migrating_to_vds" field,<br />> this id is the same in the "run_on_vds" field.<br />><br />> Is it right that the "migrating_to_vds" field have a value after the vm<br />&g
t; has been migrated??<br /><br />Yes, we're about to fix it.<br /><br />Note that there is an open bug for this issue:<br />https://bugzilla.redhat.com/show_bug.cgi?id=1112359<br />If you will be able to provide the info I've asked for there,<br />it could help us to solve it faster :)<br /><br />Arik<br /><br />><br />> My setup:<br />><br />> oVirt Engine Version: 3.4.0-1.el6<br />> Nodes (vds's, hosts, etc.): Centos 6.5 ovirt-node 3.4, vdsm-4.14.6-0.el6<br />><br />> Thank you, and happy weekend!<br />><br />> Federico<br />> > I suggest to attach the engine log here as well, if possible, for<br />> > examination. Cc-ing some guys that might help but bare in mind that for<br />> > some of them it is already weekend.<br />> ><br />> > Oved<br />> ><br />> > On Jul 4, 2014 6:07 PM, Federico Alberto Sayd wrote:<br />> >> Hello People:<br />> >><br />> >> I am trying t
o remove a host from ovirt-engine but I have fouHello People:<br />> > I am trying to remove a host from ovirt-engine but I have found that a<br />> > orphaned record in the engine DB prevents the removal of the host.<br />> > The host is in maintenance mode, it doesn't have vm's running on it.<br />> > The engine logs says that there is a reference to the id of the host<br />> > (vds_id in the table vds_static) in the field "migrating_to_vds" in the<br />> > table "dynamic_vds". Obviously this is a orphaned record, but a<br />> > constraint in the table "dynamic_vds" prevents the removal of the host.<br />> > How can I solve this?<br />> > Someone that knows the internals of engine's DB that can confirm if I<br />> > can remove the problematic registry in order to remove the host??<br />> > Another solution?<br />> ><br />> > I really need to remove this h
ost. Please help and<br />> ><br />> > Thanks!<br />> > _______________________________________________<br />> > Users mailing list<br />> > Users@ovirt.org<br />> > http://lists.ovirt.org/mailman/listinfo/user</blockquote><br />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.<br />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.<br /><br />Thank you<br /><br />Federico<br />