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

add index failed with "Error 1105 (HY000): When the state is JobStateRollbackDone or JobStateCancelled, historyJob.Error should never be nil" when tidb rolling restart #54533

Closed
Lily2025 opened this issue Jul 10, 2024 · 6 comments
Assignees
Labels
component/ddl This issue is related to DDL of TiDB. impact/func-failure severity/critical type/bug This issue is a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Jul 10, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1、run sysbench
2、add index for one of table
3、tidb rolling restart

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

add index can success

3. What did you see instead (Required)

add index failed with "Error 1105 (HY000): When the state is JobStateRollbackDone or JobStateCancelled, historyJob.Error should never be nil"

and add index always failed with error when add index again
Error 1105 (HY000): open /var/lib/tidb-data/tmp_ddl-4000/604/11285e7b-8edb-5e07-9896-b33e42d492ec.sst/8f0d6d7d-351e-4c6c-93e4-900f93871a66.sst: no such file or directory

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v8.2.0-alpha
Edition: Community
Git Commit Hash: 1b872e5
Git Branch: heads/refs/tags/v8.2.0-alpha
UTC Build Time: 2024-07-08 11:46:28
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: unistore
2024-07-09T23:20:31.517+0800

@Lily2025 Lily2025 added the type/bug This issue is a bug. label Jul 10, 2024
@Lily2025
Copy link
Author

/assign tangenta

@Lily2025
Copy link
Author

/severity critical

@Lily2025
Copy link
Author

/remove-label may-affects-5.4
/remove-label may-affects-6.1
/remove-label may-affects-7.1
/remove-label may-affects-7.5
/remove-label may-affects-8.1

@Lily2025
Copy link
Author

/impact func-failure

@Lily2025
Copy link
Author

/remove-label may-affects-6.5

@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label Jul 11, 2024
@tangenta
Copy link
Contributor

Close by #54543

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/ddl This issue is related to DDL of TiDB. impact/func-failure severity/critical type/bug This issue is a bug.
3 participants