Skip to content

Clickhouse Update mutation randomly stucks #6549

@thyn

Description

@thyn

I'm trying to update some values (no distribution) (table size 300Gb)

ClickHouse server version 19.13.2 revision 54425.

alter table actions
 UPDATE quality = 'val' WHERE (category = 'account') AND (name = 'true_buy') AND (quality = '') 

I'm getting at random parts.

8 │ 0 │ 20190715_26845_28450_4_196813 │ 2019-08-19 10:51:14 │ Code: 76, e.displayText() = DB::ErrnoException: Cannot open file /data/clickhouse/data/actions/actions/tmp_mut_20190715_26845_28450_4_196816/quality.mrk, errno: 13, strerror: Permission denied (version 19.13.2.19)
Mostly I have errors on latest data

Am I missing something?

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official releasenot plannedKnown issue, no plans to fix it currenltyst-need-infoWe need extra data to continue (waiting for response). Either some details or a repro of the issue.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions