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


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


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

See Also