[ovirt-users] Re: How to force removal of old host from Engine

On April 22, 2020 12:41:49 AM GMT+03:00, "Maton, Brett" <matonb(a)ltresources.co.uk&gt; wrote: >Last time I had to forcibly remove a node because it was impossible to >do >so otherwise, it had never ever had anything to do with gluster, so I >STRONGLY dispute your claim that fixing an issue (that was not stated) >will >fix anything. > >On Tue, 21 Apr 2020 at 22:39, Maton, Brett <matonb(a)ltresources.co.uk&gt; >wrote: > >> I'm sorry there was no suggestion that the node had anything to do >with >> gluster, clearly stated but how to remove a dead and unmanageable >node from >> the cluster. >> >> On Tue, 21 Apr 2020 at 20:41, Strahil Nikolov <hunter86_bg(a)yahoo.com&gt; >> wrote: >> >>> Not a good approach. >>> It's important to know if the node was also a gluster peer in the >storage >>> pool - if yes, it needs to be replaced with 'replace-brick' or >>> 'reset-brick' (depending if you use the old hostname or not). >>> Once the storage node is replaced - oVirt will allow you to remove >it. >>> >>> >>> Best Regards, >>> Strahil Nikolov >>> >>> >>> >>> >>> >>> >>> В вторник, 21 април 2020 г., 19:46:47 Гринуич+3, Maton, Brett < >>> matonb(a)ltresources.co.uk&gt; написа: >>> >>> >>> >>> >>> >>> Last time I had to do this I removed from the database. >>> >>> (at your own risk) >>> On ovirt engine switch to the postgres user from root: >>> >>> su - postgres >>> >>> Enable postgres 10 and connect to the engine database: >>> >>> . scl_source enable rh-postgresql10 >>> psql -d engine >>> >>> Change <host name to remove> to the name (Name column of the host in >the >>> UI) of the host you want to get rid of ( leave the '\' and \'' in >place ) >>> >>> BEGIN;\set host '\'<host name to remove>\''DELETE FROM vds_dynamic >WHERE >>> vds_id IN (SELECT vds_id FROM vds_static WHERE vds_name = >:host);DELETE >>> FROM vds_statistics WHERE vds_id IN (SELECT vds_id FROM vds_static >WHERE >>> vds_name = :host);DELETE FROM vds_static WHERE vds_name = >:host;COMMIT; >>> <CTRL d - exit> >>> >>> >>> >>> On Tue, 21 Apr 2020 at 15:19, Shareef Jalloq <shareef(a)jalloq.co.uk&gt; >>> wrote: >>> > Hi, >>> > >>> > I seem to have got a stale host in my engine that I can't remove. >I >>> recently reinstalled oVirt Node on this host and while trying to >refresh >>> the host in the engine, have got it in some state where I can't do >anything. >>> > >>> > The host is listed as Status=Unassigned. Under the Management >pull >>> down I only have Restart and Stop options, both of which error if >>> selected. The Remove button is not available. >>> > >>> > How do I force a removal of this host from the view so I can >reload it? >>> > >>> > Shareef. >>> > _______________________________________________ >>> > 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/TCBGLVCLMTZSQAURDDVGHKYXXQ36NO5H/ >>> > >>> _______________________________________________ >>> 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/EAFO7EBLCETILFJGCY55K254TLRKJPRC/ >>> >> Last time I had to remove a host - I didn't have your issues. Yet, I'm not claiming the opposite - just that in case the host is also a gluster node , oVirt will intentionally prevent removal of the node. Your approach could be absolutely valid in case there is no Gluster involved - yet for HCI , Gluster brick has to be replaced prior taking any actions for the removal.