CODEWITHSUNDEEP
clickhouse
Tyler.z.yang
Tyler.z.yang

Reputation: 2450

Checksum doesn't match: corrupted data.: while reading column `cid` at /opt/clickhouse//data/click

I am using clickhouse to store data, and I'm getting the following error while querying the column cid from the click table.

Checksum doesn't match: corrupted data.

I don't have any replicate for now, any suggestions for recovery?

Upvotes: 4

Views: 2117

Answers (2)

uYSIZfoz
uYSIZfoz

Reputation: 911

Usually, you will get data part name and column name in exception message.

You could locate specific data part, remove files related to that single column, and restart the server. You will lose (already corrupted) data for one column in one data part (it will be filled with default values on read), but all other data will remain.

Upvotes: 2

Preview
Preview

Reputation: 35806

The error comes down to the fact the checksum of the CityHash128 and the compressed data doesn't match and throws this exception in the readCompressedData function.

You can try to disable this check using the disable_checksum via the disableChecksumming method.

It could work, but a corrupted most probably means that something is wrong with your raw data and there is small chances for recovery unless you did backups.

Upvotes: 3

Related Questions