SHUTDOWN_SUBCLUSTER
Eon Mode only
This function does not test whether the target subcluster is critical (a subcluster whose loss would cause the database to shut down). Using this function to shut down a critical subcluster results in the database shutting down. Always verify that the subcluster you want to shut down is not critical by querying the CRITICAL_SUBCLUSTERS system table before calling this function.
Stopping a subcluster does not warn you if there are active user sessions connected to the subcluster. This behavior is same as stopping an individual node. Before stopping a subcluster, verify that no users are connected to it.
Syntax
SHUTDOWN_SUBCLUSTER('subcluster‑name')
Arguments
subcluster‑name | Name of the subcluster to shut down. |
Privileges
Superuser
Examples
The following example demonstrates shutting down the subcluster analytics
:
=> SELECT subcluster_name, node_name, node_state FROM nodes order by 1,2; subcluster_name | node_name | node_state --------------------+----------------------+------------ analytics | v_verticadb_node0004 | UP analytics | v_verticadb_node0005 | UP analytics | v_verticadb_node0006 | UP default_subcluster | v_verticadb_node0001 | UP default_subcluster | v_verticadb_node0002 | UP default_subcluster | v_verticadb_node0003 | UP (6 rows) => SELECT SHUTDOWN_SUBCLUSTER('analytics'); WARNING 4539: Received no response from v_verticadb_node0004 in stop subcluster WARNING 4539: Received no response from v_verticadb_node0005 in stop subcluster WARNING 4539: Received no response from v_verticadb_node0006 in stop subcluster SHUTDOWN_SUBCLUSTER --------------------- Subcluster shutdown (1 row) => SELECT subcluster_name, node_name, node_state FROM nodes order by 1,2; subcluster_name | node_name | node_state --------------------+----------------------+------------ analytics | v_verticadb_node0004 | DOWN analytics | v_verticadb_node0005 | DOWN analytics | v_verticadb_node0006 | DOWN default_subcluster | v_verticadb_node0001 | UP default_subcluster | v_verticadb_node0002 | UP default_subcluster | v_verticadb_node0003 | UP (6 rows)
The "WARNING 4539" messages after calling SHUTDOWN_SUBCLUSTER occur because the nodes are in the process of shutting down. They are expected.