Re: [ovirt-users] Orphaned record in the engine DB prevents host removal
Hi Federico,
If we are to debug this issue engine.log should be helpful, as Oved suggested.
Please attach it if you still have it.
Vered
----- Original Message -----
From: "Federico Alberto Sayd" <fsayd(a)uncu.edu.ar>
To: "Oved Ourfali" <oourfali(a)redhat.com>
Cc: "Arik Hadas" <ahadas(a)redhat.com>, "users"
<users(a)ovirt.org>, "Michal Skrivanek" <mskrivan(a)redhat.com>
Sent: Friday, July 4, 2014 11:56:18 PM
Subject: Re: [ovirt-users] Orphaned record in the engine DB prevents host removal
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(a)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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users