<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">Can you please share once again your engine log (or at least the relevant part where that error message occurred)?<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 Thu, Mar 8, 2018 at 1:56 PM, Lionel Caignec <span dir="ltr">&lt;<a href="mailto:caignec@cines.fr" target="_blank">caignec@cines.fr</a>&gt;</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 finished to move my data, but now when i want to remove my old disk i get stuck to this error :<br>
&quot;Cannot detach Virtual Machine Disk. The disk is already configured in a snapshot. In order to detach it, remove the disk&#39;s snapshots&quot;.<br>
But like i said before there is no snapshot anymore.<br>
So what can i do? Delete manually inside database? So where?<br>
Delete manually lvm volume, so how can i find the good one?<br>
<br>
Please help ;).<br>
<br>
Lionel<br>
<br>
----- Mail original -----<br>
De: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
À: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
Envoyé: Mardi 6 Mars 2018 08:22:30<br>
<div class="HOEnZb"><div class="h5">Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
<br>
Hi,<br>
<br>
ok thank you for information (sorry for late response).<br>
<br>
I will do that.<br>
<br>
----- Mail original -----<br>
De: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
À: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
Envoyé: Mardi 27 Février 2018 14:19:45<br>
Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
<br>
Hi Lionel,<br>
<br>
Sorry for the delay in replying you.<br>
<br>
If it&#39;s possible from your side, syncing the data and destroying old disk<br>
sounds about right.<br>
<br>
In addition, it seems like you&#39;re having this bug:<br>
<a href="https://bugzilla.redhat.com/show_bug.cgi?id=1509629" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1509629</a><br>
And it was fixed for version 4.1.9. and above.<br>
<br>
<br>
<br>
*Regards,*<br>
<br>
*Shani Leviim*<br>
<br>
On Mon, Feb 26, 2018 at 4:18 PM, Lionel Caignec &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt; wrote:<br>
<br>
&gt; Ok so i reply myself,<br>
&gt;<br>
&gt; Version is 4.1.7.6-1<br>
&gt;<br>
&gt; I just delete manually a snapshot previously created. But this is an io<br>
&gt; intensive vm, whit big disk (2,5To, and 5To).<br>
&gt;<br>
&gt; For the log, i cannot paste all my log on public list security reason, i<br>
&gt; will send you full in private.<br>
&gt; Here is an extract relevant to my error<br>
&gt; engine.log-20180210:2018-02-09 23:00:03,200+01 INFO<br>
&gt; [org.ovirt.engine.core.dal.<wbr>dbbroker.auditloghandling.<wbr>AuditLogDirector]<br>
&gt; (default task-312) [44402a8c-3196-43f0-ba33-<wbr>307ea78e6f49] EVENT_ID:<br>
&gt; USER_CREATE_SNAPSHOT(45), Correlation ID: 44402a8c-3196-43f0-ba33-<wbr>307ea78e6f49,<br>
&gt; Job ID: 030cd310-fec9-4a89-8c3f-<wbr>7888504fe973, Call Stack: null, Custom<br>
&gt; ID: null, Custom Event ID: -1, Message: Snapshot &#39;AUTO_7D_zz_nil_20180209_<wbr>220002&#39;<br>
&gt; creation for VM &#39;zz_nil&#39; was initiated by snap_user@internal.<br>
&gt; engine.log-20180210:2018-02-09 23:01:06,578+01 INFO<br>
&gt; [org.ovirt.engine.core.dal.<wbr>dbbroker.auditloghandling.<wbr>AuditLogDirector]<br>
&gt; (DefaultQuartzScheduler5) [] EVENT_ID: USER_CREATE_SNAPSHOT_FINISHED_<wbr>SUCCESS(68),<br>
&gt; Correlation ID: 44402a8c-3196-43f0-ba33-<wbr>307ea78e6f49, Job ID:<br>
&gt; 030cd310-fec9-4a89-8c3f-<wbr>7888504fe973, Call Stack: null, Custom ID: null,<br>
&gt; Custom Event ID: -1, Message: Snapshot &#39;AUTO_7D_zz_nil_20180209_<wbr>220002&#39;<br>
&gt; creation for VM &#39;zz_nil&#39; has been completed.<br>
&gt; engine.log-20180220:2018-02-19 17:01:23,800+01 INFO<br>
&gt; [org.ovirt.engine.core.dal.<wbr>dbbroker.auditloghandling.<wbr>AuditLogDirector]<br>
&gt; (default task-113) [] EVENT_ID: USER_REMOVE_SNAPSHOT(342), Correlation ID:<br>
&gt; 06a9efa4-1b80-4021-bf3e-<wbr>41ecebe58a88, Job ID: c9a918a7-b00c-43cf-b6de-<wbr>3659ac0765da,<br>
&gt; Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Snapshot<br>
&gt; &#39;AUTO_7D_zz_nil_20180209_<wbr>220002&#39; deletion for VM &#39;zz_nil&#39; was initiated<br>
&gt; by acaignec@ldap-cines-authz.<br>
&gt; engine.log-20180221:2018-02-20 22:24:45,174+01 ERROR<br>
&gt; [org.ovirt.engine.core.dal.<wbr>dbbroker.auditloghandling.<wbr>AuditLogDirector]<br>
&gt; (DefaultQuartzScheduler6) [06a9efa4-1b80-4021-bf3e-<wbr>41ecebe58a88]<br>
&gt; EVENT_ID: USER_REMOVE_SNAPSHOT_FINISHED_<wbr>FAILURE(357), Correlation ID:<br>
&gt; 06a9efa4-1b80-4021-bf3e-<wbr>41ecebe58a88, Job ID: c9a918a7-b00c-43cf-b6de-<wbr>3659ac0765da,<br>
&gt; Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Failed to<br>
&gt; delete snapshot &#39;AUTO_7D_zz_nil_20180209_<wbr>220002&#39; for VM &#39;zz_nil&#39;.<br>
&gt;  2018-02-20 22:24:46,266+01 INFO  [org.ovirt.engine.core.bll.<wbr>tasks.SPMAsyncTask]<br>
&gt; (DefaultQuartzScheduler3) [516079c3] SPMAsyncTask::PollTask: Polling task<br>
&gt; &#39;34137342-4f30-476d-b16c-<wbr>1cb7e0ea0ac0&#39; (Parent Command &#39;DestroyImage&#39;,<br>
&gt; Parameters Type &#39;org.ovirt.engine.core.common.<wbr>asynctasks.<wbr>AsyncTaskParameters&#39;)<br>
&gt; returned status &#39;finished&#39;, result &#39;success&#39;.<br>
&gt; 2018-02-20 22:24:46,267+01 INFO  [org.ovirt.engine.core.bll.<wbr>tasks.SPMAsyncTask]<br>
&gt; (DefaultQuartzScheduler3) [516079c3] BaseAsyncTask::<wbr>onTaskEndSuccess:<br>
&gt; Task &#39;34137342-4f30-476d-b16c-<wbr>1cb7e0ea0ac0&#39; (Parent Command<br>
&gt; &#39;DestroyImage&#39;, Parameters Type &#39;org.ovirt.engine.core.common.<wbr>asynctasks.<wbr>AsyncTaskParameters&#39;)<br>
&gt; ended successfully.<br>
&gt; 2018-02-20 22:24:46,268+01 INFO  [org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask]<br>
&gt; (DefaultQuartzScheduler3) [516079c3] CommandAsyncTask::<wbr>endActionIfNecessary:<br>
&gt; All tasks of command &#39;fe8c91f2-386b-4b3f-bbf3-<wbr>aeda8e9244c6&#39; has ended -&gt;<br>
&gt; executing &#39;endAction&#39;<br>
&gt; 2018-02-20 22:24:46,268+01 INFO  [org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask]<br>
&gt; (DefaultQuartzScheduler3) [516079c3] CommandAsyncTask::endAction: Ending<br>
&gt; action for &#39;1&#39; tasks (command ID: &#39;fe8c91f2-386b-4b3f-bbf3-<wbr>aeda8e9244c6&#39;):<br>
&gt; calling endAction &#39;.<br>
&gt; 2018-02-20 22:24:46,268+01 INFO  [org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask]<br>
&gt; (org.ovirt.thread.pool-6-<wbr>thread-20) [516079c3] CommandAsyncTask::<wbr>endCommandAction<br>
&gt; [within thread] context: Attempting to endAction &#39;DestroyImage&#39;,<br>
&gt; 2018-02-20 22:24:46,269+01 ERROR [org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask]<br>
&gt; (org.ovirt.thread.pool-6-<wbr>thread-20) [516079c3] [within thread]: endAction<br>
&gt; for action type DestroyImage threw an exception.:<br>
&gt; java.lang.NullPointerException<br>
&gt;         at org.ovirt.engine.core.bll.<wbr>tasks.CoCoAsyncTaskHelper.<br>
&gt; endAction(CoCoAsyncTaskHelper.<wbr>java:335) [bll.jar:]<br>
&gt;         at org.ovirt.engine.core.bll.<wbr>tasks.CommandCoordinatorImpl.<br>
&gt; endAction(<wbr>CommandCoordinatorImpl.java:<wbr>340) [bll.jar:]<br>
&gt;         at org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask.<br>
&gt; endCommandAction(<wbr>CommandAsyncTask.java:154) [bll.jar:]<br>
&gt;         at org.ovirt.engine.core.bll.<wbr>tasks.CommandAsyncTask.lambda$<br>
&gt; endActionIfNecessary$0(<wbr>CommandAsyncTask.java:106) [bll.jar:]<br>
&gt;         at org.ovirt.engine.core.utils.<wbr>threadpool.ThreadPoolUtil$<br>
&gt; InternalWrapperRunnable.run(<wbr>ThreadPoolUtil.java:84) [utils.jar:]<br>
&gt;         at java.util.concurrent.<wbr>Executors$RunnableAdapter.<wbr>call(Executors.java:511)<br>
&gt; [rt.jar:1.8.0_161]<br>
&gt;         at java.util.concurrent.<wbr>FutureTask.run(FutureTask.<wbr>java:266)<br>
&gt; [rt.jar:1.8.0_161]<br>
&gt;         at java.util.concurrent.<wbr>ThreadPoolExecutor.runWorker(<wbr>ThreadPoolExecutor.java:1149)<br>
&gt; [rt.jar:1.8.0_161]<br>
&gt;         at java.util.concurrent.<wbr>ThreadPoolExecutor$Worker.run(<wbr>ThreadPoolExecutor.java:624)<br>
&gt; [rt.jar:1.8.0_161]<br>
&gt;         at java.lang.Thread.run(Thread.<wbr>java:748) [rt.jar:1.8.0_161]<br>
&gt;<br>
&gt; ----- Mail original -----<br>
&gt; De: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
&gt; À: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; Envoyé: Lundi 26 Février 2018 14:42:38<br>
&gt; Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
&gt;<br>
&gt; Yes, please.<br>
&gt; Can you detail a bit more regarding the actions you&#39;ve done?<br>
&gt;<br>
&gt; I&#39;m assuming that since the snapshot had no description, trying to operate<br>
&gt; it caused the nullPointerException you&#39;ve got.<br>
&gt; But I want to examine what was the cause for that.<br>
&gt;<br>
&gt; Also, can you please answer back to the list?<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; *Regards,*<br>
&gt;<br>
&gt; *Shani Leviim*<br>
&gt;<br>
&gt; On Mon, Feb 26, 2018 at 3:37 PM, Lionel Caignec &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt; wrote:<br>
&gt;<br>
&gt; &gt; Version is 4.1.7.6-1<br>
&gt; &gt;<br>
&gt; &gt; Do you want the log from the day i delete snapshot?<br>
&gt; &gt;<br>
&gt; &gt; ----- Mail original -----<br>
&gt; &gt; De: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
&gt; &gt; À: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; &gt; Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
&gt; &gt; Envoyé: Lundi 26 Février 2018 14:29:16<br>
&gt; &gt; Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
&gt; &gt;<br>
&gt; &gt; Hi,<br>
&gt; &gt;<br>
&gt; &gt; What is your engine version, please?<br>
&gt; &gt; I&#39;m trying to reproduce your steps, for understanding better was is the<br>
&gt; &gt; cause for that error. Therefore, a full engine log is needed.<br>
&gt; &gt; Can you please attach it?<br>
&gt; &gt;<br>
&gt; &gt; Thanks,<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; *Shani Leviim*<br>
&gt; &gt;<br>
&gt; &gt; On Mon, Feb 26, 2018 at 2:48 PM, Lionel Caignec &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; wrote:<br>
&gt; &gt;<br>
&gt; &gt; &gt; Hi<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; 1) this is error message from ui.log<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;  2018-02-26 13:44:10,001+01 ERROR [org.ovirt.engine.ui.frontend.<br>
&gt; &gt; &gt; server.gwt.<wbr>OvirtRemoteLoggingService] (default task-3) [] Permutation<br>
&gt; &gt; &gt; name: 8C01181C3B121D0AAE1312275CC964<wbr>15<br>
&gt; &gt; &gt; 2018-02-26 13:44:10,001+01 ERROR [org.ovirt.engine.ui.frontend.<br>
&gt; &gt; server.gwt.<wbr>OvirtRemoteLoggingService]<br>
&gt; &gt; &gt; (default task-3) [] Uncaught exception: com.google.gwt.core.client.<br>
&gt; &gt; JavaScriptException:<br>
&gt; &gt; &gt; (TypeError)<br>
&gt; &gt; &gt;  __gwt$exception: &lt;skipped&gt;: Cannot read property &#39;F&#39; of null<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.<wbr>uicommonweb.models.storage.<br>
&gt; &gt; &gt; DisksAllocationModel$3.$<wbr>onSuccess(<wbr>DisksAllocationModel.java:120)<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.<wbr>uicommonweb.models.storage.<br>
&gt; &gt; &gt; DisksAllocationModel$3.<wbr>onSuccess(<wbr>DisksAllocationModel.java:120)<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>Frontend$2.$onSuccess(<br>
&gt; &gt; Frontend.java:233)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>Frontend$2.onSuccess(Frontend.<br>
&gt; &gt; java:233)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>communication.<br>
&gt; &gt; &gt; OperationProcessor$2.$<wbr>onSuccess(OperationProcessor.<wbr>java:139)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>communication.<br>
&gt; &gt; &gt; OperationProcessor$2.<wbr>onSuccess(OperationProcessor.<wbr>java:139)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>communication.<br>
&gt; &gt; &gt; GWTRPCCommunicationProvider$5$<wbr>1.$onSuccess(<br>
&gt; GWTRPCCommunicationProvider.<br>
&gt; &gt; java:269)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at org.ovirt.engine.ui.frontend.<wbr>communication.<br>
&gt; &gt; &gt; GWTRPCCommunicationProvider$5$<wbr>1.onSuccess(<wbr>GWTRPCCommunicationProvider.<br>
&gt; &gt; java:269)<br>
&gt; &gt; &gt; [frontend.jar:]<br>
&gt; &gt; &gt;         at com.google.gwt.user.client.<wbr>rpc.impl.<wbr>RequestCallbackAdapter.<br>
&gt; &gt; &gt; onResponseReceived(<wbr>RequestCallbackAdapter.java:<wbr>198) [gwt-servlet.jar:]<br>
&gt; &gt; &gt;         at com.google.gwt.http.client.<wbr>Request.$<wbr>fireOnResponseReceived(<br>
&gt; &gt; Request.java:237)<br>
&gt; &gt; &gt; [gwt-servlet.jar:]<br>
&gt; &gt; &gt;         at com.google.gwt.http.client.<wbr>RequestBuilder$1.<br>
&gt; &gt; onReadyStateChange(<wbr>RequestBuilder.java:409)<br>
&gt; &gt; &gt; [gwt-servlet.jar:]<br>
&gt; &gt; &gt;         at Unknown.eval(webadmin-0.js@65)<br>
&gt; &gt; &gt;         at com.google.gwt.core.client.<wbr>impl.Impl.apply(Impl.java:296)<br>
&gt; &gt; &gt; [gwt-servlet.jar:]<br>
&gt; &gt; &gt;         at com.google.gwt.core.client.<wbr>impl.Impl.entry0(Impl.java:<wbr>335)<br>
&gt; &gt; &gt; [gwt-servlet.jar:]<br>
&gt; &gt; &gt;         at Unknown.eval(webadmin-0.js@54)<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; 2) This line seems to be about the bad disk :<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;  f242cc9a-56c1-4ae4-aef0-<wbr>f75eb01f74b1 | 2018-01-17 22:02:00+01 |<br>
&gt; &gt; &gt; 2748779069440 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
&gt; &gt; &gt; 00000000-0000-0000-0000-<wbr>000000000000 |           4 | 2018-01-18<br>
&gt; &gt; &gt; 22:01:20.5+01   | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; 3) Snapshot table is empty for the concerned vm_id.<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; ----- Mail original -----<br>
&gt; &gt; &gt; De: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
&gt; &gt; &gt; À: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; &gt; &gt; Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
&gt; &gt; &gt; Envoyé: Lundi 26 Février 2018 13:31:23<br>
&gt; &gt; &gt; Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; Hi Lionel,<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; The error message you&#39;ve mentioned sounds like a UI error.<br>
&gt; &gt; &gt; Can you please attach your ui log?<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; Also, on the data from &#39;images&#39; table you&#39;ve uploaded, can you describe<br>
&gt; &gt; &gt; which line is the relevant disk?<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; Finally (for now), in case the snapshot was deleted, can you please<br>
&gt; &gt; &gt; validate it by viewing the output of:<br>
&gt; &gt; &gt; $ select * from snapshots;<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; *Regards,*<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; *Shani Leviim*<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; On Mon, Feb 26, 2018 at 9:20 AM, Lionel Caignec &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; &gt; wrote:<br>
&gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; Hi Shani,<br>
&gt; &gt; &gt; &gt; thank you for helping me with your reply,<br>
&gt; &gt; &gt; &gt; i juste make a little mistake on explanation. In fact it&#39;s the<br>
&gt; snapshot<br>
&gt; &gt; &gt; &gt; does not exist anymore. This is the disk(s) relative to her wich<br>
&gt; still<br>
&gt; &gt; &gt; &gt; exist, and perhaps LVM volume.<br>
&gt; &gt; &gt; &gt; So can i delete manually this disk in database? what about the lvm<br>
&gt; &gt; &gt; volume?<br>
&gt; &gt; &gt; &gt; Is it better to recreate disk sync data and destroy old one?<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; ----- Mail original -----<br>
&gt; &gt; &gt; &gt; De: &quot;Shani Leviim&quot; &lt;<a href="mailto:sleviim@redhat.com">sleviim@redhat.com</a>&gt;<br>
&gt; &gt; &gt; &gt; À: &quot;Lionel Caignec&quot; &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; &gt; &gt; &gt; Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
&gt; &gt; &gt; &gt; Envoyé: Dimanche 25 Février 2018 14:26:41<br>
&gt; &gt; &gt; &gt; Objet: Re: [ovirt-users] Ghost Snapshot Disk<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; Hi Lionel,<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; You can try to delete that snapshot directly from the database.<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; In case of using psql  [1], once you&#39;ve logged in to your database,<br>
&gt; you<br>
&gt; &gt; &gt; can<br>
&gt; &gt; &gt; &gt; run this query:<br>
&gt; &gt; &gt; &gt; $ select * from snapshots where vm_id = &#39;&lt;your_vm_id&gt;&#39;;<br>
&gt; &gt; &gt; &gt; This one would list the snapshots associated with a VM by its id.<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; In case you don&#39;t have you vm_id, you can locate it by querying:<br>
&gt; &gt; &gt; &gt; $ select * from vms where vm_name = &#39;nil&#39;;<br>
&gt; &gt; &gt; &gt; This one would show you some details about a VM by its name<br>
&gt; (including<br>
&gt; &gt; &gt; the<br>
&gt; &gt; &gt; &gt; vm&#39;s id).<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; Once you&#39;ve found the relevant snapshot, you can delete it by<br>
&gt; running:<br>
&gt; &gt; &gt; &gt; $ delete from snapshots where snapshot_id = &#39;&lt;your_snapshot_id&gt;&#39;;<br>
&gt; &gt; &gt; &gt; This one would delete the desired snapshot from the database.<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; Since it&#39;s a delete operation, I would suggest confirming the ids<br>
&gt; &gt; before<br>
&gt; &gt; &gt; &gt; executing it.<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; Hope you&#39;ve found it useful!<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; [1]<br>
&gt; &gt; &gt; &gt; <a href="https://www.ovirt.org/documentation/install-guide/" rel="noreferrer" target="_blank">https://www.ovirt.org/<wbr>documentation/install-guide/</a><br>
&gt; &gt; &gt; appe-Preparing_a_Remote_<br>
&gt; &gt; &gt; &gt; PostgreSQL_Database_for_Use_<wbr>with_the_oVirt_Engine/<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; *Regards,*<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; *Shani Leviim*<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; On Fri, Feb 23, 2018 at 9:25 AM, Lionel Caignec &lt;<a href="mailto:caignec@cines.fr">caignec@cines.fr</a>&gt;<br>
&gt; &gt; &gt; wrote:<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt; Hi,<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt; i&#39;ve a problem with snapshot. On one VM i&#39;ve a &quot;snapshot&quot; ghost<br>
&gt; &gt; without<br>
&gt; &gt; &gt; &gt; &gt; name or uuid, only information is size (see attachment). In the<br>
&gt; &gt; &gt; snapshot<br>
&gt; &gt; &gt; &gt; &gt; tab there is no trace about this disk.<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt; In database (table images) i found this :<br>
&gt; &gt; &gt; &gt; &gt;   f242cc9a-56c1-4ae4-aef0-<wbr>f75eb01f74b1 | 2018-01-17 22:02:00+01 |<br>
&gt; &gt; &gt; &gt; &gt; 2748779069440 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
&gt; &gt; &gt; &gt; &gt; 00000000-0000-0000-0000-<wbr>000000000000 |           4 | 2018-01-18<br>
&gt; &gt; &gt; &gt; &gt; 22:01:20.5+01   | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
&gt; &gt; &gt; &gt; &gt;  |           2 |             4 | 17e26476-cecb-441d-a5f7-<br>
&gt; &gt; 46ab3ef387ee<br>
&gt; &gt; &gt; |<br>
&gt; &gt; &gt; &gt; &gt; 2018-01-17 22:01:29.663334+01 | 2018-01-19 08:40:14.345229+01 | f<br>
&gt; &gt; &gt; |<br>
&gt; &gt; &gt; &gt; &gt;                  1 |           2<br>
&gt; &gt; &gt; &gt; &gt;  1c7650fa-542b-4ec2-83a1-<wbr>d2c1c31be5fd | 2018-01-17 22:02:03+01 |<br>
&gt; &gt; &gt; &gt; &gt; 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
&gt; &gt; &gt; &gt; &gt; 00000000-0000-0000-0000-<wbr>000000000000 |           4 | 2018-01-18<br>
&gt; &gt; &gt; &gt; &gt; 22:01:20.84+01  | 0dd2090c-3491-4fa1-98c3-<wbr>54ae88be793c<br>
&gt; &gt; &gt; &gt; &gt;  |           2 |             4 | bf834a91-c69f-4d2c-b639-<br>
&gt; &gt; 116ed58296d8<br>
&gt; &gt; &gt; |<br>
&gt; &gt; &gt; &gt; &gt; 2018-01-17 22:01:29.836133+01 | 2018-01-19 08:40:19.083508+01 | f<br>
&gt; &gt; &gt; |<br>
&gt; &gt; &gt; &gt; &gt;                  1 |           2<br>
&gt; &gt; &gt; &gt; &gt;  8614b21f-c0de-40f2-b4fb-<wbr>e5cf193b0743 | 2018-02-09 23:00:44+01 |<br>
&gt; &gt; &gt; &gt; &gt; 5368709120000 | 00000000-0000-0000-0000-<wbr>000000000000 |<br>
&gt; &gt; &gt; &gt; &gt; 00000000-0000-0000-0000-<wbr>000000000000 |           4 | 2018-02-16<br>
&gt; &gt; &gt; &gt; &gt; 23:00:02.855+01 | 390175dc-baf4-4831-936a-<wbr>5ea68fa4c969<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;  But i does not know which line is my disk. Is it possible to<br>
&gt; delete<br>
&gt; &gt; &gt; &gt; &gt; directly into database?<br>
&gt; &gt; &gt; &gt; &gt;  Or is it better to dump my disk to another new and delete the<br>
&gt; &gt; &gt; &quot;corrupted<br>
&gt; &gt; &gt; &gt; &gt; one&quot;?<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;  Another thing, when i try to move the disk to another storage<br>
&gt; &gt; domain i<br>
&gt; &gt; &gt; &gt; &gt; always get &quot;uncaght exeption occured ...&quot; and no error in<br>
&gt; engine.log.<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;  Thank you for helping.<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt; --<br>
&gt; &gt; &gt; &gt; &gt; Lionel Caignec<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt; ______________________________<wbr>_________________<br>
&gt; &gt; &gt; &gt; &gt; Users mailing list<br>
&gt; &gt; &gt; &gt; &gt; <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
&gt; &gt; &gt; &gt; &gt; <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt; &gt;<br>
&gt; &gt; &gt;<br>
&gt; &gt;<br>
&gt;<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>
</div></div></blockquote></div><br></div>