Failed to back up the database using the BR command, prompting "backup no leader"

Translated
1

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

Original topic: 使用BR命令备份库失败，提示backup no leader

| username: TiDBer_7E0yINhK

[TiDB Usage Environment] Production Environment
[TiDB Version]
[Encountered Issue]
An error occurs when executing the BACKUP command, indicating “backup no leader” (always reproducible). The logs specify a particular key, but I checked the TIKV_REGION_PEERS table and found that all regions have a leader.
[Reproduction Path] Execute the backup database command
[Attachments]

image
image1005×84 3.18 KB

image
image1308×464 10.5 KB

2
| username: xiaohetao | Original post link

Where did you execute this command?

This was executed in the shell command line br 命令行手册 | PingCAP 文档中心

3
| username: TiDBer_7E0yINhK | Original post link

I am using the backup command in SQL, the principle should be the same. BACKUP | PingCAP 文档中心

4
| username: xiaohetao | Original post link

Is it possible to successfully back up using the command line?

5
| username: TiDBer_7E0yINhK | Original post link

Ah, there’s no problem using the command line method. Thank you.

6
| username: xiaohetao | Original post link

You’re welcome. I also read the documentation, and according to it, backups should be possible in SQL mode as well. If it’s not working, I’m not sure what the issue could be.

7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.