RECOVERY_STATUS
Provides the status of recovery operations, returning one row for each node.
You cannot query this or other system tables table during cluster recovery; the cluster must be UP to accept connections.
| Column Name | Data Type | Description |
|---|---|---|
NODE_NAME |
VARCHAR |
Name of the node that is reporting the requested information. |
RECOVER_EPOCH |
INTEGER |
Epoch the recovery operation is trying to catch up to. |
RECOVERY_PHASE |
VARCHAR |
Current stage in the recovery process. Can be one of the following:
|
SPLITS_COMPLETED |
INTEGER |
Number of independent recovery SPLITS queries that have run and need to run. |
SPLITS_TOTAL |
INTEGER |
Total number of SPLITS queries that ran. Each query corresponds to one row in the PROJECTION_RECOVERIES table. If SPLITS_TOTAL = 2, then there should be 2 rows added to PROJECTION_RECOVERIES, showing query details. |
HISTORICAL_COMPLETED |
INTEGER |
Number of independent recovery HISTORICAL queries that have run and need to run. |
HISTORICAL_TOTAL |
INTEGER |
Total number of HISTORICAL queries that ran. Each query corresponds to one row in the PROJECTION_RECOVERIES table. If HISTORICAL_TOTAL = 2, then there should be 2 rows added to PROJECTION_RECOVERIES, showing query details. |
CURRENT_COMPLETED |
INTEGER |
Number of independent recovery CURRENT queries that have run and need to run. |
CURRENT_TOTAL |
INTEGER |
Total number of CURRENT queries that ran. Each query corresponds to one row in the PROJECTION_RECOVERIES table. If CURRENT_TOTAL = 2, then there should be 2 rows added to PROJECTION_RECOVERIES, showing query details. |
IS_RUNNING |
BOOLEAN |
True (t) if the node is still running recovery; otherwise false (f). |
Privileges
None