CHECK BOTTOMLESS CHECKSUM
On this page
CHECK BOTTOMLESS CHECKSUM checks the checksum of the blob files stored in the remote blob store.
Syntax
CHECK BOTTOMLESS CHECKSUM [WITH REPAIR[FORCE]];
Arguments
-
For the
WITH REPAIRoption, 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 FORCEoption.
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 |
+---------+-----------+-------+----------+-------+--------------------------------------------------------------------------------------------------+--------------+----------------------+Last modified: January 26, 2024