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] [ON <database_name>] [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. -
CHECKSUMis an optional flag.If specified, it will additionally verify the checksum of the blob files stored in the remote blob store. -
ON <database_verifies only the blob store contents for the specified database.name> If not specified the entire blob store contents for all databases in the cluster is verified.
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