Add before the command (with your db password): PGPASSWORD=engine

for example:
PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -T

PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk -u engine -q

On Tue, Feb 21, 2017 at 12:23 PM, Gianluca Cecchi <gianluca.cecchi@gmail.com> wrote:

I see here utilitues:
https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities/

In particular unlock_entity.sh that should be of help in my case, as I see here:
http://lists.ovirt.org/pipermail/users/2015-April/032576.html

New path in 4.1 is now
/usr/share/ovirt-engine/setup/dbutils/
and not
/usr/share/ovirt-engine/dbscripts

Question:
How can I verify that "no jobs are still running over it"?
Is taskcleaner.sh the utility to crosscheck jobs?

In this case how do I provide a password for it?

[root@ovmgr1 ~]# /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -d engine -u engine
psql: fe_sendauth: no password supplied
FATAL: Cannot execute sql command: --command=select exists (select * from information_schema.tables where table_schema = 'public' and table_name = 'command_entities');
psql: fe_sendauth: no password supplied
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/setup/dbutils/taskcleaner_sp.sql

[root@ovmgr1 ~]# /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -h
Usage: /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh [options]

    -h            - This help text.
    -v            - Turn on verbosity                         (WARNING: lots of output)
    -l LOGFILE    - The logfile for capturing output          (def. )
    -s HOST       - The database servername for the database  (def. localhost)
    -p PORT       - The database port for the database        (def. 5432)
    -u USER       - The username for the database             (def. )
    -d DATABASE   - The database name                         (def. )
    -t TASK_ID    - Removes a task by its Task ID.
    -c COMMAND_ID - Removes all tasks related to the given Command Id.
    -T            - Removes/Displays all commands that have running tasks
    -o            - Removes/Displays all commands.
    -z            - Removes/Displays a Zombie task.
    -R            - Removes all tasks (use with -z to clear only zombie tasks).
    -r            - Removes all commands (use with -T to clear only those with running tasks. Use with -Z to clear only commands with zombie tasks.
    -Z            - Removes/Displays a command with zombie tasks.
    -C            - Clear related compensation entries.
    -J            - Clear related Job Steps.
    -A            - Clear all Job Steps and compensation entries.
    -q            - Quite mode, do not prompt for confirmation.

Thanks,
Gianluca