Clickhouse: DB::Exception: Sizes of columns doesn't match

[sergeyignatov]

Hi,
We have issue with ReplicatedGraphiteMergeTree. After 86400s (second retention) we are seeing lots of exceptions in logs. clickhouse version 1.1.54233

```SHOW CREATE TABLE graphite.graphite10

│ CREATE TABLE graphite.graphite10 ( Path String, Value Float64, Time UInt32, Date Date, Timestamp UInt32) ENGINE = ReplicatedGraphiteMergeTree(\'/clickhouse/tables/graphite10\', \'{replica}\', Date, (Path, Time), 8192, \'graphite_rollup10\')

any

0
10


86400
3600

2017.05.15 19:47:33.966779 [ 32 ] DB::StorageReplicatedMergeTree::queueTask()::

1. clickhouse-server(StackTrace::StackTrace()+0x16) [0x299bb06]
2. clickhouse-server(DB::Exception::Exception(std::__cxx11::basic_string, std::allocator > const&, int)+0x1f) [0x10e177f]
3. clickhouse-server(DB::Block::checkNumberOfRows() const+0x263) [0x234c653]
4. clickhouse-server() [0x2b403f1]
5. clickhouse-server(DB::MergeTreeDataMerger::mergePartsToTemporaryPart(std::vector, std::allocator > >&, std::__cxx11::basic_string, std::allocator > const&, DB::MergeListEntry&, unsigned long, long, DB::DiskSpaceMonitor::Reservation*, bool)+0x2b2f) [0x2ae612f]
6. clickhouse-server(DB::StorageReplicatedMergeTree::executeLogEntry(DB::ReplicatedMergeTreeLogEntry const&)+0xd7c) [0x2ab13cc]
7. clickhouse-server() [0x2ab432d]
8. clickhouse-server(DB::ReplicatedMergeTreeQueue::processEntry(std::function ()>, std::shared_ptr&, std::function&)>)+0x4a) [0x2b040ba]
9. clickhouse-server(DB::StorageReplicatedMergeTree::queueTask()+0x16c) [0x2a9455c]
10. clickhouse-server(DB::BackgroundProcessingPool::threadFunction()+0x454) [0x2afae64]
11. clickhouse-server() [0x3646630]
12. /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7ffba03266ba]
13. /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7ffb9f94782d]
    ```

[ztlpn]

Hi @sergeyignatov ! This is a known bug, but we have not been able to pinpoint the cause of it yet. Here is how you can help: please provide all different strings of the form Path: x, Value: y that appear in the exception messages (I am interested in the values of x and y and how often they appear). Thanks!

[sergeyignatov]

grep -oP 'DB::Exception: Sizes of columns.*' /var/log/clickhouse-server/clickhouse-server.log |sort |uniq -c
59457 DB::Exception: Sizes of columns doesn't match: Path: 0, Value: 1, e.what() = DB::Exception, Stack trace:

[ztlpn]

810

[sergeyignatov]

with fix-graphite-rollup Exceptions are gone

[ztlpn]

fix released in v1.1.54236