<div dir="ltr">Hi Jim,<div><br></div><div>You can try the taskcleaner script on dbutils. </div><div>For instance: <br></div><div># PGPASSWORD={pass} ./taskcleaner.sh -u engine -d engine -t {disk,snapshot} -z<br></div><div><br></div><div>I recommend you to check all the options available for it.</div><div><br></div><div>Cheers,</div><div>Gonza.-</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 25, 2017 at 5:58 PM, Jim Kusznir <span dir="ltr"><<a href="mailto:jim@palousetech.com" target="_blank">jim@palousetech.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">(sorry. e-mail client sent message prematurely)<div><br></div><div>Ok, I figured out that this needs to be run on the engine, I figured out that PGPASSWORD is the postgres password, and I finally figured out that the db password is stored in:<br></div><div>/etc/ovirt-engine/engine.conf.<wbr>d/10-setup-database.conf<br></div><div><br></div><div>Unfortunately, when I run the command provided, I get just an empty line back, no UUIDs.</div><div><br></div><div>I looked in the gui, under the disks tab and found the ID there. I ran the command on the two UUIDs for the two disks in question:</div><div><br></div><div><div>[root@ovirt ~]# PGPASSWORD=<deleted> /usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -q -t disk -u engine</div><div><br></div><div>[root@ovirt ~]# PGPASSWORD=<deleted> /usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -t snapshot -u engine 405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0</div><div>Caution, this operation may lead to data corruption and should be used with care. Please contact support prior to running this command</div><div>Are you sure you want to proceed? [y/n]</div><div>y</div><div>select fn_db_unlock_snapshot('<wbr>405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0');</div><div> </div><div><br></div><div>INSERT 0 1</div><div>unlock snapshot 405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0 completed successfully.</div><div>[root@ovirt ~]# PGPASSWORD=<deleted> /usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -t snapshot -u engine eada2c1c-1d99-4391-9be3-<wbr>352c411a0a91</div><div>Caution, this operation may lead to data corruption and should be used with care. Please contact support prior to running this command</div><div>Are you sure you want to proceed? [y/n]</div><div>y</div><div>select fn_db_unlock_snapshot('<wbr>eada2c1c-1d99-4391-9be3-<wbr>352c411a0a91');</div><div> </div><div><br></div><div>INSERT 0 1</div><div>unlock snapshot eada2c1c-1d99-4391-9be3-<wbr>352c411a0a91 completed successfully.</div></div><div><br></div><div>Unfortunately, this doesn't appear to have accomplished anything. In the web UI, the disks are still shown as locked, and the tasks are still shown as pending.</div><div><br></div><div>I logged into a host node and found the directory by the same UUID:</div><div><br></div><div><div>root@ovirt1 images]# cd 405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0/</div><div>[root@ovirt1 405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0]# ls</div><div>8e4a02a7-760b-478c-a694-<wbr>81466d601356 8e4a02a7-760b-478c-a694-<wbr>81466d601356.lease 8e4a02a7-760b-478c-a694-<wbr>81466d601356.meta</div><div>[root@ovirt1 405fabe0-873c-4e8e-ae10-<wbr>9990debf96c0]# du -sh</div><div>514M<span class="m_2190683926387498119gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>.</div></div><div><br></div><div><br></div><div>I'm assuming I should NOT just rm these files and the containing directory....</div><div><br></div><div>Suggestions moving forward?</div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 25, 2017 at 8:50 AM, Jim Kusznir <span dir="ltr"><<a href="mailto:jim@palousetech.com" target="_blank">jim@palousetech.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Ok, I figured out that this needs to be run on the engine, I figured out that PGPASSWORD</div><div class="gmail_extra"><br><div class="gmail_quote"><span>On Tue, Apr 4, 2017 at 2:02 AM, Nathanaël Blanchet <span dir="ltr"><<a href="mailto:blanchet@abes.fr" target="_blank">blanchet@abes.fr</a>></span> wrote:<br></span><div><div class="m_2190683926387498119h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<p>For instance<br>
</p>
<p>PGPASSWORD=XXXXX
/usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -q -t disk
-u engine<br>
296c010e-3c1d-4008-84b3-5cd39c<wbr>ff6aa1 |
525a4dda-dbbb-4872-a5f1-8ac2ae<wbr>d48392<br>
</p>
<p>PGPASSWORD=XXXXX
/usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -t snapshot
-u engine 525a4dda-dbbb-4872-a5f1-8ac2ae<wbr>d48392</p><div><div class="m_2190683926387498119m_-8563667247929861497h5">
<br>
<div class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772moz-cite-prefix">Le 01/04/2017 à 19:55, Jim Kusznir a
écrit :<br>
</div>
</div></div><blockquote type="cite"><div><div class="m_2190683926387498119m_-8563667247929861497h5">
<div dir="ltr">Hi:
<div><br>
</div>
<div>A few days ago I attempted to create a new VM from one of
the ovirt-image-repository images. I haven't really figured
out how to use this reliably yet, and in this case, while
trying to import an image, one of my nodes spontaneously
rebooted (or at least, it looked like that to ovirt...Not sure
if it had an OOM issue or something else). I assume it was
the node that got the task of importing those images, as ever
since then (several days now), on my management screen under
"Tasks" it shows the attempted imports, still stuck in
"processing". I'm quite certain its not actually processing.
I do believe it used some of my storage up in the partially
downloaded images, though (they do show up as
GlanceDisk-<numbers>, with a status of "Locked" under
the main Disks tab.</div>
<div><br>
</div>
<div>How do I "properly" recover from this (abort the task and
delete the partial download)?</div>
<div><br>
</div>
<div>Thanks!</div>
<div><br>
</div>
<div>--Jim</div>
</div>
<br>
<fieldset class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772mimeAttachmentHeader"></fieldset>
<br>
</div></div><pre>______________________________<wbr>_________________
Users mailing list
<a class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772moz-txt-link-abbreviated" href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>
<a class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><span class="m_2190683926387498119m_-8563667247929861497HOEnZb"><font color="#888888">
</font></span></pre><span class="m_2190683926387498119m_-8563667247929861497HOEnZb"><font color="#888888">
</font></span></blockquote><span class="m_2190683926387498119m_-8563667247929861497HOEnZb"><font color="#888888">
<br>
<pre class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772moz-signature" cols="72">--
Nathanaël Blanchet
Supervision réseau
Pôle Infrastrutures Informatiques
227 avenue Professeur-Jean-Louis-Viala
34193 MONTPELLIER CEDEX 5
Tél. 33 (0)4 67 54 84 55
Fax 33 (0)4 67 54 84 14
<a class="m_2190683926387498119m_-8563667247929861497m_-7704600983972915772moz-txt-link-abbreviated" href="mailto:blanchet@abes.fr" target="_blank">blanchet@abes.fr</a> </pre>
</font></span></div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div>
</div></div><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>