CHECK BOTTOMLESS
On this page
CHECK BOTTOMLESS can be used to detect corruption such as any missing or corrupted blob files in the remote blob store, It has options useful to attempt resolving the blob store corruption.
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 to remove the blob metadata and take a data loss utilizing the
WITH REPAIR FORCEoption.
Example
This simple example shows 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: April 1, 2025