CHECK BOTTOMLESS CHECKSUM
CHECK BOTTOMLESS CHECKSUM
checks the checksum of the blob files stored in the blob store.
Syntax
CHECK BOTTOMLESS CHECKSUM [WITH REPAIR[FORCE]];
Arguments
For the
WITH REPAIR
option, the blob can be re-uploaded to fix corruptions if there is a copy of the blob on the local disk.If the blob is not copied on the local disk, the only repair option is remove the blob metadata and take a data loss utilizing the
WITH REPAIR FORCE
option.
Example
This is a simple use showing how the output of CHECK BOTTOMLESS CHECKSUM
displays corruption in the blob store.
CHECK BOTTOMLESS CHECKSUM; **** +---------+-----------+-------+----------+-------+--------------------------------------------------------------------------------------------------+--------------+----------------------+ | node_id | Host | Port | Database | Table | Filename | Reason | Repair operations | +---------+-----------+-------+----------+-------+--------------------------------------------------------------------------------------------------+--------------+----------------------+ | 3 | 127.0.0.1 | 10002 | x_test_1 | t | cdbcaacd/14336023895786281142_3/partition_1/blobs/00000000000/000/0x012_17744458468407284698_5_5 | Missing file | Copy from local disk | | 3 | 127.0.0.1 | 10002 | x_test_1 | t | cdbcaacd/14336023895786281142_3/partition_1/blobs/00000000000/000/0x014_17744458468407284698_5_5 | Missing file | Copy from local disk | +---------+-----------+-------+----------+-------+--------------------------------------------------------------------------------------------------+--------------+----------------------+