[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-09 Thread 3c . monitor
Hi, change that state was unuseful... Cannot remove Template. The following Disk(s) are based on it: (0ae7f8f0-9dff-4649-8009-34191349dcc9) . Of course, in disk list there isn't... Thanks a lot. ___ Users mailing list -- users@ovirt.org To unsubscribe

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi, ok, I found it, with: SELECT * from images where imagestatus = 2; Now simply update it = 1 ? And then template became removable? Or other steps needed? Thanks a lot. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread Benny Zlotnik
It should be in the images table, there is an it_guid column which indicates which templates the image is based on On Wed, Dec 2, 2020 at 2:16 PM <3c.moni...@gruppofilippetti.it> wrote: > Hi, > if I can ask some other info, probably I find a "ghost disk" related to > previous problem. > >

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi, if I can ask some other info, probably I find a "ghost disk" related to previous problem. Infact, I still cannot remove the broken template, because its disk is still registered somewhere; can You please suggest me where to search for it? Thanks a lot.

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi. thanks a lot! a simply: update vm_dynamic SET status = '0' where vm_guid = 'a54f4a3d-e7b3-4fc6-9910-fc5b415b99bf' ; has finally changed the VM in a "removable" state. Just deleted it! Thanks again. M. ___ Users mailing list -- users@ovirt.org To

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread Benny Zlotnik
These are the available statuses[1], you can change it to 0, assuming the VM is down [1] https://github.com/oVirt/ovirt-engine/blob/master/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VMStatus.java#L10 On Wed, Dec 2, 2020 at 12:57 PM

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi. It's correct. But how unlock / change / remove it? In the same table, a lot of fields are empty, "0" or NULL. Only vm_guid and status have a value. Thanks, M. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread Benny Zlotnik
I am not sure what is locked? If everything in the images table is 1, then the disks are not locked. If the VM is in status 15, which is "Images Locked" status, then this status is set in the vm_dynamic table On Wed, Dec 2, 2020 at 12:43 PM <3c.moni...@gruppofilippetti.it> wrote: > Hi, > in this

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi, in this table all imagestatus = 1 Any other ideas? Thanks a lot, M. ___ 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:

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread Benny Zlotnik
imagestatus is in the images table, not vms On Wed, Dec 2, 2020 at 11:30 AM <3c.moni...@gruppofilippetti.it> wrote: > Hi. > I did a full select on "vms" and field "imagestatus" there isn't! > May be this the reason for which the tool is unable to manage it? > Follows full field list: > > >

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-12-02 Thread 3c . monitor
Hi. I did a full select on "vms" and field "imagestatus" there isn't! May be this the reason for which the tool is unable to manage it? Follows full field list:

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-26 Thread 3c . monitor
Hi. Now select suggested works (thanks), but still no results: # su - postgres -c 'scl enable rh-postgresql10 -- psql' psql (10.6) Type "help" for help. postgres=# \c engine You are now connected to database "engine" as user "postgres". engine=# SELECT vm_name from vms where vm_guid = (SELECT

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-25 Thread Alex K
On Wed, Nov 25, 2020 at 8:05 PM <3c.moni...@gruppofilippetti.it> wrote: > Hi, > it seems not work... > > bash-4.2$ psql > psql (10.6) > Type "help" for help. > > postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM > vm_images_view where imagestatus = 2); > ERROR: relation

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-25 Thread 3c . monitor
Hi, it seems not work... bash-4.2$ psql psql (10.6) Type "help" for help. postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); ERROR: relation "vms" does not exist LINE 1: SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM...

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-25 Thread Alex K
On Tue, Nov 17, 2020, 18:42 <3c.moni...@gruppofilippetti.it> wrote: > Hi. > taskcleaner and unlock_entity are just 2 items of reported rhel solution > I've used , but didn't worked. > Locked Image still there! > I would try also to unlock it at db. Some steps from version 3.x. should be same for

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-24 Thread 3c Monitor
Hi, anyone with an idea on what else I can do? Thanks a lot. ___ 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:

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-17 Thread 3c . monitor
Hi. taskcleaner and unlock_entity are just 2 items of reported rhel solution I've used , but didn't worked. Locked Image still there! Thanks. M. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy

[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

2020-11-17 Thread Alex K
On Tue, Nov 17, 2020, 16:12 <3c.moni...@gruppofilippetti.it> wrote: > Hi all. > I've deployed a VM from a corrupted template (it's disk is missing, but > I've checked it later...). > My Software Version is:4.3 > Now, I have an unmanaged VM in inventory and unable to remove it too. > It's