-
Notifications
You must be signed in to change notification settings - Fork 5.8k
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
add index rollback when tidb rolling restart #52805
Closed
Labels
affects-7.1
affects-7.5
affects-8.1
component/ddl
This issue is related to DDL of TiDB.
severity/major
type/bug
This issue is a bug.
Comments
/assign tangenta |
13 tasks
13 tasks
13 tasks
terry1purcell
pushed a commit
to terry1purcell/tidb
that referenced
this issue
May 17, 2024
RidRisR
pushed a commit
to RidRisR/tidb
that referenced
this issue
May 23, 2024
13 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
affects-7.1
affects-7.5
affects-8.1
component/ddl
This issue is related to DDL of TiDB.
severity/major
type/bug
This issue is a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
1、with tidb_enable_dist_task='off'
2、run sysbench
3、add index for one of table
4、tidb rolling restart
logs:
tidb-0.tar.gz
tidb-1.tar.gz
2. What did you expect to see? (Required)
add index can success
3. What did you see instead (Required)
add index rollback when tidb rolling restart
the status of ddl job is not synced or done or running or queueing (now: 2024-04-20 07:12:03, jobId: 586, job type: add index /* ingest /, state: rollback done)
operatorLogs:
[2024-04-20 07:08:32] ###### start adding index
ALTER TABLE
sbtest1
ADD INDEXindex_test_1713568112880
(c
)[2024-04-20 07:08:32] ###### wait for ddl job finish
[2024-04-20 07:12:03] ###### wait for ddl job to finish failed
select job_id, job_type, state from information_schema.ddl_jobs where query = 'ALTER TABLE
sbtest1
ADD INDEXindex_test_1713568112880
(c
)'jobId: 586, job type: add index / ingest */, state: rollback done
4. What is your TiDB version? (Required)
./tidb-server -V
Release Version: v7.1.5
Edition: Community
Git Commit Hash: f4faa50
Git Branch: HEAD
UTC Build Time: 2024-04-19 10:49:04
GoVersion: go1.20.10
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore
2024-04-20T07:08:24.815+0800
The text was updated successfully, but these errors were encountered: