6:46 p.m.
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