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 <blanc...@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 <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
--
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/Y3HRV2WCUVRPAM2TIG7PXHNGM7H7P26I/
