Checksum does not match: corrupted data .: when reading the column `cid` at / opt / clickhouse // data / click

Question

I use clickhouse to store data, and I get the following error when querying the cid column from the click table.

Checksum does not match: corrupted data.

I have no replicas yet, no suggestions for recovery?

Answer 1

The error boils down to the fact that the checksum CityHash128and the compressed data do not match and throw this exception in readCompressedData .

You can disable this check disable_checksumusing the disableChecksumming method .

, , , , - , , .

Answer 2

.

, , , . ( ) ( ), .