<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">You can try to delete that snapshot directly from the database.<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br>In case of using psql [1], once you've logged in to your database, you can run this query:<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">$ select * from snapshots where vm_id = '<your_vm_id>';<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">This one would list the snapshots associated with a VM by its id. <br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">In case you don't have you vm_id, you can locate it by querying: <br>$ select * from vms where vm_name = 'nil';<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">This one would show you some details about a VM by its name (including the vm's id).<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Once you've found the relevant snapshot, you can delete it by running:<br>$ delete from snapshots where snapshot_id = '<your_snapshot_id>';<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">This one would delete the desired snapshot from the database.<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Since it's a delete operation, I would suggest confirming the ids before executing it.<br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Hope you've found it useful!<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br>[1] <a href="https://www.ovirt.org/documentation/install-guide/appe-Preparing_a_Remote_PostgreSQL_Database_for_Use_with_the_oVirt_Engine/">https://www.ovirt.org/documentation/install-guide/appe-Preparing_a_Remote_PostgreSQL_Database_for_Use_with_the_oVirt_Engine/</a><br></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 Fri, Feb 23, 2018 at 9:25 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,<br>
<br>
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.<br>
<br>
In database (table images) i found this :<br>
f242cc9a-56c1-4ae4-aef0-<wbr>f75eb01f74b1 | 2018-01-17 22:02:00+01 | 2748779069440 | 00000000-0000-0000-0000-<wbr>000000000000 | 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-01-18 22:01:20.5+01 | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
| 2 | 4 | 17e26476-cecb-441d-a5f7-<wbr>46ab3ef387ee | 2018-01-17 22:01:29.663334+01 | 2018-01-19 08:40:14.345229+01 | f | 1 | 2<br>
1c7650fa-542b-4ec2-83a1-<wbr>d2c1c31be5fd | 2018-01-17 22:02:03+01 | 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 | 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-01-18 22:01:20.84+01 | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
| 2 | 4 | bf834a91-c69f-4d2c-b639-<wbr>116ed58296d8 | 2018-01-17 22:01:29.836133+01 | 2018-01-19 08:40:19.083508+01 | f | 1 | 2<br>
8614b21f-c0de-40f2-b4fb-<wbr>e5cf193b0743 | 2018-02-09 23:00:44+01 | 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 | 00000000-0000-0000-0000-<wbr>000000000000 | 4 | 2018-02-16 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 directly into database?<br>
Or is it better to dump my disk to another new and delete the "corrupted one"?<br>
<br>
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.<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></blockquote></div><br></div></div>