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