TABLE_RECOVERIES

Provides detailed information about recovered and recovering tables during a recovery by table.

Provides detailed information about recovered and recovering tables during a recovery by table.

Column Name Data Type Description
NODE_NAME VARCHAR Name of the node that is performing the recovery.
TABLE_NAME VARCHAR The name of the table being recovered.
TABLE_OID INTEGER The object ID of the table being recovered.
STATUS VARCHAR

The status of the table. Tables can have the following status:

  • recovered: The table is fully recovered

  • recovering: The table is in the process of recovery

  • error_retry: Vertica has attempted to recover the table, but the recovery failed.

Tables that have not yet begun the recovery process do not have a status.

PHASE VARCHAR The phase of the recovery.
THREAD_ID VARCHAR The ID of the thread that performed the recovery.
START_TIME TIMESTAMPTZ The date and time that the table began recovery.
END_TIME TIMESTAMPTZ The date and time that the table completed recovery.
RECOVER_PRIORITY INTEGER The recovery priority of the table being recovered.
RECOVER_ERROR VARCHAR Error that caused the recovery to fail.
IS_HISTORICAL BOOLEAN If f, the record contains recovery information for the current process.

Privileges

None

Examples

=> SELECT * FROM TABLE_RECOVERIES;
-[RECORD 1]----------------------------------
node_name        | node04
table_oid        | 45035996273708000
table_name       | public.t
status           | recovered
phase            | current replay delete
thread_id        | 7f7a817fd700
start_time       | 2017-12-13 08:47:28.825085-05
end_time         | 2017-12-13 08:47:29.216571-05
recover_priority | -9223372036854775807
recover_error    | Event apply failed
is_historical    | t
-[RECORD 2]--------------------------------------
node_name        | v_test_parquet_ha_node0011
table_oid        | 45035996273937680
table_name       | public.t2_impala230_uncompre_multi_file_libhdfs_1
status           | error-retry
phase            | historical
thread_id        | 7f89a574f700
start_time       | 2018-02-24 11:30:59.008831-05
end_time         | 2018-02-24 11:33:09.780798-05
recover_priority | -9223372036854775807
recover_error    | Could not stop all dirty transactions[txnId = 45035996273718426; ]
is_historical    | t