[ovirt-users] Re: VM Struck in Shutdown Mode

[Arik Hadas]

On Thu, Nov 5, 2020 at 12:51 PM Andrei Verovski 
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  wrote:
>
>
>
> On Tue, Nov 3, 2020 at 5:36 PM Andrei Verovski 
> 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
>
>
>>
>> Thanks in advance.
>> Andrei
>> ___
>> 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/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/2LBVXZIXUP4X4G45LI3RY4VUVZFMM77O/

[ovirt-users] Re: VM Struck in Shutdown Mode

[Andrei Verovski]

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  wrote:
> 
> 
> 
> On Tue, Nov 3, 2020 at 5:36 PM Andrei Verovski  > 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 
> 
>  
> 
> Thanks in advance.
> Andrei
> ___
> 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/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/

[ovirt-users] Re: VM Struck in Shutdown Mode

[Arik Hadas]

On Tue, Nov 3, 2020 at 5:36 PM Andrei Verovski  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


>
> Thanks in advance.
> Andrei
> ___
> 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/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/S2DN2BIMWARAGJO6UPFI3ZSKX32S5JAB/