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

Pipelined DML do not abort after 24h #53011

Closed
you06 opened this issue Apr 30, 2024 · 0 comments · Fixed by #53012
Closed

Pipelined DML do not abort after 24h #53011

you06 opened this issue Apr 30, 2024 · 0 comments · Fixed by #53012
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.

Comments

@you06
Copy link
Contributor

you06 commented Apr 30, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Run a large pipelined DML last over 24 hours.

2. What did you expect to see? (Required)

The transaction fail once 24 hours exceeded.

3. What did you see instead (Required)

The transaction runs until it start commiting PK, and finally failed by LockNotFound error.

[2024/04/25 14:59:32.375 +08:00] [WARN] [session.go:828] ["commit failed"] [conn=3040870406] [session_alias=] ["finished txn"="Txn{state=invalid}"] [error="[kv:8022]Error: KV error safe to retry Error(Txn(Error(Mvcc(Error(TxnLockNotFound { start_ts: TimeStamp(449298094747811842), commit_ts: TimeStamp(449322253637386243), key: [116, 128, 0, 0, 0, 0, 0, 4, 142, 95, 105, 128, 0, 0, 0, 0, 0, 0, 1, 3, 128, 0, 0, 0, 0, 31, 186, 195, 3, 128, 0, 0, 1, 49, 76, 50, 8] }))))) {tableID=1166, indexID=1, indexValues={2079427, 5122044424, }} [try againlater]"]

4. What is your TiDB version? (Required)

618cfbc

@you06 you06 added type/bug The issue is confirmed as a bug. severity/major affects-8.1 This bug affects the 8.1.x(LTS) versions. labels Apr 30, 2024
ti-chi-bot bot pushed a commit that referenced this issue May 1, 2024
3AceShowHand pushed a commit to 3AceShowHand/tidb that referenced this issue May 7, 2024
@jebter jebter added the sig/transaction SIG:Transaction label May 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants