ClickHouse / ClickHouse/ClickHouse

Why lightweight delete takes up more disk space in 24.3?

Open
#63,107 3 comments 0 reactions 0 assignees View on GitHub
comp-mutations external question
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
20h 33m
Merged PRs (30d)
501

Description

I have a simple test procedure:

I create a table on a small disk and fill it up with data almost completely, so just a little amount of memory is left.
I have 10 partitions. 150_000 rows per partition.
Then I try to delete all the partition one by one with lightweight `DELETE`.
On 24.2 I have successfully deleted all the rows.
On 24.3 I got NOT_ENOUGH_SPACE on the 4th partition.
```
Code: 341. DB::Exception: Received from localhost:9000. DB::Exception: Exception happened during execution of mutation 'mutation_16.txt' with part '8_10_10_0_15' reason: 'Code: 243. DB::Exception: Cannot reserve 593.66 KiB, not enough space. (NOT_ENOUGH_SPACE) (version 24.3.2.23 (official build))'. This error maybe retryable or not. In case of unretryable error, mutation can be killed with KILL MUTATION query. (UNFINISHED)
```
With 300_000 rows per partition:
On 24.2 I got NOT_ENOUGH_SPACE on 8th partition.
On 24.3 client froze on second partition.

What might have cause this change between version?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.