Skip to content

ClickHouse: Cannot attach table due to “Suspiciously many broken parts” error #87030

@rizaltre030882

Description

@rizaltre030882

Company or project name

No response

Question

I’m running ClickHouse v25.8.1.1099 and I encountered this issue when starting up:

Cannot load data for command line suggestions: Code: 722. DB::Exception: Received from localhost:9000. DB::Exception: Waited job failed: Code: 696. DB::Exception: Load job 'startup table ais.tmp_port_snap_shot' -> Code: 695. DB::Exception: Load job 'load table ais.tmp_port_snap_shot' failed: Code: 231. DB::Exception: Suspiciously many (170 parts, 0.00 B in total) broken parts to remove while maximum allowed broken parts count is 100. You can change the maximum value with merge tree setting 'max_suspicious_broken_parts' in <merge_tree> configuration section or in table settings in .sql file (don't forget to return setting back to default value): Cannot attach table ais.tmp_port_snap_shot from metadata file store/231/231bd37c-c2a8-4f9a-a709-49cebf2ab81c/tmp_port_snap_shot.sql from query ATTACH TABLE ais.tmp_port_snap_shot UUID 'f00c75d0-04dd-4eaa-82d2-105f425e0876' (mmsi UInt64, lat Float64, lon Float64, sog Float64, port String, event_time DateTime, cog Float64, heading_to_port UInt8, distance Float64, category String, nav_status String, heading Float32) ENGINE = ReplacingMergeTree ORDER BY (mmsi, event_time) SETTINGS index_granularity = 8192. (TOO_MANY_UNEXPECTED_DATA_PARTS),. (ASYNC_LOAD_WAIT_FAILED) (version 25.8.1.1099 (official build))

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions