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

[Federico Alberto Sayd]

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 
has been migrated??

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 <fsayd at uncu.edu.ar> wrote:
>> Hello People:
>>
>> I am trying to 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 host. Please help and
>
> Thanks!
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>