Skip to content

LOGICAL_ERROR when reading from merge tree table without adaptive index granularity (RangeReader read N rows, but M expected) #62741

@canhld94

Description

@canhld94

Please make sure that the version you're using is still supported (you can find the list here).

You have to provide the following information whenever possible.

Describe what's wrong

A clear and concise description of what works not as it is supposed to.

Received exception from server (version 24.4.1):
Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: RangeReader read 803 rows, but 1024 expected.: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (LOGICAL_ERROR)
(query: SELECT   29, id = 11338881281426660955, * FROM account_test__fuzz_36 PREWHERE materialize(29);)

A link to reproducer in https://fiddle.clickhouse.com/.

https://fiddle.clickhouse.com/3db4eb06-f421-46e9-a115-d01bf462fcf0

Does it reproduce on the most recent release?

The list of releases

Yes, on HEAD

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions