Thank you very much, Shani

I've got what you asked and some good news as well. I'll start with the good news: the snapshots status changes to OK if I try to live-migrate the disk to another storage domain in the same cabin. Then I can delete them. Just tried with two illegal snapshots and it worked, I'll send you the engine logs as soon as I can check them.

If I go with the query to the database (the following one) I get 0 rows

# select * from images where vm_snapshot_id IN ('f649d9c1-563e-49d4-9fad-6bc94abc279b', '5734df23-de67-41a8-88a1-423cecfe7260', 'f649d9c1-563e-49d4-9fad-6bc94abc279b', '2929df28-eae8-4f27-afee-a984fe0b07e7', '4bd4360e-e0f4-4629-ab38-2f0d80d3ae0f', 'fbaff53b-30ce-4b20-8f10-80e70becb48c', 'c628386a-da6c-4a0d-ae7d-3e6ecda27d6d', 'e9ddaa5c-007d-49e6-8384-efefebb00aa6', '5b6db52a-bfe3-45f8-b7bb-d878c4e63cb4', '7efe2e7e-ca24-4b27-b512-b42795c79ea4');

BTW, the dump-volume-chains is here. I deleted the disks with no snapshots in illegal status

Images volume chains (base volume first)

   image:    4dab82be-7068-4234-8478-45ec51a29bc0

             - 04f7bafd-aa56-4940-9c4e-e4055972284e
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - 0fe7e3bf-24a9-45b3-9f33-9d93349b2ac1
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    7428f6fd-ae2e-4691-b718-1422b1150798

             - a81b454e-17b1-4c6a-a7bc-803a0e3b2b03
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    c111cb15-5465-4056-b0bb-bd94565d6060

             - 2443c7f2-9ee3-4a92-a80e-c3ee1a481311
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    2900bc6b-3345-42a4-9533-667fb4009deb

             - e9ddaa5c-007d-49e6-8384-efefebb00aa6
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - 8be46861-3d44-4dd3-9216-a2817f9d0db9
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    79663e1f-c6a7-4193-91fa-d5cbe02f81e3

             - f649d9c1-563e-49d4-9fad-6bc94abc279b
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - f0a381bb-4110-43de-999c-99ae9cb03a5a
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    e1f3dafb-64be-46a9-a3dc-1f3f7fcd1960                                                                                                                                                        

             - 4bd4360e-e0f4-4629-ab38-2f0d80d3ae0f
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - 0fd199eb-ab26-46de-b0b4-b1be58d635c2
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    fcdeeff4-1f1a-4ced-b6e9-0746c54a7fe9

             - 5b6db52a-bfe3-45f8-b7bb-d878c4e63cb4
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - c133af2a-6642-4809-b2cc-267d4cbadec9
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    06216874-7c66-4e8c-ab3b-4dd4ae8281c1

             - 32459132-88f9-460d-8fb5-17ac41413cff
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    4b87c897-062c-4e71-874b-ce48376cc463

             - 16ac155d-cf61-4eb2-8227-6503ee6d3414
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    24acdba6-f600-464d-a662-22e42bbcdf1c

             - b04cc993-164e-49f1-9d46-e013bf3e66f3
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    562bf24c-d69c-4ec5-a670-e5eba5064fab

             - c628386a-da6c-4a0d-ae7d-3e6ecda27d6d
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - ecab3f58-0ae3-4d2a-b0df-dd712b3d5a70
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    0cc6d13d-5878-4fd2-bf54-5aef95017bc5

             - 05aa8ec3-674b-4a8e-be39-2bddc18369e4
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    30a88bec-4262-47ce-a329-59ed5350e10a

             - a96de756-275e-4e64-a9c9-c8cc221f2bac
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    818a3dbe-9cfa-4355-b4b6-c2dda51beef5

             - ba422faf-25df-45d0-80aa-c4cad166fcbd
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - df419136-ebcc-4087-8b5c-2c5a29f0dcfd
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE

   image:    c5cc464e-eb71-4edf-a780-60180c592a6f

             - 5734df23-de67-41a8-88a1-423cecfe7260
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - fa154782-0dbb-45b5-ba62-d6937259f097
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    ded89dac-ce57-4c09-8ca5-dd131e0776df

             - fbaff53b-30ce-4b20-8f10-80e70becb48c
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - 2feae690-0301-4ec3-9277-57ad3168141b
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    f2e35007-ff0f-4f74-90ec-1a28d342d564

             - 096faec2-e0e0-47a5-9a24-9332de963bfb
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    0d9b635d-22ef-4456-9b10-20be027baa7a

             - 2929df28-eae8-4f27-afee-a984fe0b07e7
               status: OK, voltype: INTERNAL, format: RAW, legality: LEGAL, type: PREALLOCATED

             - f65be7d6-d1bf-4db3-aa04-fd59265d5ebc
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    1fd83784-dc53-4f40-ac13-ac2f046aa81f

             - b4139999-1671-416c-bebc-3415ee7e61b2
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    145e5438-b7e8-45fd-81ea-3eb10a07acb6

             - baa84312-8c4e-4ac1-aa50-27836b67e5f6
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - 2a95e1fb-7e42-4589-836b-76b45f03f854
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


   image:    dc856555-bfef-4bfa-8351-59b5a4f04331

             - 7efe2e7e-ca24-4b27-b512-b42795c79ea4
               status: OK, voltype: INTERNAL, format: COW, legality: LEGAL, type: SPARSE

             - a3f715c2-efc4-4421-aa4b-efce5a853e9e
               status: ILLEGAL, voltype: LEAF, format: COW, legality: ILLEGAL, type: SPARSE


