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 <blanc...@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
blanc...@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
blanc...@abes.fr
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/XDXE22ZIQGNLLYT77NB7HC6QTBY3M76Z/
