ClickHouse / ClickHouse/ClickHouse
Why lightweight delete takes up more disk space in 24.3?
- 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
Assessment
This issue has not been assessed yet.