4:28 p.m.
Hi all,
A colleague launched this morning a snapshot creation, there was no
error message but he wasn't able to start the vm anymore, with this
issue : VM PSI-SYB-DEV is down with error. Exit message: Unable to get
volume size for domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume
109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
I tried many things but nothing works: it is impossible to remove this
disk, or copy it, or clone the vm :
Cannot detach Virtual Disk. The disk is already configured in a
snapshot. In order to detach it, remove the disk's snapshots.
There is no snaphost listed into webui or api (so not snapshot id),
while disk_snapshots exists into the associated storage domain.
So I tried to remove disks snapshot direvctly with API followind the
DELETE method
|DELETE /api/storagedomains/{storage_id}/disksnapshots/{image_id}|
[Cannot remove Disk Snapshot. VM\'s Snapshot does not exist.]
In conclusion: vm_disks can't be removed because of the non existent
associated vm's snapshot id.
I tried to remove vm_snapshots disks references directly into the
postgres DB but I didn't find the correct table.
What can I do now?
Your precious help is welcome.
--
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
4:40 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
Can you share the output of the following query:
$ psql -U engine -d engine -c "\x on" -c "select * from images where
image_group_id = '<disk_id>'"
On Mon, Jan 31, 2022 at 3:31 PM Nathanaël Blanchet <blanchet(a)abes.fr> wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was no error message but he
wasn't able to start the vm anymore, with this issue : VM PSI-SYB-DEV is down with
error. Exit message: Unable to get volume size for domain
a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume 109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
I tried many things but nothing works: it is impossible to remove this disk, or copy it,
or clone the vm :
Cannot detach Virtual Disk. The disk is already configured in a snapshot. In order to
detach it, remove the disk's snapshots.
There is no snaphost listed into webui or api (so not snapshot id), while disk_snapshots
exists into the associated storage domain.
So I tried to remove disks snapshot direvctly with API followind the DELETE method
DELETE /api/storagedomains/{storage_id}/disksnapshots/{image_id}
[Cannot remove Disk Snapshot. VM\'s Snapshot does not exist.]
In conclusion: vm_disks can't be removed because of the non existent associated
vm's snapshot id.
I tried to remove vm_snapshots disks references directly into the postgres DB but I
didn't find the correct table.
What can I do now?
Your precious help is welcome.
--
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
_______________________________________________
Users mailing list -- users(a)ovirt.org
To unsubscribe send an email to users-leave(a)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/WV3AJS4W5NA...
5:56 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
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
6:26 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
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
6:46 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
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
7:38 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
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
8:29 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
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 <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
>
--
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
12:24 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
On Mon, Jan 31, 2022 at 7:29 PM Nathanaël Blanchet <blanchet(a)abes.fr> wrote:
> 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
Is this the entire output? I assume not
>
> 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.
you can remove it using the image_guid, please check the a snapshot
with their vm_snapshot_id does not exist in the snapshots table.
image 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 is the child of
60087f63-6237-4419-a5dd-9a48c84c1c43 which is going to be removed, so
the chain needs to be fixed by updating
the parent to 379db97c-bfe1-4804-9b1f-576050efdcd3 which is the parent
of 60087f63-6237-4419-a5dd-9a48c84c1c43, and would be something like
this:
UPDATE images
SET parentid = '379db97c-bfe1-4804-9b1f-576050efdcd3'
WHERE image_guid = '109fac1e-c2e3-4ba6-9867-5d1c94d3a447';
of course this should done carefully after backing up the database
4:41 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
On Mon, Jan 31, 2022 at 2:29 PM Nathanaël Blanchet <blanchet(a)abes.fr> wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was no error
message but he wasn't able to start the vm anymore, with this issue : VM
PSI-SYB-DEV is down with error. Exit message: Unable to get volume size for
domain a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume
109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
No direct help, but you had better specify the exact version of components
and if the snapshot was directly executed inside web admin gui or via
rest/API or with any kind of external sw.
Possibly anything could have had different effects depending on versions
Gianluca
5:58 p.m.
New subject: no snaphot but engines complains there is one when trying to remove disk
Hello
Le 31/01/2022 à 14:41, Gianluca Cecchi a écrit :
On Mon, Jan 31, 2022 at 2:29 PM Nathanaël Blanchet
<blanchet(a)abes.fr>
wrote:
Hi all,
A colleague launched this morning a snapshot creation, there was
no error message but he wasn't able to start the vm anymore, with
this issue : VM PSI-SYB-DEV is down with error. Exit message:
Unable to get volume size for domain
a5be6cae-f0c8-452f-b7cd-70d0e5eed710 volume
109fac1e-c2e3-4ba6-9867-5d1c94d3a447..
No direct help, but you had better specify the exact version of
components and if the snapshot was directly executed inside web admin
gui or via rest/API or with any kind of external sw.
Possibly anything could have had different effects depending on versions
He
executed with webui engine 4.4.9
Gianluca
--
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
1022
days inactive
1023
days old
9 comments
3 participants
participants (3)
-
Benny Zlotnik -
Gianluca Cecchi -
Nathanaël Blanchet