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.

Sign up for GitHub

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

Jump to bottom

Br:6.2 restore to tidb:6.1 failed due to Error: [schema:1146]Table 'mysql.tidb_ddl_job' doesn't exist #36453

Closed
AkiraXie opened this issue Jul 22, 2022 · 4 comments · Fixed by #36474
Closed

Br:6.2 restore to tidb:6.1 failed due to Error: [schema:1146]Table 'mysql.tidb_ddl_job' doesn't exist #36453

AkiraXie opened this issue Jul 22, 2022 · 4 comments · Fixed by #36474
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.2 component/br This issue is related to BR of TiDB. feature/developing the related feature is in development found/automation Found by automation tests severity/critical type/bug The issue is confirmed as a bug.

Comments

@AkiraXie
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. use br:6.2 backup data from tidb:6.2
  2. use br:6.2 restore data to tidb:6.1

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

restore ok

3. What did you see instead (Required)

restore failed
YFgtBLvaqp

4. What is your TiDB version? (Required)

br version

tiup br:nightly -V
Release Version: v6.2.0-alpha
Git Commit Hash: 121a666
Git Branch: heads/refs/tags/v6.2.0-alpha
Go Version: go1.18.2
UTC Build Time: 2022-07-22 00:04:20
Race Enabled: false

tidb version

select tidb_version()
Release Version: v6.1.0
Edition: Community
Git Commit Hash: 1a89dec
Git Branch: heads/refs/tags/v6.1.0
UTC Build Time: 2022-06-05 05:15:11
GoVersion: go1.18.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
@AkiraXie AkiraXie added the type/bug The issue is confirmed as a bug. label Jul 22, 2022
@AkiraXie
Copy link
Author

/component br

@ti-chi-bot ti-chi-bot added the component/br This issue is related to BR of TiDB. label Jul 22, 2022
@AkiraXie
Copy link
Author

AkiraXie commented Jul 22, 2022 •
edited
Loading

/severity critical

@ti-chi-bot ti-chi-bot added severity/major may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 labels Jul 22, 2022
@fubinzh fubinzh added feature/developing the related feature is in development and removed component/br This issue is related to BR of TiDB. labels Jul 22, 2022
@AkiraXie
Copy link
Author

/remove-severity major

@3pointer 3pointer mentioned this issue Jul 22, 2022
Merged
12 tasks
@3pointer 3pointer added affects-6.2 and removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 labels Jul 22, 2022
@3pointer
Copy link
Contributor

It also makes BR:v6.1.0 restore to TiDB:v6.2.0 stuck. To fix it completely we need add a check in 6.1.1

@3pointer 3pointer added the affects-6.1 This bug affects the 6.1.x(LTS) versions. label Jul 22, 2022
ti-chi-bot pushed a commit that referenced this issue Jul 23, 2022
@3pointer
br: fix compatibility issue with concurrent ddl (#36474)
28a8ffc 
close #36453
This was referenced Jul 23, 2022
Closed
Merged
ti-chi-bot pushed a commit that referenced this issue Jul 25, 2022
@ti-srebot
br: fix compatibility issue with concurrent ddl (#36474) (#36489)
2fde17e 
close #36453
@fubinzh fubinzh added component/br This issue is related to BR of TiDB. found/automation Found by automation tests labels Jul 28, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.2 component/br This issue is related to BR of TiDB. feature/developing the related feature is in development found/automation Found by automation tests severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

br: fix compatibility issue with concurrent ddl 3pointer/tidb
4 participants
@3pointer @fubinzh @AkiraXie @ti-chi-bot