[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

Would this be found in the "image_transfers" table? \dt shows me that there are 156 tables in the engine database. And I see an image_transfers table. But it looks empty, like a lot of other tables. This seems strange to me. All of these tables are empty, unless I'm doing something wrong (I'm new to Postgres). engine=# SELECT * from images engine-# SELECT * from image_transfers engine-# select * from users engine-# SELECT * from users engine-# SELECT * from cluster engine-# select * from vm_pools engine-# select * from vm_static Sent with ProtonMail <https://protonmail.com/> Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Monday, October 18th, 2021 at 3:10 AM, Eyal Shenitzky < eshenitz(a)redhat.com&gt; wrote: The host cannot be set to maintenance if there are image transfer with status different then PAUSED (by user or system - 4/5 in the DB) or FINISHED (success or failure - 9/10 in the DB). If there are image transfer session in the DB with status that is different then those that I mentioned, you should see why the have a different status and finalize/clean them before setting the host to maintenance. On Sun, 17 Oct 2021 at 15:43, Nir Soffer <nsoffer(a)redhat.com&gt; wrote: > On Fri, Oct 15, 2021 at 11:38 AM David White via Users <users(a)ovirt.org&gt; > wrote: > >> Thank you very much. >> I was able to (re)set the `engine` user's password in Postgres. >> Unfortunately, I'm still having trouble unlocking the disks. >> >> The following command produces no output underneath "Locked disks" when >> I run this command on the hosted engine VM: >> >> *[root@ovirt-engine1 dwhite]# PGPASSWORD=snip >> /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk -q* >> *Locked disks* >> >> However, in the oVirt UI, when I try to put the host into maintenance >> mode I continue to get the message that there are (3) locked disks >> (screenshot below). >> [image: Screenshot from 2021-10-15 04-29-15.png] >> >> > Do you have active image transfers? > > You can check by getting > > https://myengine/ovirt-engine/api/imagetransfers > > If there are no image transfers, check the relevant disks status: > > https://myengine/ovirt-engine/api/disks/{id} > > If the disks status is "locked", it may be engine bug, not cleaning up > after > failed image transfer. > > If there is no task in engine using this disk, you can change the disk > status using: > > # sudo -u postgres psql -d engine > > Finding the locked images: > > # select image_group_id,imagestatus from images where imagestatus=2; > > Unlocking an image: > > # update images set imagestatus=1 where image_group_id='xxx-yyy'; > > Nir > _______________________________________________ > Users mailing list -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)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/3UE6CJLEGBR... > -- Regards, Eyal Shenitzky