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?

Thanks.


> On 3 Nov 2020, at 18:21, Arik Hadas <aha...@redhat.com> wrote:
> 
> 
> 
> On Tue, Nov 3, 2020 at 5:36 PM Andrei Verovski <andre...@starlett.lv 
> <mailto:andre...@starlett.lv>> 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/users@ovirt.org/msg62928.html 
> <https://www.mail-archive.com/users@ovirt.org/msg62928.html>
>  
> 
> Thanks in advance.
> Andrei
> _______________________________________________
> Users mailing list -- users@ovirt.org <mailto:users@ovirt.org>
> To unsubscribe send an email to users-le...@ovirt.org 
> <mailto:users-le...@ovirt.org>
> Privacy Statement: https://www.ovirt.org/privacy-policy.html 
> <https://www.ovirt.org/privacy-policy.html>
> oVirt Code of Conduct: 
> https://www.ovirt.org/community/about/community-guidelines/ 
> <https://www.ovirt.org/community/about/community-guidelines/>
> List Archives: 
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/VVQT4YDC5JKGSVXBXSXXZONUNQBVLXJQ/
>  
> <https://lists.ovirt.org/archives/list/users@ovirt.org/message/VVQT4YDC5JKGSVXBXSXXZONUNQBVLXJQ/>

_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
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/users@ovirt.org/message/YVW7B5BACKPYZBTDBMOBB5AIXYXHX27P/

Reply via email to