7:38 p.m.
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(a)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(a)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(a)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(a)abes.fr