Thank you very much!!!

Bruno

On Mon, Feb 25, 2019 at 11:32 AM Shani Leviim <sleviim@redhat.com> wrote:
Hi Bruno,
Can you please share the output of:
vdsm-tool dump-volume-chains <the-relevant-storage-domain-id>

Also, can you see those images on the 'images' table?

Regards,
Shani Leviim


On Mon, Feb 25, 2019 at 9:32 AM Bruno Rodriguez <bruno@pic.es> wrote:
Good morning, Shani

I'm not trying to deactivate any disk because the VM using it is working. I can't turn it off because I'm pretty sure if I do I won't be able to turn it on again, in fact the web interface is telling me that if I turn it off possibly it won't restart :(

For what I can check I have no information about any of the the snapshots I provided in the database

engine=# select * from snapshots where snapshot_id IN ('f649d9c1-563e-49d4-9fad-6bc94abc279b', '5734df23-de67-41a8-88a1-423cecfe7260', 'f649d9c1-563e-49d4-9fad-6bc94abc279b', '2929df28-eae8-4f27-afee-a984fe0b07e7', '4bd4360e-e0f4-4629-ab38-2f0d80d3ae0f', 'fbaff53b-30ce-4b20-8f10-80e70becb48c', 'c628386a-da6c-4a0d-ae7d-3e6ecda27d6d', 'e9ddaa5c-007d-49e6-8384-efefebb00aa6', '5b6db52a-bfe3-45f8-b7bb-d878c4e63cb4', '7efe2e7e-ca24-4b27-b512-b42795c79ea4');
 snapshot_id | vm_id | snapshot_type | status | description | creation_date | app_list | vm_configuration | _create_date | _update_date | memory_volume | memory_metadata_disk_id | memory_dump_disk_id | vm_conf
iguration_broken
-------------+-------+---------------+--------+-------------+---------------+----------+------------------+--------------+--------------+---------------+-------------------------+---------------------+--------
-----------------
(0 rows)


Thank you


On Sun, Feb 24, 2019 at 12:16 PM Shani Leviim <sleviim@redhat.com> wrote:
Hi Bruno,

It seems that the disk you're trying to deactivate is in use ( Logical volume e655abce-c5e8-44f3-8d50-9fd76edf05cb/fa154782-0dbb-45b5-ba62-d6937259f097 in use).
Is there any task that uses that disk?

Also, did you try to verify the snapshot's creation date with the DB?
( select * from snapshots; )

Regards
Shani Leviim


On Fri, Feb 22, 2019 at 6:08 PM Bruno Rodriguez <bruno@pic.es> wrote:
Hello, 

We are experiencing some problems with some snapshots in illegal status generated with the python API. I think I'm not the only one, and that is not a relief but I hope someone can help about it. 

I'm a bit scared because, for what I see, the creation date in the engine for every snapshot is way different from the date when it was really created. The name of the snapshot is in the format backup_snapshot_YYYYMMDD-HHMMSS, but as you can see in the following examples, the stored date is totally random...

Size
Creation Date
Snapshot Description
Status
Disk Snapshot ID

33 GiB
Mar 2, 2018, 5:03:57 PM
backup_snapshot_20190217-011645
Illegal
5734df23-de67-41a8-88a1-423cecfe7260

33 GiB
May 8, 2018, 10:02:56 AM
backup_snapshot_20190216-013047
Illegal
f649d9c1-563e-49d4-9fad-6bc94abc279b

10 GiB
Feb 21, 2018, 11:10:17 AM
backup_snapshot_20190217-010004
Illegal
2929df28-eae8-4f27-afee-a984fe0b07e7

