On Mon, Jan 31, 2022 at 7:29 PM Nathanaël Blanchet <blanc...@abes.fr> wrote:
>
>

> it doesn't seem to exist:
>
>
>     image:    ba2efe1a-8b83-4406-8711-7120b4bd11d0
>
>               - 08966754-0bb6-4c88-9ad6-35d6242fa380
>                 status: OK, voltype: LEAF, format: RAW, legality: LEGAL,
> type: PREALLOCATED, capacity: 219982856192, truesize: 219982856192
Is this the entire output? I assume not


> >
> > And checking what the chain looks like there.
> >
> > In theory it's possible to remove them from the database, but the
> > relationships between the images would need to be fixed as well, as
> > both images you mentioned have children
> okay, tell me how to remove them from the DB please.

you can remove it using the image_guid, please check the a snapshot
with their vm_snapshot_id does not exist in the snapshots table.
image 109fac1e-c2e3-4ba6-9867-5d1c94d3a447 is the child of
60087f63-6237-4419-a5dd-9a48c84c1c43 which is going to be removed, so
the chain needs to be fixed by updating
the parent to 379db97c-bfe1-4804-9b1f-576050efdcd3 which is the parent
of 60087f63-6237-4419-a5dd-9a48c84c1c43, and would be something like
this:

    UPDATE images
    SET parentid = '379db97c-bfe1-4804-9b1f-576050efdcd3'
    WHERE image_guid = '109fac1e-c2e3-4ba6-9867-5d1c94d3a447';

of course this should done carefully after backing up the database
_______________________________________________
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/NQANLFAFOQ2W3M3POT5JHU4CZGS5HFLI/

Reply via email to