CHECK BOTTOMLESS

The CHECK BOTTOMLESS command detects 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 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 to remove the blob metadata and take a data loss utilizing the WITH REPAIR FORCE option.

Remarks

  • The command applies to unlimited storage databases, When the target database is not an unlimited storage database, it checks the local blob files instead, equivalent to CHECK BLOB CHECKSUM.

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:

Was this article helpful?