Hi Massimo, This snapshot should be removed from the DB, as it seems that the vdsm-dump has 1 image related to the 'a0f9a434-7837-4ec6-8017-c9698ed5cd01' image , while the engine reports on 2 images (64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 and 776e817f-2112-4d42-8380-4160caf5059f)
In order to delete that snapshot, run this command: SELECT DeleteSnapshot(<'snapshot-id'>); *Regards,* *Shani Leviim* On Wed, Oct 21, 2020 at 1:13 AM Massimo Coloma <mad196...@gmail.com> wrote: > Hi, > I send you the output of the first query: > engine=# SELECT * FROM images_storage_domain_view > images_storage_domain_view WHERE image_group_id = > '55893adf-1e56-4346-8070-4b3e660dd44d'; > image_guid | storage_name | storage_pool_id | storage_type | > creation_date | size | it_guid | description | parentid | > lastmodified | app_list | storage_id | vm_snapshot_id | volume_type | > volume_format | qcow_compat | imagestatus | imag > e_group_id | active | volume_classification | entity_type | vm_names | > number_of_vms | template_version_names | disk_id > | disk_alias | disk_description | shareable | wipe_after_delete | > propagate_errors | sgio | disk_content_type | backup > | quota_id | quota_name | quota_enforcement_type | disk_profile_id | > disk_profile_name | actual_size | read_rate | wri > te_rate | read_latency_seconds | write_latency_seconds | > flush_latency_seconds | disk_storage_type | cinder_volume_type > | image_transfer_phase | image_transfer_type | image_transfer_bytes_sent > | image_transfer_bytes_total | progress > > ------------+--------------+-----------------+--------------+---------------+------+---------+-------------+----------+ > > --------------+----------+------------+----------------+-------------+---------------+-------------+-------------+----- > > -----------+--------+-----------------------+-------------+----------+---------------+------------------------+-------- > > -+------------+------------------+-----------+-------------------+------------------+------+-------------------+------- > > -+----------+------------+------------------------+-----------------+-------------------+-------------+-----------+---- > > --------+----------------------+-----------------------+-----------------------+-------------------+------------------- > > -+----------------------+---------------------+---------------------------+----------------------------+---------- > (0 rows) > > The second query: > engine=# SELECT * FROM images_storage_domain_view > images_storage_domain_view WHERE image_group_id = > '825765ba-b132-4b36-8cb9-8ecd2c7b597a'; > image_guid | storage_name | storage_pool_id | storage_type | > creation_date | size | it_guid | description | parentid | > lastmodified | app_list | storage_id | vm_snapshot_id | volume_type | > volume_format | qcow_compat | imagestatus | imag > e_group_id | active | volume_classification | entity_type | vm_names | > number_of_vms | template_version_names | disk_id > | disk_alias | disk_description | shareable | wipe_after_delete | > propagate_errors | sgio | disk_content_type | backup > | quota_id | quota_name | quota_enforcement_type | disk_profile_id | > disk_profile_name | actual_size | read_rate | wri > te_rate | read_latency_seconds | write_latency_seconds | > flush_latency_seconds | disk_storage_type | cinder_volume_type > | image_transfer_phase | image_transfer_type | image_transfer_bytes_sent > | image_transfer_bytes_total | progress > > ------------+--------------+-----------------+--------------+---------------+------+---------+-------------+----------+ > > --------------+----------+------------+----------------+-------------+---------------+-------------+-------------+----- > > -----------+--------+-----------------------+-------------+----------+---------------+------------------------+-------- > > -+------------+------------------+-----------+-------------------+------------------+------+-------------------+------- > > -+----------+------------+------------------------+-----------------+-------------------+-------------+-----------+---- > > --------+----------------------+-----------------------+-----------------------+-------------------+------------------- > > -+----------------------+---------------------+---------------------------+----------------------------+---------- > (0 rows) > The last query: > engine=# SELECT * FROM images_storage_domain_view > images_storage_domain_view WHERE image_group_id = > 'a0f9a434-7837-4ec6-8017-c9698ed5cd01'; > image_guid | storage_name | > storage_pool_id | storage_type | creati > on_date | size | it_guid | > description | parentid > | lastmodified | app_list | storage_id > | vm_snapshot_id > | volume_type | volume_format | qcow_compat | imagestatus | > image_group_id | active | volume_ > classification | entity_type | vm_names | number_of_vms | > template_version_names | disk_id > | disk_alias | disk_description | shareable | > wipe_after_delete | propagate_errors | sgio | disk_content_t > ype | backup | quota_id | quota_name | > quota_enforcement_type | disk_profile_id > | disk_profile_name | actual_size | read_rate | write_rate | > read_latency_seconds | write_latency_seconds | > flush_latency_seconds | disk_storage_type | cinder_volume_type | > image_transfer_phase | image_transfer_type | image_tra > nsfer_bytes_sent | image_transfer_bytes_total | progress > > --------------------------------------+--------------+--------------------------------------+--------------+----------- > > -------------+--------------+--------------------------------------+-----------------+--------------------------------- > > -----+----------------------------+----------+--------------------------------------+---------------------------------- > > ----+-------------+---------------+-------------+-------------+--------------------------------------+--------+-------- > > ---------------+-------------+--------------+---------------+------------------------+--------------------------------- > > -----+--------------------+------------------+-----------+-------------------+------------------+------+--------------- > > ----+--------+--------------------------------------+------------+------------------------+---------------------------- > > ----------+-------------------+--------------+-----------+------------+----------------------+-----------------------+- > > ----------------------+-------------------+--------------------+----------------------+---------------------+---------- > -----------------+----------------------------+---------- > 64ac336f-25d8-43d0-aeb8-7fb77bf6ef97 | PRODIBM01 | > c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-02 > 15:04:07+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | > post_install_os | 00000000-0000-0000-0000-00000000 > 0000 | 2019-01-03 12:05:21.456+01 | | > eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 5a52c9c4-3e8d-432b-9c20-d5f13bf36 > 409 | 1 | 5 | 0 | 4 | > a0f9a434-7837-4ec6-8017-c9698ed5cd01 | f | > 1 | VM | ansiblower01 | 1 | > | a0f9a434-7837-4ec6-8017-c9698ed5 > cd01 | ansiblower01_Disk1 | | f | f > | Off | | > 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | > 0 | 2c9bf189-4fd3-4a75-9e25-0f2 > c8c087979 | PRODIBM01 | 214748364800 | 12577 | 4495961 | > 0.002289568 | 0.001800266 | > 0.000028345 | 0 | | > | | > | | > 776e817f-2112-4d42-8380-4160caf5059f | PRODIBM01 | > c6f4af45-0b09-4dfb-b391-338b82e580a9 | 2 | 2019-01-04 > 14:47:09+01 | 214748364800 | 00000000-0000-0000-0000-000000000000 | > Active VM | 64ac336f-25d8-43d0-aeb8-7fb77bf6 > ef97 | 2020-04-17 09:13:23.16+02 | | > eb483eb3-a9ce-4867-9ce8-96a0ca171042 | 8400fcae-ad11-4fa4-a67e-bfd5d6fc9 > e8e | 2 | 4 | 2 | 1 | > a0f9a434-7837-4ec6-8017-c9698ed5cd01 | t | > 1 | VM | ansiblower01 | 1 | > | a0f9a434-7837-4ec6-8017-c9698ed5 > cd01 | ansiblower01_Disk1 | | f | f > | Off | | > 0 | None | 59e09256-0240-024f-022a-0000000004f3 | Default | > 0 | 2c9bf189-4fd3-4a75-9e25-0f2 > c8c087979 | PRODIBM01 | 214748364800 | 0 | 14677 | > 0.000000000 | 0.001249035 | > 0.000032793 | 0 | | > | | > | | > (2 rows) > Regards > Massimo > _______________________________________________ > 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/XYVRNHRQXZFZPUOQKWFWOZYAJ4LIG4IT/ >
_______________________________________________ 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/IYV2YS25622WRYXXJEK5ZMMDLSMJPCEX/