Skip to content

Segement Fault while doing large select insert #87615

@zhnpeng

Description

@zhnpeng

Describe the bug

Clickhouse version: v25.3.3.42
Clickhouse crash cause of segment fault when doing a large SELECT INSERT.
we upgrade from v22.3.6.5, which won't crash when executing the same SQL

How to reproduce

the sql is replace with ... as below and SETTINGS is keep, this INSERT SELECT handle amount of data

query_id: ddde25fd-7b5d-4bb6-b3a5-f0760a759330) (query: INSERT INTO ... SETTINGS max_threads = 5, max_memory_usage = 20000000000, group_by_overflow_mode = 'any', max_rows_to_group_by = 1000000) Received signal Segmentation fault (11)

Error message and/or stacktrace

ck_seg_fault.log

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