Through backup, the show backups command does not display information when connected to a non-backup TiDB server

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

Original topic: 通过backup备份,show backups命令连非备份的tidb server看不到信息

| username: 我是咖啡哥

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] V7.1.0
[Reproduction Path]

BACKUP DATABASE `test` TO 's3://xxx/tidb-backup/test/?access-key=xx&secret-access-key=xxx&endpoint=https://obs.xxx.myhuaweicloud.com';

[Encountered Problem: Problem Phenomenon and Impact]
There are 2 TiDB server nodes. When backing up using the backup command, the information can be seen on the TiDB node connected to the backup, but when connecting to another TiDB server node, the query is empty.

Node 217: Information is available

Node 237: No information

Is the information related to the backup command retained on the TiDB server node?

| username: 像风一样的男子 | Original post link

The BACKUP command is executed on TiDB nodes, just like SQL.

| username: 我是咖啡哥 | Original post link

Yes, but why can the information only be viewed on the backup node? Shouldn’t this be stored on the TiKV nodes?

| username: 像风一样的男子 | Original post link

Executing tasks will not write to disk.

| username: 我是咖啡哥 | Original post link

Where is it saved?

| username: redgame | Original post link

That’s the one on the backup node.

| username: zhanggame1 | Original post link

The meaning of “not landing on disk” is that it stays in memory.

| username: system | Original post link

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