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 <slev...@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...@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-le...@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/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/
publickey - dmwhite823@protonmail.com - 0x320CD582.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/WCSGZJXE26YTGOGYV7WQ5L4KYE65KOEL/