<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Hi Lionel,<br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">The error message you've mentioned sounds like a UI error.<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Can you please attach your ui log?<br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Also, on the data from 'images' table you've uploaded, can you describe which line is the relevant disk?<br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Finally (for now), in case the snapshot was deleted, can you please validate it by viewing the output of:<br>$ select * from snapshots;<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><span style="font-family:tahoma,sans-serif"><b>Regards,<br></b></span></div><span style="font-family:tahoma,sans-serif"><b>Shani Leviim<br></b></span></div></div></div></div></div>
<br><div class="gmail_quote">On Mon, Feb 26, 2018 at 9:20 AM, Lionel Caignec <span dir="ltr"><<a href="mailto:caignec@cines.fr" target="_blank">caignec@cines.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Shani,<br>
thank you for helping me with your reply,<br>
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.<br>
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?<br>
<br>
<br>
<br>
----- Mail original -----<br>
De: "Shani Leviim" <<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>><br>
À: "Lionel Caignec" <<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>><br>
Cc: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
Envoyé: Dimanche 25 Février 2018 14:26:41<br>
Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
<span class=""><br>
Hi Lionel,<br>
<br>
You can try to delete that snapshot directly from the database.<br>
<br>
In case of using psql [1], once you've logged in to your database, you can<br>
run this query:<br>
$ select * from snapshots where vm_id = '<your_vm_id>';<br>
This one would list the snapshots associated with a VM by its id.<br>
<br>
In case you don't have you vm_id, you can locate it by querying:<br>
$ select * from vms where vm_name = 'nil';<br>
This one would show you some details about a VM by its name (including the<br>
vm's id).<br>
<br>
Once you've found the relevant snapshot, you can delete it by running:<br>
$ delete from snapshots where snapshot_id = '<your_snapshot_id>';<br>
This one would delete the desired snapshot from the database.<br>
<br>
Since it's a delete operation, I would suggest confirming the ids before<br>
executing it.<br>
<br>
Hope you've found it useful!<br>
<br>
[1]<br>
<a href="https://www.ovirt.org/documentation/install-guide/appe-Preparing_a_Remote_PostgreSQL_Database_for_Use_with_the_oVirt_Engine/" rel="noreferrer" target="_blank">https://www.ovirt.org/<wbr>documentation/install-guide/<wbr>appe-Preparing_a_Remote_<wbr>PostgreSQL_Database_for_Use_<wbr>with_the_oVirt_Engine/</a><br>
<br>
<br>
</span>*Regards,*<br>
<br>
*Shani Leviim*<br>
<div class="HOEnZb"><div class="h5"><br>
On Fri, Feb 23, 2018 at 9:25 AM, Lionel Caignec <<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>> wrote:<br>
<br>
> Hi,<br>
><br>
> i've a problem with snapshot. On one VM i've a "snapshot" ghost without<br>
> name or uuid, only information is size (see attachment). In the snapshot<br>
> tab there is no trace about this disk.<br>
><br>
> In database (table images) i found this :<br>
> f242cc9a-56c1-4ae4-aef0-<wbr>f75eb01f74b1 | 2018-01-17 22:02:00+01 |<br>
> 2748779069440 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
> 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-01-18<br>
> 22:01:20.5+01 | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
> | 2 | 4 | 17e26476-cecb-441d-a5f7-<wbr>46ab3ef387ee |<br>
> 2018-01-17 22:01:29.663334+01 | 2018-01-19 08:40:14.345229+01 | f |<br>
> 1 | 2<br>
> 1c7650fa-542b-4ec2-83a1-<wbr>d2c1c31be5fd | 2018-01-17 22:02:03+01 |<br>
> 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
> 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-01-18<br>
> 22:01:20.84+01 | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
> | 2 | 4 | bf834a91-c69f-4d2c-b639-<wbr>116ed58296d8 |<br>
> 2018-01-17 22:01:29.836133+01 | 2018-01-19 08:40:19.083508+01 | f |<br>
> 1 | 2<br>
> 8614b21f-c0de-40f2-b4fb-<wbr>e5cf193b0743 | 2018-02-09 23:00:44+01 |<br>
> 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
> 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-02-16<br>
> 23:00:02.855+01 | 390175dc-baf4-4831-936a-<wbr>5ea68fa4c969<br>
><br>
><br>
> But i does not know which line is my disk. Is it possible to delete<br>
> directly into database?<br>
> Or is it better to dump my disk to another new and delete the "corrupted<br>
> one"?<br>
><br>
> Another thing, when i try to move the disk to another storage domain i<br>
> always get "uncaght exeption occured ..." and no error in engine.log.<br>
><br>
><br>
> Thank you for helping.<br>
><br>
> --<br>
> Lionel Caignec<br>
><br>
> ______________________________<wbr>_________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
><br>
><br>
</div></div></blockquote></div><br></div>