How can I fix: DB::Exception: bad size of marks file

[ste...@activitystream.com]

Hi,

What is this and how can I fix it?

46, host: clickhouse, port: 8123; Code: 246, e.displayText() = DB::Exception: bad size of marks file `../data/.../20170501_20170529_4890_4932_2/classification%2Etype.null.mrk':432, must be: 224: (while reading column classification.type): (while reading from part ../data/../20170501_20170529_4890_4932_2/ from mark 3 to 4), e.what() = DB::Exception

Regards,

 -Stefán

[mvav...@cloudflare.com]

The marks file for this part/column is corrupted. It could be a random disk error, but all the times I've seen it, the disk was going to die soon.

If it's a replicated table, you can just remove the part from disk and it will recover from peer replicas.

If it's unreplicated table, you can try to recover the data from columns, but they're written in native format and I'm not sure if there's an easy way how to reinsert them.

[ste...@activitystream.com]

Thank you.

[Jason Piper]

I had the same issue which was caused by a zookeeper cluster in a bad state.

To get the problem to fix, not only did I have to remove the part from the file, but I had to restart the clickhouse server on the node presenting this error as well.