5:24 a.m.
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 Secure Email.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Tuesday, October 19th, 2021 at 1:58 AM, Eyal Shenitzky <eshenitz(a)redhat.com>
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> 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 Secure Email.
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
>
> On Monday, October 18th, 2021 at 3:10 AM, Eyal Shenitzky
<eshenitz(a)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(a)redhat.com> wrote:
> >
> > > On Fri, Oct 15, 2021 at 11:38 AM David White via Users
<users(a)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 -qLocked 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
> > >
> > > 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
