[ovirt-users] Re: VM has snapshot with disk in illegal status

2020-10-24 Thread Massimo Coloma
Hi Shani,
Thanks for the help but i am not a DBA or anything, can you please give me 
exactly the command to run on the manager.
Regards
Massimo


___
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/MHM4U4YQU3QWOG3BMVZ4HAU4TCQOKAW6/


[ovirt-users] Re: VM has snapshot with disk in illegal status

2020-10-21 Thread Massimo Coloma
Hi Shani ,
The command it that ?
SELECT DeleteSnapshot 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97
Regards
Max
___
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/HYPKECYTNIMBSMIEOWT2MVPBQT5ON3IE/


[ovirt-users] Re: VM has snapshot with disk in illegal status

2020-10-20 Thread Massimo Coloma
Hi,
I send you the output of the first query:
engine=# SELECT * FROM images_storage_domain_view images_storage_domain_view 
WHERE image_group_id = '55893adf-1e56-4346-8070-4b3e660dd44d';
 image_guid | storage_name | storage_pool_id | storage_type | creation_date | 
size | it_guid | description | parentid |
 lastmodified | app_list | storage_id | vm_snapshot_id | volume_type | 
volume_format | qcow_compat | imagestatus | imag
e_group_id | active | volume_classification | entity_type | vm_names | 
number_of_vms | template_version_names | disk_id
 | disk_alias | disk_description | shareable | wipe_after_delete | 
propagate_errors | sgio | disk_content_type | backup
 | quota_id | quota_name | quota_enforcement_type | disk_profile_id | 
disk_profile_name | actual_size | read_rate | wri
te_rate | read_latency_seconds | write_latency_seconds | flush_latency_seconds 
| disk_storage_type | cinder_volume_type
 | image_transfer_phase | image_transfer_type | image_transfer_bytes_sent | 
image_transfer_bytes_total | progress
+--+-+--+---+--+-+-+--+
--+--+++-+---+-+-+-
---++---+-+--+---++
-++--+---+---+--+--+---+---
-+--+++-+---+-+---+
+--+---+---+---+---
-+--+-+---++--
(0 rows)

The second query:
engine=# SELECT * FROM images_storage_domain_view images_storage_domain_view 
WHERE image_group_id = '825765ba-b132-4b36-8cb9-8ecd2c7b597a';
 image_guid | storage_name | storage_pool_id | storage_type | creation_date | 
size | it_guid | description | parentid |
 lastmodified | app_list | storage_id | vm_snapshot_id | volume_type | 
volume_format | qcow_compat | imagestatus | imag
e_group_id | active | volume_classification | entity_type | vm_names | 
number_of_vms | template_version_names | disk_id
 | disk_alias | disk_description | shareable | wipe_after_delete | 
propagate_errors | sgio | disk_content_type | backup
 | quota_id | quota_name | quota_enforcement_type | disk_profile_id | 
disk_profile_name | actual_size | read_rate | wri
te_rate | read_latency_seconds | write_latency_seconds | flush_latency_seconds 
| disk_storage_type | cinder_volume_type
 | image_transfer_phase | image_transfer_type | image_transfer_bytes_sent | 
image_transfer_bytes_total | progress
+--+-+--+---+--+-+-+--+
--+--+++-+---+-+-+-
---++---+-+--+---++
-++--+---+---+--+--+---+---
-+--+++-+---+-+---+
+--+---+---+---+---
-+--+-+---++--
(0 rows)
The last query:
engine=# SELECT * FROM images_storage_domain_view images_storage_domain_view 
WHERE image_group_id = 'a0f9a434-7837-4ec6-8017-c9698ed5cd01';
  image_guid  | storage_name |   
storage_pool_id| storage_type | creati
on_date  | size |   it_guid|   
description   |   parentid
 |lastmodified| app_list |  storage_id  
|vm_snapshot_id
| volume_type | volume_format | qcow_compat | imagestatus |
image_group_id| active | volume_
classification | entity_type |   vm_names   | number_of_vms | 
template_version_names |   disk_id
 | disk_alias | disk_description | shareable | wipe_after_delete | 
propagate_errors | sgio | disk_content_t
ype | backup |   quota_id   | quota_name | 
quota_enforcement_type |   disk_profile_id
  | disk_profile_name | actual_size  | read_rate | write_rate | 
read_latency_seconds | write_latency_seconds |
flush_latency_seconds | disk_storage_type | cinder_volume_type | 
image_transfer_phase | image_transfer_type | image_tra
nsfer_bytes_sent | image_transfer_bytes_total | progress