# 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

```sql
CHECK BOTTOMLESS [CHECKSUM] [ON <database_name>] [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.
* `CHECKSUM` is an optional flag. If specified, it will additionally verify the checksum of the blob files stored in the remote blob store.
* `ON <database_name>` verifies only the blob store contents for the specified database. 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.

```sql
CHECK BOTTOMLESS CHECKSUM;

```

```output

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

***

Modified at: June 12, 2026

Source: [/db/v9.1/reference/sql-reference/operational-commands/check-bottomless/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/check-bottomless/)

(An index of the documentation is available at /llms.txt)