[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres
Thank you. Unfortunately, this is still an issue. I have indeed tried running the taskcleaner.sh script, but I just tried it again. [root@ovirt-engine1 dwhite]# PGPASSWORD=password /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -Rt This will remove all async_tasks table content!!! Caution, this operation should be used with care. Please contact support prior to running this command Are you sure you want to proceed? [y/n] y TRUNCATE TABLE I then ran a select * from async_tasks... and we can confirm that there's zero rows: engine=# SELECT * from async_tasks;task_id | action_type | status | result | step_id | command_id | started_at | storage_pool_id | task_type | vdsm_task_id | root_command_id | user_id -+-+++-+++-+---+--+-+- (0 rows) I'm still unclear what SPM is. I ran that command on the "problematic" host, and I get this stdout, [root@cha1-storage]# vdsm-client Host getAllTasksStatusesvdsm-client: Command Host.getAllTasksStatuses with args {} failed: (code=654, message=Not SPM: ()) And finally, I tried Strahil's suggestion: [root@ovirt-engine1 dwhite]# PGPASSWORD=password /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t all -r ## 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_all(); INSERT 0 1 unlock all completed successfully. Unfortunately, I'm still getting the same error message in the admin UI with the 3 disks listed as "image transfer in progress". Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Sunday, October 17th, 2021 at 5:34 AM, Shani Leviim wrote: > Hi David,Have you tried running the taskcleaner script with the updated > password?$ PGPASSWORD=xx > /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R > > You can also verify if the SPM itself has some locked tasks by running on it: > > vdsm-client Host getAllTasksStatuses > > Then clear those tasks: > > vdsm-client Task clear taskID=12345 > > To verify there are no more async tasks, you can run this SQL query on the > engine: > > engine=# select * from async_tasks WHERE storage_pool_id = '123'; > > Regards, > Shani Leviim > > On Sun, Oct 17, 2021 at 12:14 PM Strahil Nikolov > wrote: > > > Try unlock_entitiy.sh with '-t all -r' > > > > Best Regards,Strahil Nikolov > > > > > On Sat, Oct 16, 2021 at 13:43, David White via Users > > > wrote:___ > > > > > > Users mailing list -- users@ovirt.org > > > > > > To unsubscribe send an email to users-le...@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/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/ publickey - dmwhite823@protonmail.com - 0x320CD582.asc Description: application/pgp-keys signature.asc Description: OpenPGP digital signature ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/WCSGZJXE26YTGOGYV7WQ5L4KYE65KOEL/
[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres
On Fri, Oct 15, 2021 at 11:38 AM David White via Users 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@ovirt.org To unsubscribe send an email to users-le...@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/
[ovirt-users] Ovirt VM started with the most recent snapshot with the current disk missing
Dear Ovirt folks, I am faced with a very strange situation with Ovirt 4.3. A virtual machine has two snapshots and a working disk, with the former two snapshots being read only and the working one read-write. After an unplanned power outage, a virtual machine can only be started with the recent snapshot, and the actual working disk is missing in the Ovirt UI. I can see the disk still exists in the backend storage, but it seems not Ovirt does not know it. Thus the VM lose the recent data on the missing disk. Does any one know whether this is a known bug in Ovirt 4.3, or is there a method to resotre the missing working disk back to the virtuanl machine? Otherwise i am faced with a terrible data loss issue on Ovirt best regards, Samuel ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/N7JVXAU5MLAG5YX7LY2XABT3TDKOHYFX/
[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres
Hi David, Have you tried running the taskcleaner script with the updated password? $ PGPASSWORD=xx /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R You can also verify if the SPM itself has some locked tasks by running on it: vdsm-client Host getAllTasksStatuses Then clear those tasks: vdsm-client Task clear taskID=12345 To verify there are no more async tasks, you can run this SQL query on the engine: engine=# select * from async_tasks WHERE storage_pool_id = '123'; *Regards,* *Shani Leviim* On Sun, Oct 17, 2021 at 12:14 PM Strahil Nikolov wrote: > Try unlock_entitiy.sh with '-t all -r' > > Best Regards, > Strahil Nikolov > > On Sat, Oct 16, 2021 at 13:43, David White via Users > wrote: > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@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/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/ > > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/Q6LWCPIVDTQRQ6LOTLESYDQG45WGA6NB/
[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres
Try unlock_entitiy.sh with '-t all -r' Best Regards,Strahil Nikolov On Sat, Oct 16, 2021 at 13:43, David White via Users wrote: ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/ ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/R2M4H5PMS27MWTFJYTZACPBOUF6YIBYA/
[ovirt-users] Re: HA VM and vm leases usage with site failure
On Tue, Aug 10, 2021 at 1:02 PM Klaas Demter wrote: > Okay, so the SPM is only blocking me if I have thin provisioned block > storage that needs extending. This is luckily not the case because we > primarily use NFS. It is something though I have never thought about, in > my head the storage leases completely solved the "host crashes and power > management does not answer" until I read your mail :) > > > Thanks for the detailed explanation Nir! > > > Greetings > > Klaas > > In the meantime I opened a case (number 03004698 with also logs) regarding expected behavior and the Disaster Recovery Guide not being so clear in this scenario. A documentation bugzilla has been opened so feel free to read and/ or contribute to it. https://bugzilla.redhat.com/show_bug.cgi?id=2014790 Thanks, Gianluca ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/3AXUGHK22TYOWO22F7IINKZE3TSS43YF/