To find the nodes of the service along with the state, connect to the Data Preparation repository and execute the following SQL query:
select node_id, node_ip, state, created_ts, node_port, isp_node_name from dp_physical node;
The state column shows the current state of the node service. It can be in any of the following states:
ACTIVE: The node is ready to take new user sessions.
SUSPECTED_UNREACHABLE: The node cannot accept new sessions as peer-check operation is failing on that node. The node might not be completely down as the server may recover after a brief period of high load.
To find the user to node assignment, connect to the Data Preparation repository and execute the following SQL query:
select login_id, node_ip, a.node_id, isp_node_name from dp_physical_node a, dp_user u, dp_user_to_node_map m where a.node_id = m.node_id and u.id = m.user_id;