ClickHouse: Clickhouse Update mutation randomly stucks
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?
About this issue
- Original URL
- State: closed
- Created 5 years ago
- Reactions: 3
- Comments: 39 (18 by maintainers)
Commits related to this issue
- Added a test for #6549 — committed to ClickHouse/ClickHouse by alexey-milovidov 4 years ago
- Merge pull request #11820 from ClickHouse/added-test-for-mutations-after-freeze Added a test for #6549 — committed to ClickHouse/ClickHouse by alexey-milovidov 4 years ago
- Merge branch 'master' into ldap-per-user-authentication * master: (114 commits) Update alter.md (#11823) Update PODArray.h Added a test for #6549 Update create.md Update create.md replaci... — committed to traceon/ClickHouse by traceon 4 years ago
@const-shi
No, it will be replicated as new files and backup will not be modified. And it cannot - because we have made FREEZE 😃