<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Fri, Nov 10, 2017 at 3:34 PM, <span dir="ltr"><<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">oVirt upgrade to 4.1.7 will probably cleanup this stale task. However, if you want to do it before upgrading, run this command:<br>
<br>
PGPASSWORD=... /usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -t all -u engine<br>
<br>
Note that unlock_entity.sh has many flags and this is just an example (should clean all stale tasks).<br>
<br>
You can find the PGPASSWORD value in the /etc/ovirt-engine/engine.conf.<wbr>d/10-setup-database.conf file. As of 4.2 you won't need to supply credentials anymore [1].<br>
<br>
Regards,<br>
<br>
Nicolás<br></blockquote><div><br></div><div><br></div><div>It seems it didn't work as expected.</div><div>I got this at command line output</div><div><br></div><div>"</div><div><div>select fn_db_unlock_all();</div><div> </div><div><br></div><div>INSERT 0 1</div><div>unlock all completed successfully.</div></div><div>"</div><div><br></div><div>But the task remains in webadmin gui and I got an alert message in alert section, of this type</div><div>"</div><div>/usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh : System user
root run manually unlock_entity script on entity [type,id] [all,] with
db user engine</div><div>"</div><div><br></div><div>Gianluca</div><div><br></div><div><br></div></div></div></div>