no snaphot but engines complains there is one when trying to remove disk
Hi all, A colleague launched this morning a snapshot creation, there was no error message but he wasn't able to start the vm anymore, with this issue : VM PSI-SYB-DEV is down with error. Exit message: Unable to get volume size for domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume 109fac1e-c2e3-4ba6-9867-5d1c94d3a447.. I tried many things but nothing works: it is impossible to remove this disk, or copy it, or clone the vm : Cannot detach Virtual Disk. The disk is already configured in a snapshot. In order to detach it, remove the disk's snapshots. There is no snaphost listed into webui or api (so not snapshot id), while disk_snapshots exists into the associated storage domain. So I tried to remove disks snapshot direvctly with API followind the DELETE method |DELETE /api/storagedomains/{storage_id}/disksnapshots/{image_id}| [Cannot remove Disk Snapshot. VM\'s Snapshot does not exist.] In conclusion: vm_disks can't be removed because of the non existent associated vm's snapshot id. I tried to remove vm_snapshots disks references directly into the postgres DB but I didn't find the correct table. What can I do now? Your precious help is welcome. -- Nathanaël Blanchet Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
Can you share the output of the following query: $ psql -U engine -d engine -c "\x on" -c "select * from images where image_group_id = '<disk_id>'" On Mon, Jan 31, 2022 at 3:31 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was no error message but he wasn't able to start the vm anymore, with this issue : VM PSI-SYB-DEV is down with error. Exit message: Unable to get volume size for domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume 109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
I tried many things but nothing works: it is impossible to remove this disk, or copy it, or clone the vm :
Cannot detach Virtual Disk. The disk is already configured in a snapshot. In order to detach it, remove the disk's snapshots.
There is no snaphost listed into webui or api (so not snapshot id), while disk_snapshots exists into the associated storage domain.
So I tried to remove disks snapshot direvctly with API followind the DELETE method
DELETE /api/storagedomains/{storage_id}/disksnapshots/{image_id}
[Cannot remove Disk Snapshot. VM\'s Snapshot does not exist.]
In conclusion: vm_disks can't be removed because of the non existent associated vm's snapshot id.
I tried to remove vm_snapshots disks references directly into the postgres DB but I didn't find the correct table.
What can I do now?
Your precious help is welcome.
-- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
_______________________________________________ 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/WV3AJS4W5NAY55...
engine=# select * from images where image_group_id='ba2efe1a-8b83-4406-8711-7120b4bd11d0'; -[ RECORD 1 ]---------+------------------------------------- image_guid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 creation_date | 2022-01-31 10:03:29.958+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 08966754-0bb6-4c88-9ad6-35d6242fa380 imagestatus | 1 lastmodified | 2022-01-31 10:04:35.519+01 vm_snapshot_id | 623d7b5a-b90d-48b6-8db9-a86ed739ad71 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:03:30.067155+01 _update_date | 2022-01-31 10:04:35.519545+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 2 ]---------+------------------------------------- image_guid | ad3205a5-823d-4997-adc8-df769780fa3b creation_date | 2022-01-31 10:08:11.749+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c imagestatus | 1 lastmodified | 2022-01-31 10:10:36.54+01 vm_snapshot_id | c2fb7dbf-5ea9-46f9-8735-e2532193219d volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:08:11.841814+01 _update_date | 2022-01-31 10:10:36.540134+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 3 ]---------+------------------------------------- image_guid | 70c4877a-1649-4882-9cca-38cc40bd7d5a creation_date | 2022-01-31 10:12:50.02+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 imagestatus | 1 lastmodified | 2022-01-31 10:15:35.55+01 vm_snapshot_id | e0df180f-f728-44c3-8d61-d53f0cace1c4 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:12:50.120438+01 _update_date | 2022-01-31 10:15:35.550984+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 4 ]---------+------------------------------------- image_guid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 creation_date | 2022-01-31 10:04:35.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 imagestatus | 1 lastmodified | 2022-01-31 10:06:15.902+01 vm_snapshot_id | 93aa0faa-9d51-4550-87ca-801de8d4ad40 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:04:35.519545+01 _update_date | 2022-01-31 10:06:15.903055+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 5 ]---------+------------------------------------- image_guid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c creation_date | 2022-01-31 10:06:15.78+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 imagestatus | 1 lastmodified | 2022-01-31 10:08:11.841+01 vm_snapshot_id | 70717bc6-d018-4229-88d2-0a6b31ad0153 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:06:15.903055+01 _update_date | 2022-01-31 10:08:11.841814+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 6 ]---------+------------------------------------- image_guid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 creation_date | 2022-01-31 10:10:36.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | ad3205a5-823d-4997-adc8-df769780fa3b imagestatus | 1 lastmodified | 2022-01-31 10:12:50.12+01 vm_snapshot_id | 5de5b2ee-0ca4-476f-963d-7bf9b3601817 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:10:36.540134+01 _update_date | 2022-01-31 10:12:50.120438+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 7 ]---------+------------------------------------- image_guid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 creation_date | 2022-01-31 11:14:40.931+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 60087f63-6237-4419-a5dd-9a48c84c1c43 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.263+01 vm_snapshot_id | c05d9174-4338-40a1-9040-f75bdbc3903c volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 11:14:41.055894+01 _update_date | 2022-01-31 14:58:30.26388+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 8 ]---------+------------------------------------- image_guid | 7f95b43c-6007-48de-b107-fad3520c2fa6 creation_date | 2022-01-31 10:15:35.436+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 70c4877a-1649-4882-9cca-38cc40bd7d5a imagestatus | 1 lastmodified | 2022-01-31 10:17:09.272+01 vm_snapshot_id | f0a391a0-e129-4f6e-afc7-304ca2dda4d1 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:15:35.550984+01 _update_date | 2022-01-31 10:17:09.272314+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 9 ]---------+------------------------------------- image_guid | 68db1cb9-6227-4ab2-af77-0c336488abbc creation_date | 2022-01-31 14:58:30.139+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.139+01 vm_snapshot_id | dad5a7ec-804d-4351-bb97-5ddc24b2072e volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 14:58:30.26388+01 _update_date | active | t volume_classification | 0 qcow_compat | 0 -[ RECORD 10 ]--------+------------------------------------- image_guid | 379db97c-bfe1-4804-9b1f-576050efdcd3 creation_date | 2022-01-31 10:17:09.148+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 7f95b43c-6007-48de-b107-fad3520c2fa6 imagestatus | 1 lastmodified | 2022-01-31 10:27:58.556+01 vm_snapshot_id | 89c331f6-4799-4f03-888d-d9b680f1a4c6 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:17:09.272314+01 _update_date | 2022-01-31 10:27:58.557011+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 11 ]--------+------------------------------------- image_guid | 60087f63-6237-4419-a5dd-9a48c84c1c43 creation_date | 2022-01-31 10:27:58.444+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 379db97c-bfe1-4804-9b1f-576050efdcd3 imagestatus | 1 lastmodified | 2022-01-31 11:14:41.055+01 vm_snapshot_id | 979b7cfd-4b38-4e95-92e6-ed77f5320e73 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:27:58.557011+01 _update_date | 2022-01-31 11:14:41.055894+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 12 ]--------+------------------------------------- image_guid | 08966754-0bb6-4c88-9ad6-35d6242fa380 creation_date | 2018-11-15 10:08:56+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 00000000-0000-0000-0000-000000000000 imagestatus | 1 lastmodified | 2022-01-31 10:03:30.067+01 vm_snapshot_id | adedebd6-c342-4bcd-9a6c-54b9abec3a7b volume_type | 1 volume_format | 5 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2018-11-15 10:11:10.302763+01 _update_date | 2022-01-31 10:03:30.067155+01 active | f volume_classification | 1 qcow_compat | 0 Le 31/01/2022 à 14:40, Benny Zlotnik a écrit :
-c "select * from images where image_group_id = '<disk_id>'"
-- Nathanaël Blanchet Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
I see all images have a vm_snapshot_id that's not null, do you know which image it complains about? It is possible that there is no corresponding entry in the snapshots table, since I see there is foreign key On Mon, Jan 31, 2022 at 4:56 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
engine=# select * from images where image_group_id='ba2efe1a-8b83-4406-8711-7120b4bd11d0'; -[ RECORD 1 ]---------+------------------------------------- image_guid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 creation_date | 2022-01-31 10:03:29.958+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 08966754-0bb6-4c88-9ad6-35d6242fa380 imagestatus | 1 lastmodified | 2022-01-31 10:04:35.519+01 vm_snapshot_id | 623d7b5a-b90d-48b6-8db9-a86ed739ad71 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:03:30.067155+01 _update_date | 2022-01-31 10:04:35.519545+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 2 ]---------+------------------------------------- image_guid | ad3205a5-823d-4997-adc8-df769780fa3b creation_date | 2022-01-31 10:08:11.749+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c imagestatus | 1 lastmodified | 2022-01-31 10:10:36.54+01 vm_snapshot_id | c2fb7dbf-5ea9-46f9-8735-e2532193219d volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:08:11.841814+01 _update_date | 2022-01-31 10:10:36.540134+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 3 ]---------+------------------------------------- image_guid | 70c4877a-1649-4882-9cca-38cc40bd7d5a creation_date | 2022-01-31 10:12:50.02+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 imagestatus | 1 lastmodified | 2022-01-31 10:15:35.55+01 vm_snapshot_id | e0df180f-f728-44c3-8d61-d53f0cace1c4 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:12:50.120438+01 _update_date | 2022-01-31 10:15:35.550984+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 4 ]---------+------------------------------------- image_guid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 creation_date | 2022-01-31 10:04:35.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 imagestatus | 1 lastmodified | 2022-01-31 10:06:15.902+01 vm_snapshot_id | 93aa0faa-9d51-4550-87ca-801de8d4ad40 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:04:35.519545+01 _update_date | 2022-01-31 10:06:15.903055+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 5 ]---------+------------------------------------- image_guid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c creation_date | 2022-01-31 10:06:15.78+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 imagestatus | 1 lastmodified | 2022-01-31 10:08:11.841+01 vm_snapshot_id | 70717bc6-d018-4229-88d2-0a6b31ad0153 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:06:15.903055+01 _update_date | 2022-01-31 10:08:11.841814+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 6 ]---------+------------------------------------- image_guid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 creation_date | 2022-01-31 10:10:36.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | ad3205a5-823d-4997-adc8-df769780fa3b imagestatus | 1 lastmodified | 2022-01-31 10:12:50.12+01 vm_snapshot_id | 5de5b2ee-0ca4-476f-963d-7bf9b3601817 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:10:36.540134+01 _update_date | 2022-01-31 10:12:50.120438+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 7 ]---------+------------------------------------- image_guid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 creation_date | 2022-01-31 11:14:40.931+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 60087f63-6237-4419-a5dd-9a48c84c1c43 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.263+01 vm_snapshot_id | c05d9174-4338-40a1-9040-f75bdbc3903c volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 11:14:41.055894+01 _update_date | 2022-01-31 14:58:30.26388+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 8 ]---------+------------------------------------- image_guid | 7f95b43c-6007-48de-b107-fad3520c2fa6 creation_date | 2022-01-31 10:15:35.436+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 70c4877a-1649-4882-9cca-38cc40bd7d5a imagestatus | 1 lastmodified | 2022-01-31 10:17:09.272+01 vm_snapshot_id | f0a391a0-e129-4f6e-afc7-304ca2dda4d1 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:15:35.550984+01 _update_date | 2022-01-31 10:17:09.272314+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 9 ]---------+------------------------------------- image_guid | 68db1cb9-6227-4ab2-af77-0c336488abbc creation_date | 2022-01-31 14:58:30.139+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.139+01 vm_snapshot_id | dad5a7ec-804d-4351-bb97-5ddc24b2072e volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 14:58:30.26388+01 _update_date | active | t volume_classification | 0 qcow_compat | 0 -[ RECORD 10 ]--------+------------------------------------- image_guid | 379db97c-bfe1-4804-9b1f-576050efdcd3 creation_date | 2022-01-31 10:17:09.148+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 7f95b43c-6007-48de-b107-fad3520c2fa6 imagestatus | 1 lastmodified | 2022-01-31 10:27:58.556+01 vm_snapshot_id | 89c331f6-4799-4f03-888d-d9b680f1a4c6 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:17:09.272314+01 _update_date | 2022-01-31 10:27:58.557011+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 11 ]--------+------------------------------------- image_guid | 60087f63-6237-4419-a5dd-9a48c84c1c43 creation_date | 2022-01-31 10:27:58.444+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 379db97c-bfe1-4804-9b1f-576050efdcd3 imagestatus | 1 lastmodified | 2022-01-31 11:14:41.055+01 vm_snapshot_id | 979b7cfd-4b38-4e95-92e6-ed77f5320e73 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:27:58.557011+01 _update_date | 2022-01-31 11:14:41.055894+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 12 ]--------+------------------------------------- image_guid | 08966754-0bb6-4c88-9ad6-35d6242fa380 creation_date | 2018-11-15 10:08:56+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 00000000-0000-0000-0000-000000000000 imagestatus | 1 lastmodified | 2022-01-31 10:03:30.067+01 vm_snapshot_id | adedebd6-c342-4bcd-9a6c-54b9abec3a7b volume_type | 1 volume_format | 5 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2018-11-15 10:11:10.302763+01 _update_date | 2022-01-31 10:03:30.067155+01 active | f volume_classification | 1 qcow_compat | 0
Le 31/01/2022 à 14:40, Benny Zlotnik a écrit :
-c "select * from images where image_group_id = '<disk_id>'"
-- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
Engine complains about 60087f63-6237-4419-a5dd-9a48c84c1c43 and 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 Le 31/01/2022 à 16:26, Benny Zlotnik a écrit :
I see all images have a vm_snapshot_id that's not null, do you know which image it complains about? It is possible that there is no corresponding entry in the snapshots table, since I see there is foreign key
On Mon, Jan 31, 2022 at 4:56 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
engine=# select * from images where image_group_id='ba2efe1a-8b83-4406-8711-7120b4bd11d0'; -[ RECORD 1 ]---------+------------------------------------- image_guid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 creation_date | 2022-01-31 10:03:29.958+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 08966754-0bb6-4c88-9ad6-35d6242fa380 imagestatus | 1 lastmodified | 2022-01-31 10:04:35.519+01 vm_snapshot_id | 623d7b5a-b90d-48b6-8db9-a86ed739ad71 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:03:30.067155+01 _update_date | 2022-01-31 10:04:35.519545+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 2 ]---------+------------------------------------- image_guid | ad3205a5-823d-4997-adc8-df769780fa3b creation_date | 2022-01-31 10:08:11.749+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c imagestatus | 1 lastmodified | 2022-01-31 10:10:36.54+01 vm_snapshot_id | c2fb7dbf-5ea9-46f9-8735-e2532193219d volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:08:11.841814+01 _update_date | 2022-01-31 10:10:36.540134+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 3 ]---------+------------------------------------- image_guid | 70c4877a-1649-4882-9cca-38cc40bd7d5a creation_date | 2022-01-31 10:12:50.02+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 imagestatus | 1 lastmodified | 2022-01-31 10:15:35.55+01 vm_snapshot_id | e0df180f-f728-44c3-8d61-d53f0cace1c4 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:12:50.120438+01 _update_date | 2022-01-31 10:15:35.550984+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 4 ]---------+------------------------------------- image_guid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 creation_date | 2022-01-31 10:04:35.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 imagestatus | 1 lastmodified | 2022-01-31 10:06:15.902+01 vm_snapshot_id | 93aa0faa-9d51-4550-87ca-801de8d4ad40 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:04:35.519545+01 _update_date | 2022-01-31 10:06:15.903055+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 5 ]---------+------------------------------------- image_guid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c creation_date | 2022-01-31 10:06:15.78+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 imagestatus | 1 lastmodified | 2022-01-31 10:08:11.841+01 vm_snapshot_id | 70717bc6-d018-4229-88d2-0a6b31ad0153 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:06:15.903055+01 _update_date | 2022-01-31 10:08:11.841814+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 6 ]---------+------------------------------------- image_guid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 creation_date | 2022-01-31 10:10:36.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | ad3205a5-823d-4997-adc8-df769780fa3b imagestatus | 1 lastmodified | 2022-01-31 10:12:50.12+01 vm_snapshot_id | 5de5b2ee-0ca4-476f-963d-7bf9b3601817 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:10:36.540134+01 _update_date | 2022-01-31 10:12:50.120438+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 7 ]---------+------------------------------------- image_guid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 creation_date | 2022-01-31 11:14:40.931+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 60087f63-6237-4419-a5dd-9a48c84c1c43 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.263+01 vm_snapshot_id | c05d9174-4338-40a1-9040-f75bdbc3903c volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 11:14:41.055894+01 _update_date | 2022-01-31 14:58:30.26388+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 8 ]---------+------------------------------------- image_guid | 7f95b43c-6007-48de-b107-fad3520c2fa6 creation_date | 2022-01-31 10:15:35.436+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 70c4877a-1649-4882-9cca-38cc40bd7d5a imagestatus | 1 lastmodified | 2022-01-31 10:17:09.272+01 vm_snapshot_id | f0a391a0-e129-4f6e-afc7-304ca2dda4d1 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:15:35.550984+01 _update_date | 2022-01-31 10:17:09.272314+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 9 ]---------+------------------------------------- image_guid | 68db1cb9-6227-4ab2-af77-0c336488abbc creation_date | 2022-01-31 14:58:30.139+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.139+01 vm_snapshot_id | dad5a7ec-804d-4351-bb97-5ddc24b2072e volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 14:58:30.26388+01 _update_date | active | t volume_classification | 0 qcow_compat | 0 -[ RECORD 10 ]--------+------------------------------------- image_guid | 379db97c-bfe1-4804-9b1f-576050efdcd3 creation_date | 2022-01-31 10:17:09.148+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 7f95b43c-6007-48de-b107-fad3520c2fa6 imagestatus | 1 lastmodified | 2022-01-31 10:27:58.556+01 vm_snapshot_id | 89c331f6-4799-4f03-888d-d9b680f1a4c6 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:17:09.272314+01 _update_date | 2022-01-31 10:27:58.557011+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 11 ]--------+------------------------------------- image_guid | 60087f63-6237-4419-a5dd-9a48c84c1c43 creation_date | 2022-01-31 10:27:58.444+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 379db97c-bfe1-4804-9b1f-576050efdcd3 imagestatus | 1 lastmodified | 2022-01-31 11:14:41.055+01 vm_snapshot_id | 979b7cfd-4b38-4e95-92e6-ed77f5320e73 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:27:58.557011+01 _update_date | 2022-01-31 11:14:41.055894+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 12 ]--------+------------------------------------- image_guid | 08966754-0bb6-4c88-9ad6-35d6242fa380 creation_date | 2018-11-15 10:08:56+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 00000000-0000-0000-0000-000000000000 imagestatus | 1 lastmodified | 2022-01-31 10:03:30.067+01 vm_snapshot_id | adedebd6-c342-4bcd-9a6c-54b9abec3a7b volume_type | 1 volume_format | 5 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2018-11-15 10:11:10.302763+01 _update_date | 2022-01-31 10:03:30.067155+01 active | f volume_classification | 1 qcow_compat | 0
Le 31/01/2022 à 14:40, Benny Zlotnik a écrit :
-c "select * from images where image_group_id = '<disk_id>'" -- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
-- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
does their vm_snapshot_id exists in the snapshots table? do they exist on the storage? I suggest running $ vdsm-tool dump-volume-chain <sd_id> And checking what the chain looks like there. In theory it's possible to remove them from the database, but the relationships between the images would need to be fixed as well, as both images you mentioned have children On Mon, Jan 31, 2022 at 5:46 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
Engine complains about 60087f63-6237-4419-a5dd-9a48c84c1c43 and 109fac1e-c2e3-4ba6-9867-5d1c94d3a447
Le 31/01/2022 à 16:26, Benny Zlotnik a écrit :
I see all images have a vm_snapshot_id that's not null, do you know which image it complains about? It is possible that there is no corresponding entry in the snapshots table, since I see there is foreign key
On Mon, Jan 31, 2022 at 4:56 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
engine=# select * from images where image_group_id='ba2efe1a-8b83-4406-8711-7120b4bd11d0'; -[ RECORD 1 ]---------+------------------------------------- image_guid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 creation_date | 2022-01-31 10:03:29.958+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 08966754-0bb6-4c88-9ad6-35d6242fa380 imagestatus | 1 lastmodified | 2022-01-31 10:04:35.519+01 vm_snapshot_id | 623d7b5a-b90d-48b6-8db9-a86ed739ad71 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:03:30.067155+01 _update_date | 2022-01-31 10:04:35.519545+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 2 ]---------+------------------------------------- image_guid | ad3205a5-823d-4997-adc8-df769780fa3b creation_date | 2022-01-31 10:08:11.749+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c imagestatus | 1 lastmodified | 2022-01-31 10:10:36.54+01 vm_snapshot_id | c2fb7dbf-5ea9-46f9-8735-e2532193219d volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:08:11.841814+01 _update_date | 2022-01-31 10:10:36.540134+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 3 ]---------+------------------------------------- image_guid | 70c4877a-1649-4882-9cca-38cc40bd7d5a creation_date | 2022-01-31 10:12:50.02+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 imagestatus | 1 lastmodified | 2022-01-31 10:15:35.55+01 vm_snapshot_id | e0df180f-f728-44c3-8d61-d53f0cace1c4 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:12:50.120438+01 _update_date | 2022-01-31 10:15:35.550984+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 4 ]---------+------------------------------------- image_guid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 creation_date | 2022-01-31 10:04:35.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 imagestatus | 1 lastmodified | 2022-01-31 10:06:15.902+01 vm_snapshot_id | 93aa0faa-9d51-4550-87ca-801de8d4ad40 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:04:35.519545+01 _update_date | 2022-01-31 10:06:15.903055+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 5 ]---------+------------------------------------- image_guid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c creation_date | 2022-01-31 10:06:15.78+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 imagestatus | 1 lastmodified | 2022-01-31 10:08:11.841+01 vm_snapshot_id | 70717bc6-d018-4229-88d2-0a6b31ad0153 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:06:15.903055+01 _update_date | 2022-01-31 10:08:11.841814+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 6 ]---------+------------------------------------- image_guid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 creation_date | 2022-01-31 10:10:36.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | ad3205a5-823d-4997-adc8-df769780fa3b imagestatus | 1 lastmodified | 2022-01-31 10:12:50.12+01 vm_snapshot_id | 5de5b2ee-0ca4-476f-963d-7bf9b3601817 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:10:36.540134+01 _update_date | 2022-01-31 10:12:50.120438+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 7 ]---------+------------------------------------- image_guid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 creation_date | 2022-01-31 11:14:40.931+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 60087f63-6237-4419-a5dd-9a48c84c1c43 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.263+01 vm_snapshot_id | c05d9174-4338-40a1-9040-f75bdbc3903c volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 11:14:41.055894+01 _update_date | 2022-01-31 14:58:30.26388+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 8 ]---------+------------------------------------- image_guid | 7f95b43c-6007-48de-b107-fad3520c2fa6 creation_date | 2022-01-31 10:15:35.436+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 70c4877a-1649-4882-9cca-38cc40bd7d5a imagestatus | 1 lastmodified | 2022-01-31 10:17:09.272+01 vm_snapshot_id | f0a391a0-e129-4f6e-afc7-304ca2dda4d1 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:15:35.550984+01 _update_date | 2022-01-31 10:17:09.272314+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 9 ]---------+------------------------------------- image_guid | 68db1cb9-6227-4ab2-af77-0c336488abbc creation_date | 2022-01-31 14:58:30.139+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.139+01 vm_snapshot_id | dad5a7ec-804d-4351-bb97-5ddc24b2072e volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 14:58:30.26388+01 _update_date | active | t volume_classification | 0 qcow_compat | 0 -[ RECORD 10 ]--------+------------------------------------- image_guid | 379db97c-bfe1-4804-9b1f-576050efdcd3 creation_date | 2022-01-31 10:17:09.148+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 7f95b43c-6007-48de-b107-fad3520c2fa6 imagestatus | 1 lastmodified | 2022-01-31 10:27:58.556+01 vm_snapshot_id | 89c331f6-4799-4f03-888d-d9b680f1a4c6 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:17:09.272314+01 _update_date | 2022-01-31 10:27:58.557011+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 11 ]--------+------------------------------------- image_guid | 60087f63-6237-4419-a5dd-9a48c84c1c43 creation_date | 2022-01-31 10:27:58.444+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 379db97c-bfe1-4804-9b1f-576050efdcd3 imagestatus | 1 lastmodified | 2022-01-31 11:14:41.055+01 vm_snapshot_id | 979b7cfd-4b38-4e95-92e6-ed77f5320e73 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:27:58.557011+01 _update_date | 2022-01-31 11:14:41.055894+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 12 ]--------+------------------------------------- image_guid | 08966754-0bb6-4c88-9ad6-35d6242fa380 creation_date | 2018-11-15 10:08:56+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 00000000-0000-0000-0000-000000000000 imagestatus | 1 lastmodified | 2022-01-31 10:03:30.067+01 vm_snapshot_id | adedebd6-c342-4bcd-9a6c-54b9abec3a7b volume_type | 1 volume_format | 5 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2018-11-15 10:11:10.302763+01 _update_date | 2022-01-31 10:03:30.067155+01 active | f volume_classification | 1 qcow_compat | 0
Le 31/01/2022 à 14:40, Benny Zlotnik a écrit :
-c "select * from images where image_group_id = '<disk_id>'" -- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
-- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
Le 31/01/2022 à 17:38, Benny Zlotnik a écrit :
does their vm_snapshot_id exists in the snapshots table?
do they exist on the storage? I suggest running $ vdsm-tool dump-volume-chain <sd_id>
it doesn't seem to exist: image: ba2efe1a-8b83-4406-8711-7120b4bd11d0 - 08966754-0bb6-4c88-9ad6-35d6242fa380 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 219982856192, truesize: 219982856192
And checking what the chain looks like there.
In theory it's possible to remove them from the database, but the relationships between the images would need to be fixed as well, as both images you mentioned have children
okay, tell me how to remove them from the DB please.
On Mon, Jan 31, 2022 at 5:46 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
Engine complains about 60087f63-6237-4419-a5dd-9a48c84c1c43 and 109fac1e-c2e3-4ba6-9867-5d1c94d3a447
Le 31/01/2022 à 16:26, Benny Zlotnik a écrit :
I see all images have a vm_snapshot_id that's not null, do you know which image it complains about? It is possible that there is no corresponding entry in the snapshots table, since I see there is foreign key
On Mon, Jan 31, 2022 at 4:56 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
engine=# select * from images where image_group_id='ba2efe1a-8b83-4406-8711-7120b4bd11d0'; -[ RECORD 1 ]---------+------------------------------------- image_guid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 creation_date | 2022-01-31 10:03:29.958+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 08966754-0bb6-4c88-9ad6-35d6242fa380 imagestatus | 1 lastmodified | 2022-01-31 10:04:35.519+01 vm_snapshot_id | 623d7b5a-b90d-48b6-8db9-a86ed739ad71 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:03:30.067155+01 _update_date | 2022-01-31 10:04:35.519545+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 2 ]---------+------------------------------------- image_guid | ad3205a5-823d-4997-adc8-df769780fa3b creation_date | 2022-01-31 10:08:11.749+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c imagestatus | 1 lastmodified | 2022-01-31 10:10:36.54+01 vm_snapshot_id | c2fb7dbf-5ea9-46f9-8735-e2532193219d volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:08:11.841814+01 _update_date | 2022-01-31 10:10:36.540134+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 3 ]---------+------------------------------------- image_guid | 70c4877a-1649-4882-9cca-38cc40bd7d5a creation_date | 2022-01-31 10:12:50.02+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 imagestatus | 1 lastmodified | 2022-01-31 10:15:35.55+01 vm_snapshot_id | e0df180f-f728-44c3-8d61-d53f0cace1c4 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:12:50.120438+01 _update_date | 2022-01-31 10:15:35.550984+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 4 ]---------+------------------------------------- image_guid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 creation_date | 2022-01-31 10:04:35.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 0bf72cb1-d90d-4b3d-bbfe-1e1c58a6ce46 imagestatus | 1 lastmodified | 2022-01-31 10:06:15.902+01 vm_snapshot_id | 93aa0faa-9d51-4550-87ca-801de8d4ad40 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:04:35.519545+01 _update_date | 2022-01-31 10:06:15.903055+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 5 ]---------+------------------------------------- image_guid | 733b1d36-d107-4adc-9ac0-a0c800c2c22c creation_date | 2022-01-31 10:06:15.78+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 20585d25-a90d-4ef5-a9bb-2205f79c99d8 imagestatus | 1 lastmodified | 2022-01-31 10:08:11.841+01 vm_snapshot_id | 70717bc6-d018-4229-88d2-0a6b31ad0153 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:06:15.903055+01 _update_date | 2022-01-31 10:08:11.841814+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 6 ]---------+------------------------------------- image_guid | a8b0087c-e975-4b8a-b137-0ea1c9107db6 creation_date | 2022-01-31 10:10:36.419+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | ad3205a5-823d-4997-adc8-df769780fa3b imagestatus | 1 lastmodified | 2022-01-31 10:12:50.12+01 vm_snapshot_id | 5de5b2ee-0ca4-476f-963d-7bf9b3601817 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:10:36.540134+01 _update_date | 2022-01-31 10:12:50.120438+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 7 ]---------+------------------------------------- image_guid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 creation_date | 2022-01-31 11:14:40.931+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 60087f63-6237-4419-a5dd-9a48c84c1c43 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.263+01 vm_snapshot_id | c05d9174-4338-40a1-9040-f75bdbc3903c volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 11:14:41.055894+01 _update_date | 2022-01-31 14:58:30.26388+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 8 ]---------+------------------------------------- image_guid | 7f95b43c-6007-48de-b107-fad3520c2fa6 creation_date | 2022-01-31 10:15:35.436+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 70c4877a-1649-4882-9cca-38cc40bd7d5a imagestatus | 1 lastmodified | 2022-01-31 10:17:09.272+01 vm_snapshot_id | f0a391a0-e129-4f6e-afc7-304ca2dda4d1 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:15:35.550984+01 _update_date | 2022-01-31 10:17:09.272314+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 9 ]---------+------------------------------------- image_guid | 68db1cb9-6227-4ab2-af77-0c336488abbc creation_date | 2022-01-31 14:58:30.139+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 imagestatus | 1 lastmodified | 2022-01-31 14:58:30.139+01 vm_snapshot_id | dad5a7ec-804d-4351-bb97-5ddc24b2072e volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 14:58:30.26388+01 _update_date | active | t volume_classification | 0 qcow_compat | 0 -[ RECORD 10 ]--------+------------------------------------- image_guid | 379db97c-bfe1-4804-9b1f-576050efdcd3 creation_date | 2022-01-31 10:17:09.148+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 7f95b43c-6007-48de-b107-fad3520c2fa6 imagestatus | 1 lastmodified | 2022-01-31 10:27:58.556+01 vm_snapshot_id | 89c331f6-4799-4f03-888d-d9b680f1a4c6 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:17:09.272314+01 _update_date | 2022-01-31 10:27:58.557011+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 11 ]--------+------------------------------------- image_guid | 60087f63-6237-4419-a5dd-9a48c84c1c43 creation_date | 2022-01-31 10:27:58.444+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 379db97c-bfe1-4804-9b1f-576050efdcd3 imagestatus | 1 lastmodified | 2022-01-31 11:14:41.055+01 vm_snapshot_id | 979b7cfd-4b38-4e95-92e6-ed77f5320e73 volume_type | 2 volume_format | 4 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2022-01-31 10:27:58.557011+01 _update_date | 2022-01-31 11:14:41.055894+01 active | f volume_classification | 1 qcow_compat | 0 -[ RECORD 12 ]--------+------------------------------------- image_guid | 08966754-0bb6-4c88-9ad6-35d6242fa380 creation_date | 2018-11-15 10:08:56+01 size | 219902115840 it_guid | 00000000-0000-0000-0000-000000000000 parentid | 00000000-0000-0000-0000-000000000000 imagestatus | 1 lastmodified | 2022-01-31 10:03:30.067+01 vm_snapshot_id | adedebd6-c342-4bcd-9a6c-54b9abec3a7b volume_type | 1 volume_format | 5 image_group_id | ba2efe1a-8b83-4406-8711-7120b4bd11d0 _create_date | 2018-11-15 10:11:10.302763+01 _update_date | 2022-01-31 10:03:30.067155+01 active | f volume_classification | 1 qcow_compat | 0
Le 31/01/2022 à 14:40, Benny Zlotnik a écrit :
-c "select * from images where image_group_id = '<disk_id>'" -- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
-- Nathanaël Blanchet
Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
-- Nathanaël Blanchet Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
On Mon, Jan 31, 2022 at 7:29 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
it doesn't seem to exist:
image: ba2efe1a-8b83-4406-8711-7120b4bd11d0
- 08966754-0bb6-4c88-9ad6-35d6242fa380 status: OK, voltype: LEAF, format: RAW, legality: LEGAL, type: PREALLOCATED, capacity: 219982856192, truesize: 219982856192 Is this the entire output? I assume not
And checking what the chain looks like there.
In theory it's possible to remove them from the database, but the relationships between the images would need to be fixed as well, as both images you mentioned have children
okay, tell me how to remove them from the DB please.
you can remove it using the image_guid, please check the a snapshot with their vm_snapshot_id does not exist in the snapshots table. image 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 is the child of 60087f63-6237-4419-a5dd-9a48c84c1c43 which is going to be removed, so the chain needs to be fixed by updating the parent to 379db97c-bfe1-4804-9b1f-576050efdcd3 which is the parent of 60087f63-6237-4419-a5dd-9a48c84c1c43, and would be something like this: UPDATE images SET parentid = '379db97c-bfe1-4804-9b1f-576050efdcd3' WHERE image_guid = '109fac1e-c2e3-4ba6-9867-5d1c94d3a447'; of course this should done carefully after backing up the database
On Mon, Jan 31, 2022 at 2:29 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was no error message but he wasn't able to start the vm anymore, with this issue : VM PSI-SYB-DEV is down with error. Exit message: Unable to get volume size for domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume 109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
No direct help, but you had better specify the exact version of components and if the snapshot was directly executed inside web admin gui or via rest/API or with any kind of external sw. Possibly anything could have had different effects depending on versions Gianluca
Hello Le 31/01/2022 à 14:41, Gianluca Cecchi a écrit :
On Mon, Jan 31, 2022 at 2:29 PM Nathanaël Blanchet <blanchet@abes.fr> wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was no error message but he wasn't able to start the vm anymore, with this issue : VM PSI-SYB-DEV is down with error. Exit message: Unable to get volume size for domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume 109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
No direct help, but you had better specify the exact version of components and if the snapshot was directly executed inside web admin gui or via rest/API or with any kind of external sw. Possibly anything could have had different effects depending on versions He executed with webui engine 4.4.9
Gianluca
-- Nathanaël Blanchet Supervision réseau SIRE 227 avenue Professeur-Jean-Louis-Viala 34193 MONTPELLIER CEDEX 5 Tél. 33 (0)4 67 54 84 55 Fax 33 (0)4 67 54 84 14 blanchet@abes.fr
participants (3)
-
Benny Zlotnik -
Gianluca Cecchi -
Nathanaël Blanchet