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

br: Incremental restore failed to execute DDL which contains tableAttributes in the cluster v5.0 #29359

Closed
joccau opened this issue Nov 2, 2021 · 1 comment · Fixed by #29360
Assignees
Labels
affects-5.3 This bug affects 5.3.x versions. component/br This issue is related to BR of TiDB. severity/critical type/bug The issue is confirmed as a bug.

Comments

@joccau
Copy link
Member

joccau commented Nov 2, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. Make full backup in the cluster of v5.3.0-alpha TiKV with v5.3.0-alpha br
  2. Do DDL sql alter table t attributes ”merge_option=allow”
  3. Make incremental backup in the cluster of V5.3.0
  4. Make full restore in the cluster of v5.0.0 TiKV with v5.0.0 br
  5. Make incremental restore in the cluster of V5.0.0

Finally the step 5 failed.

[2021/11/02 18:15:43.877 +08:00] [ERROR] [restore.go:35] ["failed to restore"] [error="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 28 near \"attributes \"merge_option=allow\"\" "] [errorVerbose="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 28 near \"attributes \"merge_option=allow\"\" \ngithub.com/pingcap/errors.AddStack\n\tgithub.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174\ngithub.com/pingcap/errors.

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

@joccau joccau added the type/bug The issue is confirmed as a bug. label Nov 2, 2021
@jebter jebter added component/br This issue is related to BR of TiDB. severity/critical labels Nov 3, 2021
@joccau joccau changed the title br: Incremental restore failed to execute DDL contains tableAttributes in the cluster v5.0 failed br: Incremental restore failed to execute DDL which contains tableAttributes in the cluster v5.0 Nov 3, 2021
@github-actions
Copy link

github-actions bot commented Nov 4, 2021

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.3 This bug affects 5.3.x versions. component/br This issue is related to BR of TiDB. severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
3 participants