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

I tried that, but whenever I use semicolons, I get a syntax error. Here's my full stdout with and without the semicolon: postgres=# \c engine You are now connected to database "engine" as user "postgres". engine=# SELECT * FROM image_transfers engine-# SELECT * FROM image_transfers; ERROR: syntax error at or near "SELECT" LINE 2: SELECT * FROM image_transfers; ^ Sent with ProtonMail <https://protonmail.com/> Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Tuesday, October 19th, 2021 at 6:57 AM, Eyal Shenitzky < eshenitz(a)redhat.com&gt; wrote: You are missing ';' at the end of the query. That's why you see no output. On Tue, 19 Oct 2021 at 13:24, David White <dmwhite823(a)protonmail.com&gt; wrote: > Thank you. > However, that was one of the queries I already tried. > > All of the queries I listed in my previous email returned empty results, > which is why I was confused. Given the name of some of these tables, I > expect to see some data in them. > I just tried re-running that query, making sure to capitalize the "FROM" > just in case, but got the same results: > > engine=# SELECT * FROM image_transfers > engine-# > > I then went into the UI, and migrated a VM from 1 host to another. > During the migration, I re-ran that query, and it still came back empty. > > Does this table store information about moving a disk from 1 volume to > another, or moving VMs from 1 host to another? > > Sent with ProtonMail <https://protonmail.com/> Secure Email. > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > On Tuesday, October 19th, 2021 at 1:58 AM, Eyal Shenitzky < > eshenitz(a)redhat.com&gt; wrote: > > Please try the following query and share the output - > > SELECT * FROM image_transfers; > > On Tue, 19 Oct 2021 at 03:48, David White <dmwhite823(a)protonmail.com&gt; > wrote: > >> 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 >> >> >> > > -- > Regards, > Eyal Shenitzky > > > -- Regards, Eyal Shenitzky