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