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.cec...@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 > >
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users