Thank you.
Unfortunately, this is still an issue.
I have indeed tried running the taskcleaner.sh script, but I just tried it again.
[root@ovirt-engine1 dwhite]# PGPASSWORD=password /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R
t
This will remove all async_tasks table content!!!
Caution, this operation should be used with care. Please contact support prior to running this command
Are you sure you want to proceed? [y/n]
y
TRUNCATE TABLE
I then ran a select * from async_tasks... and we can confirm that there's zero rows:
engine=# SELECT * from async_tasks;
task_id | action_type | status | result | step_id | command_id | started_at | storage_pool_id | task_type | vdsm_task_id | root_command_id | user_id
---------+-------------+--------+--------+---------+------------+------------+-----------------+-----------+--------------+-----------------+---------
(0 rows)
I'm still unclear what SPM is.
I ran that command on the "problematic" host, and I get this stdout,
[root@cha1-storage]# vdsm-client Host getAllTasksStatuses
vdsm-client: Command Host.getAllTasksStatuses with args {} failed:
(code=654, message=Not SPM: ())
And finally, I tried Strahil's suggestion:
[root@ovirt-engine1 dwhite]# PGPASSWORD=password /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t all -r
##########################################
CAUTION, this operation may lead to data corruption and should be used with care. Please contact support prior to running this command
##########################################
Are you sure you want to proceed? [y/n]
y
select fn_db_unlock_all();
INSERT 0 1
unlock all completed successfully.
Unfortunately, I'm still getting the same error message in the admin UI with the 3 disks listed as "image transfer in progress".
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, October 17th, 2021 at 5:34 AM, Shani Leviim <sleviim@redhat.com> wrote:
Hi David,
Have you tried running the taskcleaner script with the updated password?
$ PGPASSWORD=xxxxxx /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R
You can also verify if the SPM itself has some locked tasks by running on it:
vdsm-client Host getAllTasksStatuses
Then clear those tasks:
vdsm-client Task clear taskID=12345
To verify there are no more async tasks, you can run this SQL query on the engine:
engine=# select * from async_tasks WHERE storage_pool_id = '123';
Try unlock_entitiy.sh with '-t all -r'
Best Regards,
Strahil Nikolov
On Sat, Oct 16, 2021 at 13:43, David White via Users