-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Clickhouse Update mutation randomly stucks #6549
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasenot plannedKnown issue, no plans to fix it currenltyKnown 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.We need extra data to continue (waiting for response). Either some details or a repro of the issue.
Description
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?
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasenot plannedKnown issue, no plans to fix it currenltyKnown 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.We need extra data to continue (waiting for response). Either some details or a repro of the issue.