CRITICAL_SUBCLUSTERS

Lists the primary subclusters whose loss would cause the database to become unsafe and force it to shutdown. Vertica checks this table before stopping a subcluster to ensure it will not trigger a database shutdown. If you attempt to stop or remove a subcluster in this table, Vertica returns an error message. See Starting and Stopping Subclusters for more information.

This table only has contents when the database is in Eon Mode and when one or more subclusters are critical.

Column Name Data Type Description
SUBCLUSTER_OID

INTEGER

 Unique identifier for the subcluster.
SUBCLUSTER_NAME VARCHAR The name of the subcluster in a critical state.

Example

=> SELECT * FROM critical_subclusters; 
  subcluster_oid   |  subcluster_name 
-------------------+-------------------- 
 45035996273704996 | default_subcluster 
(1 row)

See Also

Concept Link IconSee Also