STORAGEGROUPS System Table Description


A pseudo Table generated to show all storage groups serviced by this database.

Caution: Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.


Field Type Description
ID bigint The ID of the storage group. Note, storage group ALL is always 1.
NAME string The name of the storage group. This is the name assigned to the storage group by the NuoDB Manager add storageGroup command.
STATUS string

This describes the availability of the storage group. A storage group is listed as Unavailable if there are no SMs available to service this particular storage group.

Available – storage group is on-line.

Unavailable – no running Storage Managers service this storage group.

Stranded – there may still be stranded transactions in the leader archive for this storage group. Until all of these are resolved, the state of all past transactions is uncertain.

NUMLEADERCANDIDATES bigint The number of live archive nodes that are leader candidates for this storage group. See SYSTEM.NODESTORAGEGROUPS.LEADERCANDIDATE to determine which archive nodes are defined as leader candidates for the storage group.