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