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

System table restore failed #29710

Closed
XuJianxu opened this issue Nov 12, 2021 · 2 comments · Fixed by #29730
Closed

System table restore failed #29710

XuJianxu opened this issue Nov 12, 2021 · 2 comments · Fixed by #29730
Assignees
Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. component/br This issue is related to BR of TiDB. found/automation Found by automation tests severity/major type/bug The issue is confirmed as a bug.

Comments

@XuJianxu
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  • Execute full backup.
  • Execute full restore.
  • Check the system table.

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

System table will restore success.

3. What did you see instead (Required)

System table haven't restore

4. What is your TiDB version? (Required)

v5.3.0

@joccau
Copy link
Member

joccau commented Nov 12, 2021

The reason of fail to restore system table is that the schema name is incorrect during backup, which is caused by concurrent operation of "add temporary-prefix into system schema name".

[2021/11/12 14:30:15.438 +08:00] [INFO] [validate.go:78] ["checksum success"] [db=__TiDB_BR_Temporary___TiDB_BR_Temporary___TiDB_BR_Temporary_mysql] [table=capture_plan_baselines_blacklist] [2021/11/12 14:30:15.438 +08:00] [INFO] [validate.go:78] ["checksum success"] [db=__TiDB_BR_Temporary___TiDB_BR_Temporary___TiDB_BR_Temporary_mysql] [table=stats_fm_sketch] [2021/11/12 14:30:15.438 +08:00] [INFO] [validate.go:78] ["checksum success"] [db=__TiDB_BR_Temporary___TiDB_BR_Temporary___TiDB_BR_Temporary_mysql] [table=tidb]

@github-actions
Copy link

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-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. component/br This issue is related to BR of TiDB. found/automation Found by automation tests severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
4 participants