Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Concurrent lightweight delete and attach detach partition. #50922

Open
antip00 opened this issue Jun 13, 2023 · 0 comments
Open

Concurrent lightweight delete and attach detach partition. #50922

antip00 opened this issue Jun 13, 2023 · 0 comments
Labels
question Question?

Comments

@antip00
Copy link

antip00 commented Jun 13, 2023

I have a test for lightweight delete, I perform concurrent lightweight delete in loop and attach, detach partition in loop.
I create MergeTree table, insert data into it, then concurrently:

  1. I perform lightweight delete for each partition in loop for some data in each partition(not all the data).
  2. I perform attach detach one partition in loop.
    Then I check that data deleted in every partition or deleted in every partition except detached

This test can fail in 2 ways:

  1. Concurrent detach partition and lightweight delete can cause this exception
    Code: 341. DB::Exception: Received from localhost:9000. DB::Exception: Exception happened during execution of mutation 'mutation_12.txt' with part '6_7_7_0_11' reason: 'Code: 236. DB::Exception: Cancelled mutating parts. (ABORTED) (version 23.3.2.37 (official build))'. This error maybe retryable or not. In case of unretryable error, mutation can be killed with KILL MUTATION query. (UNFINISHED).
  2. Data in detached partition may disappear completely after attach partition.

Tested on 23.3.2.37-alpine
on 22.8 it works

Manually it is very hard to catch this fails.

@antip00 antip00 added the question Question? label Jun 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Question?
Projects
None yet
Development

No branches or pull requests

1 participant