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 <[email protected]>
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 <[email protected]>
> 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<[email protected]>
> > > wrote:_______________________________________________
> > >
> > > Users mailing list -- [email protected]
> > >
> > > To unsubscribe send an email to [email protected]
> > >
> > > 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/[email protected]/message/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/
publickey - [email protected] - 0x320CD582.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/WCSGZJXE26YTGOGYV7WQ5L4KYE65KOEL/
