TiDB backup succeeded without any errors, but encountered "ranges overlapped" error during restoration

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB备份成功无任何报错,恢复的时候报错ranges overlapped

| username: TiDBer_eHko81Jh

[TiDB Usage Environment] Poc
[TiDB Version]
[Reproduction Path] Backup and Restore
[Encountered Issue: Backup succeeded without errors, but restore failed]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Logs/Monitoring]

[ERROR] [main.go:59] [“br failed”] [error=“ranges overlapped: [BR:Restore:ErrRestoreInvalidRange]invalid restore range”]

Has anyone encountered a similar issue? Urgent help needed, thanks!

| username: Billmay表妹 | Original post link

Refer to this.

| username: TiDBer_eHko81Jh | Original post link

Hi, thank you for your support!
The reference link you mentioned talks about the issue of log backup failure. I don’t quite understand how it is directly related to our issue. Could you please explain it further? Thanks!

| username: wangccsy | Original post link

Is it possible that the recovery environment is inconsistent (such as Regions, etc.)?

| username: 裤衩儿飞上天 | Original post link

The image you provided is not visible. Please provide the text you need translated.

| username: TiDBer_eHko81Jh | Original post link

Thank you for your support!
Restoring the original cluster should not result in data conflicts.

| username: TiDBer_eHko81Jh | Original post link

Thank you for your support!
We are performing a restoration of the original cluster.

| username: Kongdom | Original post link

:thinking: I don’t understand what “restore the original cluster” means. The person above means that restoration needs to be done to an empty cluster; if you restore to a cluster with existing data, it may cause data confusion. Note that this refers to an empty cluster, not an empty database under the cluster, because BR is a physical backup and restore.

| username: dba远航 | Original post link

When restoring, the original environment contains the same data.

| username: Jellybean | Original post link

error="ranges overlapped

This indicates that the data range being restored is duplicated, causing an exception.
When using BR to restore, it is required to restore to an empty cluster or a cluster without duplicate databases or tables, otherwise similar errors will occur.

You can delete the same databases or tables in the cluster to be restored, and then execute the BR restore operation again.