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

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/TCBGLVCLMTZ... >> > >> _______________________________________________ >> 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/EAFO7EBLCET... >> >