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 |
+---------+-----------+-------+----------+-------+--------------------------------------------------------------------------------------------------+--------------+----------------------+