43 GiB
Feb 2, 2018, 12:55:51 PM
backup_snapshot_20190216-015544
Illegal
4bd4360e-e0f4-4629-ab38-2f0d80d3ae0f

11 GiB
Feb 13, 2018, 12:51:08 PM
backup_snapshot_20190217-010541
Illegal
fbaff53b-30ce-4b20-8f10-80e70becb48c

11 GiB
Feb 13, 2018, 4:05:39 PM
backup_snapshot_20190217-011207
Illegal
c628386a-da6c-4a0d-ae7d-3e6ecda27d6d

11 GiB
Feb 13, 2018, 4:38:25 PM
backup_snapshot_20190216-012058
Illegal
e9ddaa5c-007d-49e6-8384-efefebb00aa6

11 GiB
Feb 13, 2018, 10:52:09 AM
backup_snapshot_20190216-012550
Illegal
5b6db52a-bfe3-45f8-b7bb-d878c4e63cb4

55 GiB
Jan 22, 2018, 5:02:29 PM
backup_snapshot_20190217-012659
Illegal
7efe2e7e-ca24-4b27-b512-b42795c79ea4


When I'm getting the logs for the first one, to check what happened to it, I get the following

2019-02-17 01:16:45,839+01 INFO  [org.ovirt.engine.core.vdsbroker.irsbroker.CreateVolumeVDSCommand] (default task-100) [96944daa-c90a-4ad7-a556-c98e66550f87] START, CreateVolumeVDSCommand( CreateVolumeVDSCommandParameters:{storagePoolId='fa64792e-73b3-4da2-9d0b-f334422aaccf', ignoreFailoverLimit='false', storageDomainId='e655abce-c5e8-44f3-8d50-9fd76edf05cb', imageGroupId='c5cc464e-eb71-4edf-a780-60180c592a6f', imageSizeInBytes='32212254720', volumeFormat='COW', newImageId='fa154782-0dbb-45b5-ba62-d6937259f097', imageType='Sparse', newImageDescription='', imageInitialSizeInBytes='0', imageId='5734df23-de67-41a8-88a1-423cecfe7260', sourceImageGroupId='c5cc464e-eb71-4edf-a780-60180c592a6f'}), log id: 497c168a
2019-02-17 01:18:26,506+01 INFO  [org.ovirt.engine.core.vdsbroker.vdsbroker.GetVolumeInfoVDSCommand] (default task-212) [19f00d3e-5159-48aa-b3a0-615a085b62d9] START, GetVolumeInfoVDSCommand(HostName = hood13.pic.es, GetVolumeInfoVDSCommandParameters:{hostId='0a774472-5737-4ea2-b49a-6f0ea4572199', storagePoolId='fa64792e-73b3-4da2-9d0b-f334422aaccf', storageDomainId='e655abce-c5e8-44f3-8d50-9fd76edf05cb', imageGroupId='c5cc464e-eb71-4edf-a780-60180c592a6f', imageId='5734df23-de67-41a8-88a1-423cecfe7260'}), log id: 111a34cf
2019-02-17 01:18:26,764+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (default task-212) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Successfully added Download disk 'vm.example.com_Disk1' (id '5734df23-de67-41a8-88a1-423cecfe7260') for image transfer command '11104d8c-2a9b-4924-96ce-42ef66725616'
2019-02-17 01:18:27,310+01 INFO  [org.ovirt.engine.core.vdsbroker.vdsbroker.AddImageTicketVDSCommand] (default task-212) [19f00d3e-5159-48aa-b3a0-615a085b62d9] START, AddImageTicketVDSCommand(HostName = hood11.pic.es, AddImageTicketVDSCommandParameters:{hostId='79cbda85-35f4-44df-b309-01b57bc2477e', ticketId='0d389c3e-5ea5-4886-8ea7-60a1560e3b2d', timeout='300', operations='[read]', size='35433480192', url='file:///rhev/data-center/mnt/blockSD/e655abce-c5e8-44f3-8d50-9fd76edf05cb/images/c5cc464e-eb71-4edf-a780-60180c592a6f/5734df23-de67-41a8-88a1-423cecfe7260', filename='null'}), log id: f5de141
2019-02-17 01:22:28,898+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-100) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Renewing transfer ticket for Download disk 'vm.example.com_Disk1' (id '5734df23-de67-41a8-88a1-423cecfe7260')
2019-02-17 01:26:33,588+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-100) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Renewing transfer ticket for Download disk 'vm.example.com_Disk1' (id '5734df23-de67-41a8-88a1-423cecfe7260')
2019-02-17 01:26:49,319+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-6) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Finalizing successful transfer for Download disk 'vm.example.com_Disk1' (id '5734df23-de67-41a8-88a1-423cecfe7260')
2019-02-17 01:27:17,771+01 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (EE-ManagedThreadFactory-engineScheduled-Thread-6) [19f00d3e-5159-48aa-b3a0-615a085b62d9] EVENT_ID: VDS_BROKER_COMMAND_FAILURE(10,802), VDSM hood11.pic.es command TeardownImageVDS failed: Cannot deactivate Logical Volume: ('General Storage Exception: ("5 [] [\'  Logical volume e655abce-c5e8-44f3-8d50-9fd76edf05cb/5734df23-de67-41a8-88a1-423cecfe7260 in use.\', \'  Logical volume e655abce-c5e8-44f3-8d50-9fd76edf05cb/fa154782-0dbb-45b5-ba62-d6937259f097 in use.\']\\ne655abce-c5e8-44f3-8d50-9fd76edf05cb/[\'5734df23-de67-41a8-88a1-423cecfe7260\', \'fa154782-0dbb-45b5-ba62-d6937259f097\']",)',)
2019-02-17 01:27:17,772+01 ERROR [org.ovirt.engine.core.vdsbroker.vdsbroker.TeardownImageVDSCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-6) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Command 'TeardownImageVDSCommand(HostName = hood11.pic.es, ImageActionsVDSCommandParameters:{hostId='79cbda85-35f4-44df-b309-01b57bc2477e'})' execution failed: VDSGenericException: VDSErrorException: Failed in vdscommand to TeardownImageVDS, error = Cannot deactivate Logical Volume: ('General Storage Exception: ("5 [] [\'  Logical volume e655abce-c5e8-44f3-8d50-9fd76edf05cb/5734df23-de67-41a8-88a1-423cecfe7260 in use.\', \'  Logical volume e655abce-c5e8-44f3-8d50-9fd76edf05cb/fa154782-0dbb-45b5-ba62-d6937259f097 in use.\']\\ne655abce-c5e8-44f3-8d50-9fd76edf05cb/[\'5734df23-de67-41a8-88a1-423cecfe7260\', \'fa154782-0dbb-45b5-ba62-d6937259f097\']",)',)
2019-02-17 01:27:19,204+01 INFO  [org.ovirt.engine.core.vdsbroker.vdsbroker.MergeVDSCommand] (EE-ManagedThreadFactory-commandCoordinator-Thread-6) [e73bfbec-d6bd-40e5-8009-97e6005ad1d4] START, MergeVDSCommand(HostName = hood11.pic.es, MergeVDSCommandParameters:{hostId='79cbda85-35f4-44df-b309-01b57bc2477e', vmId='addd5eba-9078-41aa-9244-fe485aded951', storagePoolId='fa64792e-73b3-4da2-9d0b-f334422aaccf', storageDomainId='e655abce-c5e8-44f3-8d50-9fd76edf05cb', imageGroupId='c5cc464e-eb71-4edf-a780-60180c592a6f', imageId='fa154782-0dbb-45b5-ba62-d6937259f097', baseImageId='5734df23-de67-41a8-88a1-423cecfe7260', topImageId='fa154782-0dbb-45b5-ba62-d6937259f097', bandwidth='0'}), log id: 1d956d48
2019-02-17 01:27:29,923+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-49) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Transfer was
successful. Download disk 'vm.example.com_Disk1' (id '5734df23-de67-41a8-88a1-423cecfe7260')
2019-02-17 01:27:30,997+01 INFO  [org.ovirt.engine.core.bll.storage.disk.image.TransferDiskImageCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-46) [19f00d3e-5159-48aa-b3a0-615a085b62d9] Successfully
transferred disk '5734df23-de67-41a8-88a1-423cecfe7260' (command id '11104d8c-2a9b-4924-96ce-42ef66725616')


For what I understand, there was a "Cannot deactivate logical volume" problem that I would thank very much if someone can help me about how to solve

Thanks again

--
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/LXYE3T2VGFCR3TQKO4A5LAKJSC7TO3WS/


--
Bruno Rodríguez Rodríguez

Port d'Informació Científica (PIC)             
Campus UAB - Edificio D,
C / Albareda, s / n 
08193-Bellaterra (Barcelona), España
GPS  coordenadas:  41.500850 2.110628



--
Bruno Rodríguez Rodríguez

Port d'Informació Científica (PIC)             
Campus UAB - Edificio D,
C / Albareda, s / n 
08193-Bellaterra (Barcelona), España
GPS  coordenadas:  41.500850 2.110628