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 <mad1969it@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-leave@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/