On Thu, Nov 5, 2020 at 12:51 PM Andrei Verovski <[email protected]>
wrote:

> H,
>
> Select query wen succesfull, unfortunately (vm_guid copied from VM
> profile, rest copied from [1]):
>
> engine=# update vm_dynamic set
> run_on_vds='82f92946-9130-4dbd-8663-1ac0b50668a1' where
> vm_guid='d168bbeb-0532-44e4-93da-fdfcd7cc7f20';
>
> ERROR:  insert or update on table "vm_dynamic" violates foreign key
> constraint "vds_static_vm_dynamic_r"
> DETAIL:  Key (run_on_vds)=(82f92946-9130-4dbd-8663-1ac0b50668a1) is not
> present in table "vds_static".
>
> How to properly determine value “ run_on_vds” ? Is this node UUID?
>

Take one of the results of:
select vds_id from vds where status=3;


>
> Thanks.
>
>
> On 3 Nov 2020, at 18:21, Arik Hadas <[email protected]> wrote:
>
>
>
> On Tue, Nov 3, 2020 at 5:36 PM Andrei Verovski <[email protected]>
> wrote:
>
>> Hi,
>>
>> I have oVirt 4.4 engine and v4.2 nodes.
>>
>> On one node newly created VM struck in shutdown mode (with green round
>> recycle icon) - I can’t anything, neither power off neither shutdown, both
>> operation fail (with no explanation). This VM have no value whatsoever, but
>> I can’t delete it either.
>>
>> Restarted oVirt engine, all same.
>>
>> Process list (on node) clearly shows absence of this VM as KVM process.
>> VM is down.
>>
>> How to reset its status in oVirt?
>>
>
> Hi,
>
> Please try the steps described in [1]
>
> [1] https://www.mail-archive.com/[email protected]/msg62928.html
>
>
>>
>> Thanks in advance.
>> Andrei
>> _______________________________________________
>> Users mailing list -- [email protected]
>> To unsubscribe send an email to [email protected]
>> Privacy Statement: https://www.ovirt.org/privacy-policy.html
>> oVirt Code of Conduct:
>> https://www.ovirt.org/community/about/community-guidelines/
>> List Archives:
>> https://lists.ovirt.org/archives/list/[email protected]/message/VVQT4YDC5JKGSVXBXSXXZONUNQBVLXJQ/
>>
>
>
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/[email protected]/message/2LBVXZIXUP4X4G45LI3RY4VUVZFMM77O/

Reply via email to