This is still an issue.
As part of my troubleshooting process, I manually migrated all of the VMs off of this host. When I still couldn't put it into maintenance mode, I manually ran "yum update" from the command line, and then rebooted it.

The oVirt UI detected that it was down, and marked it as "Unavailable" for a while, but once the host came back up, everything was marked green again, and the host is a useful part of the cluster.

Unfortunately, I still cannot put it into maintenance mode because oVirt still thinks these disks are locked.

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, October 15th, 2021 at 4:32 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

I've tried the following multiple times:

PGPASSWORD=snip /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk e0f46dc5-7f98-47cf-a586-4645177bd6a2

##########################################
CAUTION, this operation may lead to data corruption and should be used with care. Please contact support prior to running this command
##########################################

Are you sure you want to proceed? [y/n]
y
select fn_db_unlock_disk('e0f46dc5-7f98-47cf-a586-4645177bd6a2');


INSERT 0 1
unlock disk e0f46dc5-7f98-47cf-a586-4645177bd6a2 completed successfully.


Any other ideas?

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, October 14th, 2021 at 10:15 AM, Shani Leviim <sleviim@redhat.com> wrote:
Hi David,
Taken from [1], for setting the password for the engine user.
su - postgres
psql
postgres=# create role engine with login encrypted password 'password';

You can set the password for the postgres with 'sudo passwd postgres'
(Alghout the password should be postgres)

For unlocking the disk, follow the example here [2]
$ PGPASSWORD=xxxxxx ./unlock_entity.sh -t disk -q


Regards,
Shani Leviim


On Thu, Oct 14, 2021 at 12:45 PM David White via Users <users@ovirt.org> wrote:
I am trying to put a host into maintenance mode, and keep getting this error:

Error while executing action: Cannot switch Host cha1-storage.my-domain.com to Maintenance mode. Image transfer is in progress for the following (3) disks:

e0f46dc5-7f98-47cf-a586-4645177bd6a2,
06bd3678-bfab-4793-a839-ec8cad4b96e5,
13cef086-3878-463b-a224-cc42b44d8468

Reviewing documentation online, it seems I need to do this:
   PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk e0f46dc5-7f98-47cf-a586-4645177bd6a2
   PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk 06bd3678-bfab-4793-a839-ec8cad4b96e5
   PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk 13cef086-3878-463b-a224-cc42b44d8468
   /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R

When I run those commands, it *seems* to run successfully.
However, I don't think that I have the correct password, because I cannot get a psql interface:

[root@ovirt-engine1 ovirt-engine]# psql -U admin -h localhost -p 5432
psql: error: FATAL:  Ident authentication failed for user "admin"
[root@ovirt-engine1 ovirt-engine]# psql -U admin -W -h localhost -p 5432
Password:
psql: error: FATAL:  Ident authentication failed for user "admin"
[root@ovirt-engine1 ovirt-engine]# psql -U engine -h localhost -p 5432
Password for user engine:

[root@ovirt-engine1 ovirt-engine]# read PASSWD
/etc/pki/ovirt-engine/encryptpasswd.sh
[root@ovirt-engine1 ovirt-engine]# cat /etc/pki/ovirt-engine/encryptpasswd.sh $PASSWD
cat: /etc/pki/ovirt-engine/encryptpasswd.sh: No such file or directory
cat: /etc/pki/ovirt-engine/encryptpasswd.sh: No such file or directory

I must be doing something wrong here. 

1) How can I reset the Postgres password? What user should I be using?
2) Once I have the correct password, will the commands I provided earlier work to unlock the disk?

Sent with ProtonMail Secure Email.

_______________________________________________
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/AO3JBKZZDMTNTRD7GYLUKV7VG6OMVY5G/