Skip to content

01730_distributed_group_by_no_merge_order_by_long is flaky #85270

@ahmadov

Description

@ahmadov

Test case history

Example failure from this build:

2025-08-07 12:31:09 Reason: return code:  241
2025-08-07 12:31:09 Received exception from server (version 25.8.1):
2025-08-07 12:31:09 Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Query memory limit exceeded: would use 100.48 MiB (attempt to allocate chunk of 1.00 MiB bytes), maximum: 100.00 MiB: While executing MergingSortedTransform. (MEMORY_LIMIT_EXCEEDED)
2025-08-07 12:31:09 (query: select * from remote('127.{2..11}', currentDatabase(), data_01730) group by key order by key limit 1e6 settings distributed_group_by_no_merge=2, max_memory_usage='100Mi', optimize_aggregation_in_order=1 format Null;)
2025-08-07 12:31:09 , result:
2025-08-07 12:31:09 
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 
2025-08-07 12:31:09 stdout:
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 0
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 1
2025-08-07 12:31:09 
2025-08-07 12:31:09 
2025-08-07 12:31:09 
2025-08-07 12:31:09 Database: test_yx6zr8al

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions