[ovirt-users] Re: Cannot remove template because a disk is based on it

Hi Arik, El 2023-10-01 07:41, Arik Hadas escribió: > On Fri, Sep 29, 2023 at 1:36 PM <nicolas(a)devels.es&gt; wrote: > >> Hi, >> >> We're running oVirt 4.5. We have a template which we'd like to get >> rid >> of, there are no VMs based on it. However, trying to remove it oVirt >> >> states that: >> >> Cannot remove Template. The following Disk(s) are based on it: >> (b54ee1cb-ed64-4db4-bd3d-eac8b22ea095) . >> >> When opening the 'Disks' subtab in the template, it appears a disk >> (screenshot attached). >> >> However, when opening the oVirt Storage->Disks option, I cannot find >> the >> disk by the ID, not even ordering the ID column and trying to find >> it >> visually. > >> Can anyone point to the problem and a possible solution/workaround? > > Can you share the output of the following DB queries: > 1. select * from base_disks where > disk_id='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; > engine=# select * from base_disks where disk_id='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; disk_id | wipe_after_delete | propagate_errors | disk_alias | disk_description | shareable | sgio | disk_storage_type | cinder_volume_type | disk_content_type | backup | backup_mode ---------+-------------------+------------------+------------+------------------+-----------+------+-------------------+--------------------+-------------------+--------+------------- (0 filas) > 2. select * from images where > image_group_id='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; engine=# select * from images where image_group_id='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; image_guid | creation_date | size | it_guid | parentid | imagestatus | lastmodified | vm_snapshot_id | volume_type | volume_format | image_group_id | _create_date | _update_date | active | volume_classification | qcow_compat | sequence_number --------------------------------------+----------------------------+-------------+--------------------------------------+--------------------------------------+-------------+----------------------------+-------- ------------------------------+-------------+---------------+--------------------------------------+-------------------------------+--------------+--------+-----------------------+-------------+----------------- 987fcd68-d48e-4314-bb4e-363671d222be | 2023-01-16 03:24:35.827+00 | 26843545600 | bc5c67f5-503e-4482-9628-48fcf70aa055 | bc5c67f5-503e-4482-9628-48fcf70aa055 | 1 | 2023-01-16 03:24:35.827+00 | 67beb3b 2-3e84-4fe8-8334-9c93e8c0fff9 | 2 | 4 | b54ee1cb-ed64-4db4-bd3d-eac8b22ea095 | 2023-01-16 03:24:37.054541+00 | | t | 0 | 0 | 0 (1 fila) > 3. select * from disk_vm_element where disk_id > ='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; > engine=# select * from disk_vm_element where disk_id ='b54ee1cb-ed64-4db4-bd3d-eac8b22ea095'; disk_id | vm_id | is_boot | disk_interface | is_using_scsi_reservation | pass_discard ---------+-------+---------+----------------+---------------------------+-------------- (0 filas)

>> Thanks._______________________________________________ >> 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/X5DNN4IMTA7...