In certain scenarios VMware Workspace One access can be left in a unsynchronized state. Following procedure will allow for making sure WS1XS is fully operational again and healthy.
This procedure is a shortening of https://kb.vmware.com/s/article/75080 which is the official procedure.
Step 1: Which Node is Primary
On one of the WS1XS nodes, perform the following command to find out which node is primary. Password is located in /usr/local/etc/pgpool.pwd
su root -c "echo -e 'password'|/opt/vmware/vpostgres/current/bin/psql -h localhost -p 9999 -U pgpool postgres -c \"show pool_nodes\""
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change
---------+--------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
0 | 192.168.4.19 | 5432 | up | 0.333333 | primary | 0 | true | 0 | 2021-03-06 20:51:05
1 | 192.168.4.21 | 5432 | up | 0.333333 | standby | 0 | false | 0 | 2021-03-06 20:51:05
2 | 192.168.4.20 | 5432 | up | 0.333333 | standby | 0 | false | 0 | 2021-03-06 20:51:05
Step 2: Cluster IP on Primary Node
Make sure that the cluster (virtual alias) IP address is running on the node (deletegate IP):
ifconfig eth0:0 | grep 'inet addr:' | cut -d: -f2
If the list does not contain a DelegateIP (Cluster) IP, configure it:
ifconfig eth0:0 inet <delegate-ip> netmask <delegate-netmask>
Step 3: Restart Services on Primary Node
On all nodes restart the workspace one services on the primary (delegate) node
service horizon-workspace restart
Step 4: Synchronize on Secondary Nodes
If nodes actually report that status is ‘down’ during Step (1), then you must resynchronize
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change
———+————–+——+——–+———–+———+————+——————-+——————-+———————
0 | 192.168.4.19 | 5432 | up | 0.333333 | primary | 0 | true | 0 | 2021-03-06 20:42:46
1 | 192.168.4.21 | 5432 | down | 0.333333 | standby | 0 | false | 0 | 2021-03-06 20:42:25
2 | 192.168.4.20 | 5432 | down | 0.333333 | standby | 0 | false | 0 | 2021-03-06 20:42:25
Login on the ‘down’ node and perform the following command:
service vpostgres stop /usr/local/bin/pcp_recovery_node -h delegateIP -p 9898 -U pgpool -n <nodeid>
Restart the horizon service afterwards:
service horizon-workspace restart