Hi,
You can use the DeleteImage tool [1], but it's first recommended to backup
your engine.

To be on the safe side, here are some checks it's better to execute before
deleting:
- In order to locate the illegal image, you can run this command on the
host:
vdsm-tool dump-volume-chains <sd_id>

- It's also recommended to verify that the engine and vdsm are synced about
that image, once you've found it, by running this command on the engine:
SELECT *
     FROM images_storage_domain_view images_storage_domain_view
     WHERE image_group_id = <image_group_id>;

[1]
DeleteImage tool:
SELECT DeleteImage('image-id');

    DELETE
    FROM images
    WHERE image_guid = v_image_guid;



*Regards,*

*Shani Leviim*


On Wed, Apr 21, 2021 at 1:17 PM Giulio Casella <giu...@di.unimi.it> wrote:

> I tried, with no luck. Giving "disk snapshot id" as a parameter to that
> psql procedure nothing happened. Giving the "vm_snapshot_id" as found in
> the "images" table made the snapshot disappear from the gui, but not
> from the "images" table.
>
> SO I decided to look into DeleteSnapshot procedure, that resolve as:
>
> DELETE FROM snapshots WHERE snapshot_id = v_snapshot_id;
>
> It only acts on the "snapshots" table, and not on the "image" table,
> where the parentship between snapshots is still wrong.
>
> How safe is to manually modify "images" table and set correct parentship?
>
>
>
>
>
> On 20/04/2021 15:56, Shani Leviim wrote:
> > Thanks, Ritesh.
> >
> > In order to delete that snapshot, run this command on psql:
> > SELECT DeleteSnapshot('snapshot-id');
> >
> > *Regards,
> > *
> > *Shani Leviim
> > *
> >
> >
> > On Tue, Apr 20, 2021 at 3:25 PM Ritesh Chikatwar <rchik...@redhat.com
> > <mailto:rchik...@redhat.com>> wrote:
> >
> >     adding @Shani Leviim <mailto:slev...@redhat.com>
> >
> >     On Tue, Apr 20, 2021 at 5:35 PM Thomas Hoberg <tho...@hoberg.net
> >     <mailto:tho...@hoberg.net>> wrote:
> >
> >         I have used these tools to get rid of snapshots that wouldn't go
> >         away any other way:
> >
> https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities.html
> >         <
> https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities.html
> >
> >         _______________________________________________
> >         Users mailing list -- users@ovirt.org <mailto:users@ovirt.org>
> >         To unsubscribe send an email to users-le...@ovirt.org
> >         <mailto:users-le...@ovirt.org>
> >         Privacy Statement: https://www.ovirt.org/privacy-policy.html
> >         <https://www.ovirt.org/privacy-policy.html>
> >         oVirt Code of Conduct:
> >         https://www.ovirt.org/community/about/community-guidelines/
> >         <https://www.ovirt.org/community/about/community-guidelines/>
> >         List Archives:
> >
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/37K5J2X2OUDQKN5J3J7ISOV26FMTHCTY/
> >         <
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/37K5J2X2OUDQKN5J3J7ISOV26FMTHCTY/
> >
> >
> >
> > _______________________________________________
> > 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/LS3BUPQIVHQMG7I7C6IL7QTXJTJE7KCE/
> >
>
>
_______________________________________________
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/44NDDQMJIZX7M5P4IYKH5UZOGEL7QBE7/

Reply via email to