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 Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Monday, October 18th, 2021 at 3:10 AM, Eyal Shenitzky <eshenitz@redhat.com> 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@redhat.com> wrote:
On Fri, Oct 15, 2021 at 11:38 AM David White via Users <users@ovirt.org> 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).
Screenshot from 2021-10-15 04-29-15.png


Do  you have active image transfers?

You can check by getting

 
If there are no image transfers, check the relevant disks status:


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@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/3UE6CJLEGBR27KWJQH3TA5AX7LXX5URV/


--
Regards,
Eyal Shenitzky