Skip to main content

Assume for the moment that Node 2 of a LB farm (with 2 nodes) has failed, and the node will not be reinstalled.  How do we go about removing the bad node from the config?  I cannot find anything in the help that identifies how this should be done. 

I have noticed you opened a support ticket related to this question, please update the thread with resolution once support resolved the ticket.


You need to remove non-existing server references within K2 database.


 


Before attempting to remove anything be sure to backup your K2 DB (as usual / by default). In case you are not sure what are you doing just log a support ticket :)


 


Once you backed up your K2 DB perform the following steps:



Execute stored procedure Server.kClusterDown which removes references to node you removing from all the relevant tables, i.e.:

Server.ProcInst
Server.DestQueue
Server.Async
Server.IPCAsync
Server.ClusterMessage

You run this stored procedure specifying IDs (note: IDs not sever names) from Server.Server table as a parameters:

@ServerID = NEW SERVERID / ID OF THE SERVER WHICH STAYS IN YOUR FARM
@ClusterServerID = OLD SERVERID / ID OF THE SERVER WHICH YOU REMOVED FROM YOUR FARM
@ServerDownTimeout = 0

Once you executed this stored procedure remove references to the old server from the following tables:


SELECT * FROM Server.Server
SELECT * FROM HostServer.Server
-- License can be deleted from Workspace/Management GUI
SELECT * FROM HostServer.LicenseKey


After removing references to the old server from K2 database, restart K2 host server service to allow it to re-read changed configuration from the database.


Reply