VM has snapshot with disk in illegal status
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id> 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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>; Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB) *Regards,* *Shani Leviim* On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
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 - c45ee9cd-17e3-4cec-b7fb-74af27e792a8 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728 image: a0f9a434-7837-4ec6-8017-c9698ed5cd01 - 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800 image: 4da04f46-2fea-436f-9648-772c24a849c3 - 77ddb7b8-b10f-4d7e-82df-36e077a9eb25 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728 image: 55893adf-1e56-4346-8070-4b3e660dd44d - ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 107374182400, truesize: 1744830464 image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a - 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 85899345920, truesize: 1879048192 image: 0264f52e-fa59-4523-81e4-47564193665e - dfb3d366-f2d3-49ee-8ca3-3b44e24a0111 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 536870912000, truesize: 536870912000 And after what is the next step? Regards Massimo Il giorno lun 19 ott 2020 alle ore 13:51 Shani Leviim <sleviim@redhat.com> ha scritto:
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id>
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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>;
Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB)
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
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, truesize: 1744830464 image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a - 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: *ILLEGAL*, type: SPARSE, capacity: 85899345920, truesize: 1879048192 Can you try removing them from the engine UI? *Regards,* *Shani Leviim* On Mon, Oct 19, 2020 at 4:36 PM Massimo Mad <mad1969it@gmail.com> wrote:
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
- c45ee9cd-17e3-4cec-b7fb-74af27e792a8 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: a0f9a434-7837-4ec6-8017-c9698ed5cd01
- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800
image: 4da04f46-2fea-436f-9648-772c24a849c3
- 77ddb7b8-b10f-4d7e-82df-36e077a9eb25 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: 55893adf-1e56-4346-8070-4b3e660dd44d
- ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 107374182400, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 85899345920, truesize: 1879048192
image: 0264f52e-fa59-4523-81e4-47564193665e
- dfb3d366-f2d3-49ee-8ca3-3b44e24a0111 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 536870912000, truesize: 536870912000 And after what is the next step? Regards Massimo
Il giorno lun 19 ott 2020 alle ore 13:51 Shani Leviim <sleviim@redhat.com> ha scritto:
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id>
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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>;
Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB)
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
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 of the disk is a0f9a434-7837-4ec6-8017-c9698ed5cd01 Regards Massimo Il giorno lun 19 ott 2020 alle ore 15:47 Shani Leviim <sleviim@redhat.com> ha scritto:
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, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: *ILLEGAL*, type: SPARSE, capacity: 85899345920, truesize: 1879048192
Can you try removing them from the engine UI?
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 4:36 PM Massimo Mad <mad1969it@gmail.com> wrote:
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
- c45ee9cd-17e3-4cec-b7fb-74af27e792a8 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: a0f9a434-7837-4ec6-8017-c9698ed5cd01
- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800
image: 4da04f46-2fea-436f-9648-772c24a849c3
- 77ddb7b8-b10f-4d7e-82df-36e077a9eb25 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: 55893adf-1e56-4346-8070-4b3e660dd44d
- ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 107374182400, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 85899345920, truesize: 1879048192
image: 0264f52e-fa59-4523-81e4-47564193665e
- dfb3d366-f2d3-49ee-8ca3-3b44e24a0111 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 536870912000, truesize: 536870912000 And after what is the next step? Regards Massimo
Il giorno lun 19 ott 2020 alle ore 13:51 Shani Leviim <sleviim@redhat.com> ha scritto:
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id>
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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>;
Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB)
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
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 825765ba-b132-4b36-8cb9-8ecd2c7b597a. Let's first verify the engine and vdsm are synced, According to the vdsm-tool dump-volume-chains, the disk you've mentioned seems to be legal: image: a0f9a434-7837-4ec6-8017-c9698ed5cd01 - 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800 Please share the output of the SQL query for this image as well (a0f9a434-7837-4ec6-8017-c9698ed5cd01) Also, can you please share a screenshot of the snapshot's deletion and the illegal images? *Regards,* *Shani Leviim* On Mon, Oct 19, 2020 at 6:46 PM Massimo Mad <mad1969it@gmail.com> wrote:
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 of the disk is a0f9a434-7837-4ec6-8017-c9698ed5cd01 Regards Massimo
Il giorno lun 19 ott 2020 alle ore 15:47 Shani Leviim <sleviim@redhat.com> ha scritto:
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, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: *ILLEGAL*, type: SPARSE, capacity: 85899345920, truesize: 1879048192
Can you try removing them from the engine UI?
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 4:36 PM Massimo Mad <mad1969it@gmail.com> wrote:
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
- c45ee9cd-17e3-4cec-b7fb-74af27e792a8 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: a0f9a434-7837-4ec6-8017-c9698ed5cd01
- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800
image: 4da04f46-2fea-436f-9648-772c24a849c3
- 77ddb7b8-b10f-4d7e-82df-36e077a9eb25 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: 55893adf-1e56-4346-8070-4b3e660dd44d
- ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 107374182400, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 85899345920, truesize: 1879048192
image: 0264f52e-fa59-4523-81e4-47564193665e
- dfb3d366-f2d3-49ee-8ca3-3b44e24a0111 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 536870912000, truesize: 536870912000 And after what is the next step? Regards Massimo
Il giorno lun 19 ott 2020 alle ore 13:51 Shani Leviim < sleviim@redhat.com> ha scritto:
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id>
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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>;
Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB)
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
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 --------------------------------------+--------------+--------------------------------------+--------------+----------- -------------+--------------+--------------------------------------+-----------------+--------------------------------- -----+----------------------------+----------+--------------------------------------+---------------------------------- ----+-------------+---------------+-------------+-------------+--------------------------------------+--------+-------- ---------------+-------------+--------------+---------------+------------------------+--------------------------------- -----+--------------------+------------------+-----------+-------------------+------------------+------+--------------- ----+--------+--------------------------------------+------------+------------------------+---------------------------- ----------+-------------------+--------------+-----------+------------+----------------------+-----------------------+- ----------------------+-------------------+--------------------+----------------------+---------------------+---------- -----------------+----------------------------+---------- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 | PRODIBM01 | c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-02 15:04:07+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | post_install_os | 00000000-0000-0000-0000-00000000 0000 | 2019-01-03 12:05:21.456+01 | | eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 5a52c9c4-3e8d-432b-9c20-d5f13bf36 409 | 1 | 5 | 0 | 4 | a0f9a434-7837-4ec6-8017-c9698ed5cd01 | f | 1 | VM | ansiblower01 | 1 | | a0f9a434-7837-4ec6-8017-c9698ed5 cd01 | ansiblower01_Disk1 | | f | f | Off | | 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | 0 | 2c9bf189-4fd3-4a75-9e25-0f2 c8c087979 | PRODIBM01 | 214748364800 | 12577 | 4495961 | 0.002289568 | 0.001800266 | 0.000028345 | 0 | | | | | | 776e817f-2112-4d42-8380-4160caf5059f | PRODIBM01 | c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-04 14:47:09+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | Active VM | 64ac336f-25d8-43d0-aeb8-7fb77bf6 ef97 | 2020-04-17 09:13:23.16+02 | | eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 8400fcae-ad11-4fa4-a67e-bfd5d6fc9 e8e | 2 | 4 | 2 | 1 | a0f9a434-7837-4ec6-8017-c9698ed5cd01 | t | 1 | VM | ansiblower01 | 1 | | a0f9a434-7837-4ec6-8017-c9698ed5 cd01 | ansiblower01_Disk1 | | f | f | Off | | 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | 0 | 2c9bf189-4fd3-4a75-9e25-0f2 c8c087979 | PRODIBM01 | 214748364800 | 0 | 14677 | 0.000000000 | 0.001249035 | 0.000032793 | 0 | | | | | | (2 rows) Regards Massimo
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 delete that snapshot, run this command: SELECT DeleteSnapshot(<'snapshot-id'>); *Regards,* *Shani Leviim* On Wed, Oct 21, 2020 at 1:13 AM Massimo Coloma <mad1969it@gmail.com> wrote:
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
--------------------------------------+--------------+--------------------------------------+--------------+-----------
-------------+--------------+--------------------------------------+-----------------+---------------------------------
-----+----------------------------+----------+--------------------------------------+----------------------------------
----+-------------+---------------+-------------+-------------+--------------------------------------+--------+--------
---------------+-------------+--------------+---------------+------------------------+---------------------------------
-----+--------------------+------------------+-----------+-------------------+------------------+------+---------------
----+--------+--------------------------------------+------------+------------------------+----------------------------
----------+-------------------+--------------+-----------+------------+----------------------+-----------------------+-
----------------------+-------------------+--------------------+----------------------+---------------------+---------- -----------------+----------------------------+---------- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 | PRODIBM01 | c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-02 15:04:07+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | post_install_os | 00000000-0000-0000-0000-00000000 0000 | 2019-01-03 12:05:21.456+01 | | eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 5a52c9c4-3e8d-432b-9c20-d5f13bf36 409 | 1 | 5 | 0 | 4 | a0f9a434-7837-4ec6-8017-c9698ed5cd01 | f | 1 | VM | ansiblower01 | 1 | | a0f9a434-7837-4ec6-8017-c9698ed5 cd01 | ansiblower01_Disk1 | | f | f | Off | | 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | 0 | 2c9bf189-4fd3-4a75-9e25-0f2 c8c087979 | PRODIBM01 | 214748364800 | 12577 | 4495961 | 0.002289568 | 0.001800266 | 0.000028345 | 0 | | | | | | 776e817f-2112-4d42-8380-4160caf5059f | PRODIBM01 | c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-04 14:47:09+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | Active VM | 64ac336f-25d8-43d0-aeb8-7fb77bf6 ef97 | 2020-04-17 09:13:23.16+02 | | eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 8400fcae-ad11-4fa4-a67e-bfd5d6fc9 e8e | 2 | 4 | 2 | 1 | a0f9a434-7837-4ec6-8017-c9698ed5cd01 | t | 1 | VM | ansiblower01 | 1 | | a0f9a434-7837-4ec6-8017-c9698ed5 cd01 | ansiblower01_Disk1 | | f | f | Off | | 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | 0 | 2c9bf189-4fd3-4a75-9e25-0f2 c8c087979 | PRODIBM01 | 214748364800 | 0 | 14677 | 0.000000000 | 0.001249035 | 0.000032793 | 0 | | | | | | (2 rows) Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/XYVRNHRQXZFZPU...
Hi Shani , The command it that ? SELECT DeleteSnapshot 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 Regards Max
Hi Massimo, You can find the VM's snapshot id by sending a REST API request http://localhost:8080/ovirt-engine/api/vms/<vm-id>/snapshots/ You can also find the VM's snapshots (and view their parameters) by using SQL: select * from snapshots where vm_id = '<vm-id>'; Once you have the snapshot's id, you can use that command: SELECT DeleteSnapshot('snapshot-id'); *Regards,* *Shani Leviim* On Wed, Oct 21, 2020 at 2:57 PM Massimo Coloma <mad1969it@gmail.com> wrote:
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-leave@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/HYPKECYTNIMBSM...
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
[image: Ovirt Illegal.png] Il giorno mar 20 ott 2020 alle ore 09:44 Shani Leviim <sleviim@redhat.com> 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 WHERE image_group_id = '55893adf-1e56-4346-8070-4b3e660dd44d';
and same for 825765ba-b132-4b36-8cb9-8ecd2c7b597a.
Let's first verify the engine and vdsm are synced,
According to the vdsm-tool dump-volume-chains, the disk you've mentioned seems to be legal: image: a0f9a434-7837-4ec6-8017-c9698ed5cd01
- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800
Please share the output of the SQL query for this image as well (a0f9a434-7837-4ec6-8017-c9698ed5cd01)
Also, can you please share a screenshot of the snapshot's deletion and the illegal images?
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 6:46 PM Massimo Mad <mad1969it@gmail.com> wrote:
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 of the disk is a0f9a434-7837-4ec6-8017-c9698ed5cd01 Regards Massimo
Il giorno lun 19 ott 2020 alle ore 15:47 Shani Leviim <sleviim@redhat.com> ha scritto:
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, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: *ILLEGAL*, type: SPARSE, capacity: 85899345920, truesize: 1879048192
Can you try removing them from the engine UI?
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 4:36 PM Massimo Mad <mad1969it@gmail.com> wrote:
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
- c45ee9cd-17e3-4cec-b7fb-74af27e792a8 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: a0f9a434-7837-4ec6-8017-c9698ed5cd01
- 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 214748364800, truesize: 214748364800
image: 4da04f46-2fea-436f-9648-772c24a849c3
- 77ddb7b8-b10f-4d7e-82df-36e077a9eb25 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 134217728, truesize: 134217728
image: 55893adf-1e56-4346-8070-4b3e660dd44d
- ea57d10b-13d5-4696-bedc-13a92b88f32d status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 107374182400, truesize: 1744830464
image: 825765ba-b132-4b36-8cb9-8ecd2c7b597a
- 5c534181-fbd6-4912-afdc-4ac812e0e9fe status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE, capacity: 85899345920, truesize: 1879048192
image: 0264f52e-fa59-4523-81e4-47564193665e
- dfb3d366-f2d3-49ee-8ca3-3b44e24a0111 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 536870912000, truesize: 536870912000 And after what is the next step? Regards Massimo
Il giorno lun 19 ott 2020 alle ore 13:51 Shani Leviim < sleviim@redhat.com> ha scritto:
Hi Massimo, In order to locate the illegal image, you can run this command on the host: vdsm-tool dump-volume-chains <sd_id>
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 images_storage_domain_view images_storage_domain_view WHERE image_group_id = <image_group_id>;
Than, you can try removing it from the engine. (and if it doesn't work - you can delete it from the DB)
*Regards,*
*Shani Leviim*
On Mon, Oct 19, 2020 at 11:15 AM Massimo Mad <mad1969it@gmail.com> wrote:
Hi, I try to delete a snapshot that i have created in the past, now in the events i have the following error: Failed to delete snapshot And the VM now has the exclamation point with the following message: VM has snapshot with disk in illegal status How i can fix this problem ? Regards Massimo _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/VZJ62WAKAVWWOR...
participants (3)
-
Massimo Coloma -
Massimo Mad
-
Shani Leviim