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@yahoo.com> 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@ltresources.co.uk> написа:





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@jalloq.co.uk> 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@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/TCBGLVCLMTZSQAURDDVGHKYXXQ36NO5H/
>
_______________________________________________
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/EAFO7EBLCETILFJGCY55K254TLRKJPRC/