[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

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

2020-10-21 Thread Shani Leviim
Hi Massimo, You can find the VM's snapshot id by sending a REST API request http://localhost:8080/ovirt-engine/api/vms//snapshots/ You can also find the VM's snapshots (and view their parameters) by using SQL: select * from snapshots where vm_id = ''; Once you have the snapshot's id, you can use

[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:

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

2020-10-21 Thread Shani Leviim
Hi Massimo, This snapshot should be removed from the DB, as it seems that the vdsm-dump has 1 image related to the 'a0f9a434-7837-4ec6-8017-c9698ed5cd01' image , while the engine reports on 2 images (64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 and 776e817f-2112-4d42-8380-4160caf5059f) In order to

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

2020-10-20 Thread Massimo Mad
[image: Ovirt Illegal.png] Il giorno mar 20 ott 2020 alle ore 09:44 Shani Leviim ha scritto: > Hi, > I think we should treat each problem separately: > Can you run that SQL query on your engine and see the output? > SELECT * > FROM images_storage_domain_view images_storage_domain_view >

[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 |

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

2020-10-20 Thread Shani Leviim
Hi, I think we should treat each problem separately: Can you run that SQL query on your engine and see the output? SELECT * FROM images_storage_domain_view images_storage_domain_view WHERE image_group_id = '55893adf-1e56-4346-8070-4b3e660dd44d'; and same for

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

2020-10-19 Thread Massimo Mad
Hi, It's very strange because in the engine UI i have only one disk in illegal status. But i have a problem with another VM that have all the disk OK the storage migration begins, takes the snap shot then fails and the snapshot is deleted. the size of the vm with the disk in illega is 200Gb the id

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

2020-10-19 Thread Shani Leviim
Hi Massimo, As shown on the output, you currently have 2 illeagal images: image:55893adf-1e56-4346-8070-4b3e660dd44d - ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: *ILLEGAL*, type: SPARSE, capacity: 107374182400,

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

2020-10-19 Thread Massimo Mad
Hi Shani I run the command on the host owner of the SPM it's correct ? This is the output: [root@ovirthpr01 ~]# vdsm-tool dump-volume-chains eb483eb3-a9ce-4867-9ce8-96a0ca171042 Images volume chains (base volume first) image:ff44dc13-de50-4891-84ce-9fb3e3fe1c88 -

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

2020-10-19 Thread Shani Leviim
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains It's also recommended to verify that the engine and vdsm are synced about that image, once you've find it, by running this command on the engine: SELECT * FROM