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: pitr restore failed. scan region return empty result #42001

Closed
AkiraXie opened this issue Mar 8, 2023 · 2 comments · Fixed by #42182
Closed

br: pitr restore failed. scan region return empty result #42001

AkiraXie opened this issue Mar 8, 2023 · 2 comments · Fixed by #42182
Assignees
Labels
affects-6.2 affects-6.5 component/br This issue is related to BR of TiDB. severity/critical type/bug The issue is confirmed as a bug.

Comments

@AkiraXie
Copy link

AkiraXie commented Mar 8, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

[2023/03/07 12:52:48.921 +00:00] [INFO] [collector.go:73] ["restore log failed summary"] [error="failed to restore kv files: scan region return empty result, startKey: 74800000000000F9FF675F72800000000EFF7AB9830000000000FA, endKey: 74800000000000F9FF675F72800000000EFF82: [BR:PD:ErrPDBatchScanRegion]batch scan region"] errorVerbose="[BR:PD:ErrPDBatchScanRegion]batch scan region\nscan region return empty result, startKey: 74800000000000F9FF675F72800000000EFF7AB9830000000000FA, endKey: 74800000000000F9FF675F72800000000EFF82[ngithub.com/pingcap/tidb/br/pkg/restore/split.CheckRegionConsistency\n\t/data2/lc/tidb/br/pkg/restore/split/split.go:49\ngithub.com/pingcap/tidb/br/pkg/restore/split.PaginateScanRegion.func1\n\t/data2/lc/tidb/br/pkg/restore/split/split.go:114\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetry\n\t/data2/lc/tidb/br/pkg/utils/retry.go:52\ngithub.com/pingcap/tidb/br/pkg/restore/split.PaginateScanRegion\n\t/data2/lc/tidb/br/pkg/restore/split/split.go:91\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runOverRegions\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:141\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:183\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\ngithub.com/pingcap/tidb/br/pkg/restore.(*OverRegionsInRangeController).runInRegion\n\t/data2/lc/tidb/br/pkg/restore/import_retry.go:177\nfailed to restore kv files"]
Error: failed to restore kv files: scan region return empty result, startKey: 74800000000000F9FF675F72800000000EFF7AB9830000000000FA, endKey: 74800000000000F9FF675F72800000000EFF82: [BR:PD:ErrPDBatchScanRegion]batch scan region

4. What is your TiDB version? (Required)

release-6.5

@AkiraXie AkiraXie added the type/bug The issue is confirmed as a bug. label Mar 8, 2023
@seiya-annie seiya-annie added component/br This issue is related to BR of TiDB. severity/critical labels Mar 8, 2023
@ti-chi-bot ti-chi-bot added 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.1 may-affects-6.5 labels Mar 8, 2023
@joccau
Copy link
Member

joccau commented Mar 13, 2023

/assigned

@joccau joccau self-assigned this Mar 13, 2023
@joccau joccau added affects-6.2 affects-6.3 affects-6.4 affects-6.5 affects-6.6 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.1 may-affects-6.5 affects-6.3 affects-6.4 affects-6.6 labels Mar 14, 2023
@tonyxuqqi
Copy link

Do we know the root cause of the slow splitting region?

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

Successfully merging a pull request may close this issue.

5 participants