[ovirt-users] Ghost Snapshot Disk

[Shani Leviim]

Hi Lionel,

The error message you've mentioned sounds like a UI error.
Can you please attach your ui log?

Also, on the data from 'images' table you've uploaded, can you describe
which line is the relevant disk?

Finally (for now), in case the snapshot was deleted, can you please
validate it by viewing the output of:
$ select * from snapshots;



*Regards,*

*Shani Leviim*

On Mon, Feb 26, 2018 at 9:20 AM, Lionel Caignec <caignec at cines.fr> wrote:

> Hi Shani,
> thank you for helping me with your reply,
> i juste make a little mistake on explanation. In fact it's the snapshot
> does not exist anymore. This is the disk(s) relative to her wich still
> exist, and perhaps LVM volume.
> So can i delete manually this disk in database? what about the lvm volume?
> Is it better to recreate disk sync data and destroy old one?
>
>
>
> ----- Mail original -----
> De: "Shani Leviim" <sleviim at redhat.com>
> À: "Lionel Caignec" <caignec at cines.fr>
> Cc: "users" <users at ovirt.org>
> Envoyé: Dimanche 25 Février 2018 14:26:41
> Objet: Re: [ovirt-users] Ghost Snapshot Disk
>
> Hi Lionel,
>
> You can try to delete that snapshot directly from the database.
>
> In case of using psql  [1], once you've logged in to your database, you can
> run this query:
> $ select * from snapshots where vm_id = '<your_vm_id>';
> This one would list the snapshots associated with a VM by its id.
>
> In case you don't have you vm_id, you can locate it by querying:
> $ select * from vms where vm_name = 'nil';
> This one would show you some details about a VM by its name (including the
> vm's id).
>
> Once you've found the relevant snapshot, you can delete it by running:
> $ delete from snapshots where snapshot_id = '<your_snapshot_id>';
> This one would delete the desired snapshot from the database.
>
> Since it's a delete operation, I would suggest confirming the ids before
> executing it.
>
> Hope you've found it useful!
>
> [1]
> https://www.ovirt.org/documentation/install-guide/appe-Preparing_a_Remote_
> PostgreSQL_Database_for_Use_with_the_oVirt_Engine/
>
>
> *Regards,*
>
> *Shani Leviim*
>
> On Fri, Feb 23, 2018 at 9:25 AM, Lionel Caignec <caignec at cines.fr> wrote:
>
> > Hi,
> >
> > i've a problem with snapshot. On one VM i've a "snapshot" ghost without
> > name or uuid, only information is size (see attachment). In the snapshot
> > tab there is no trace about this disk.
> >
> > In database (table images) i found this :
> >   f242cc9a-56c1-4ae4-aef0-f75eb01f74b1 | 2018-01-17 22:02:00+01 |
> > 2748779069440 | 00000000-0000-0000-0000-000000000000 |
> > 00000000-0000-0000-0000-000000000000 |           4 | 2018-01-18
> > 22:01:20.5+01   | 0dd2090c-3491-4fa1-98c3-54ae88be793c
> >  |           2 |             4 | 17e26476-cecb-441d-a5f7-46ab3ef387ee |
> > 2018-01-17 22:01:29.663334+01 | 2018-01-19 08:40:14.345229+01 | f      |
> >                  1 |           2
> >  1c7650fa-542b-4ec2-83a1-d2c1c31be5fd | 2018-01-17 22:02:03+01 |
> > 5368709120000 | 00000000-0000-0000-0000-000000000000 |
> > 00000000-0000-0000-0000-000000000000 |           4 | 2018-01-18
> > 22:01:20.84+01  | 0dd2090c-3491-4fa1-98c3-54ae88be793c
> >  |           2 |             4 | bf834a91-c69f-4d2c-b639-116ed58296d8 |
> > 2018-01-17 22:01:29.836133+01 | 2018-01-19 08:40:19.083508+01 | f      |
> >                  1 |           2
> >  8614b21f-c0de-40f2-b4fb-e5cf193b0743 | 2018-02-09 23:00:44+01 |
> > 5368709120000 | 00000000-0000-0000-0000-000000000000 |
> > 00000000-0000-0000-0000-000000000000 |           4 | 2018-02-16
> > 23:00:02.855+01 | 390175dc-baf4-4831-936a-5ea68fa4c969
> >
> >
> >  But i does not know which line is my disk. Is it possible to delete
> > directly into database?
> >  Or is it better to dump my disk to another new and delete the "corrupted
> > one"?
> >
> >  Another thing, when i try to move the disk to another storage domain i
> > always get "uncaght exeption occured ..." and no error in engine.log.
> >
> >
> >  Thank you for helping.
> >
> > --
> > Lionel Caignec
> >
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180226/dddb25de/attachment.html>