Hi David, Since you tried first to execute the query without semicolon the second attempt to run the query with the semicolon failed. It considers both lines as one query.
Try only - SELECT * FROM image_transfers; On Tue, 19 Oct 2021 at 23:32, David White <[email protected]> wrote: > 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 < > [email protected]> 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 <[email protected]> > 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 < >> [email protected]> wrote: >> >> Please try the following query and share the output - >> >> SELECT * FROM image_transfers; >> >> On Tue, 19 Oct 2021 at 03:48, David White <[email protected]> >> 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 < >>> [email protected]> 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 <[email protected]> wrote: >>> >>>> On Fri, Oct 15, 2021 at 11:38 AM David White via Users <[email protected]> >>>> 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 -- [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/3UE6CJLEGBR27KWJQH3TA5AX7LXX5URV/ >>>> >>> >>> >>> -- >>> Regards, >>> Eyal Shenitzky >>> >>> >>> >> >> -- >> Regards, >> Eyal Shenitzky >> >> >> > > -- > Regards, > Eyal Shenitzky > > > -- Regards, Eyal Shenitzky
_______________________________________________ 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/HMIPQMQVXIF3NE6VQ2KWHTNPVXXZ2JZQ/
