[ovirt-users] moving disk failed.. remained locked

[Fred Rolland]

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 at 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 at 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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170221/9b315cbb/attachment-0001.html>