<div dir="ltr">Add before the command (with your db password): PGPASSWORD=engine<br><br>for example:<br>PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -T<br><br>PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk -u engine -q<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Feb 21, 2017 at 12:23 PM, Gianluca Cecchi <span dir="ltr"><<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.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"><br><div>I see here utilitues:</div><div><a href="https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities/" target="_blank">https://www.ovirt.org/develop/<wbr>developer-guide/db-issues/<wbr>helperutilities/</a><br></div><div><br></div><div>In particular unlock_entity.sh that should be of help in my case, as I see here:</div><div><a href="http://lists.ovirt.org/pipermail/users/2015-April/032576.html" target="_blank">http://lists.ovirt.org/<wbr>pipermail/users/2015-April/<wbr>032576.html</a><br></div><div><br></div><div>New path in 4.1 is now</div><div>/usr/share/ovirt-engine/setup/<wbr>dbutils/<br></div><div>and not</div><div>/usr/share/ovirt-engine/<wbr>dbscripts<br></div><div><br></div><div>Question:</div><div>How can I verify that "no jobs are still running over it"?</div><div>Is taskcleaner.sh the utility to crosscheck jobs?</div><div><br></div><div>In this case how do I provide a password for it?</div><div><br></div><div><div>[root@ovmgr1 ~]# /usr/share/ovirt-engine/setup/<wbr>dbutils/taskcleaner.sh -d engine -u engine</div><div>psql: fe_sendauth: no password supplied</div><div>FATAL: Cannot execute sql command: --command=select exists (select * from information_schema.tables where table_schema = 'public' and table_name = 'command_entities');</div><div>psql: fe_sendauth: no password supplied</div><div>FATAL: Cannot execute sql command: --file=/usr/share/ovirt-<wbr>engine/setup/dbutils/<wbr>taskcleaner_sp.sql</div></div><div><br></div><div><div>[root@ovmgr1 ~]# /usr/share/ovirt-engine/setup/<wbr>dbutils/taskcleaner.sh -h</div><div>Usage: /usr/share/ovirt-engine/setup/<wbr>dbutils/taskcleaner.sh [options]</div><div><br></div><div> -h - This help text.</div><div> -v - Turn on verbosity (WARNING: lots of output)</div><div> -l LOGFILE - The logfile for capturing output (def. )</div><div> -s HOST - The database servername for the database (def. localhost)</div><div> -p PORT - The database port for the database (def. 5432)</div><div> -u USER - The username for the database (def. )</div><div> -d DATABASE - The database name (def. )</div><div> -t TASK_ID - Removes a task by its Task ID.</div><div> -c COMMAND_ID - Removes all tasks related to the given Command Id.</div><div> -T - Removes/Displays all commands that have running tasks</div><div> -o - Removes/Displays all commands.</div><div> -z - Removes/Displays a Zombie task.</div><div> -R - Removes all tasks (use with -z to clear only zombie tasks).</div><div> -r - Removes all commands (use with -T to clear only those with running tasks. Use with -Z to clear only commands with zombie tasks.</div><div> -Z - Removes/Displays a command with zombie tasks.</div><div> -C - Clear related compensation entries.</div><div> -J - Clear related Job Steps.</div><div> -A - Clear all Job Steps and compensation entries.</div><div> -q - Quite mode, do not prompt for confirmation.</div><div><br></div></div><div>Thanks,</div><div>Gianluca</div><div><br></div></div>
</blockquote></div><br></div>