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 -Rt 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 getAllTasksStatusesvdsm-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". Sent with ProtonMail Secure Email. ‐‐‐‐‐‐‐ 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';
Regards, Shani Leviim
On Sun, Oct 17, 2021 at 12:14 PM Strahil Nikolov <hunter86_bg@yahoo.com> wrote:
Try unlock_entitiy.sh with '-t all -r'
Best Regards,Strahil Nikolov
On Sat, Oct 16, 2021 at 13:43, David White via Users<users@ovirt.org> wrote:_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/4CUOM4K4EUKT5X...