Backup KV Data Failed

Translated
1

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

Original topic: br 备份kv数据失败

| username: TiDBer_mHZrDnWq

【TiDB Usage Environment】Production Environment
【TiDB Version】7.1.5
【Reproduction Path】br backup raw --pd core0:4379 --storage=local:///qingstor/bak/ --format “raw”
【Encountered Problem: Phenomenon and Impact】Full KV data backup using br backup raw completed without errors, but the backup result is empty.
【Resource Configuration】Navigate to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】

image
image1579×690 92.2 KB

image
image1591×465 36 KB

image
image1380×416 92.6 KB

image
image1582×359 31.3 KB

br.log.2024-06-14T09.38.08+0800 (6.8 KB)

2
| username: ziptoam | Original post link

Check the BR logs, you should be able to perform some reconciliation analysis.

3
| username: WalterWj | Original post link

I recommend trying to keep the source and target database versions the same for BR backup and restore.

It seems that the backup did not report any errors, but the target directory is empty?
Since you are using local, you need to check the corresponding directory on the TiKV node.

I recommend using S3 protocol storage for this.

4
| username: TiDBer_mHZrDnWq | Original post link

The S3 protocol is still being tested. The local backup files are indeed empty, and the backup directories of each node have been checked.

5
| username: Kamner | Original post link

Are you using rawkv?

Isn’t the normal backup done with br backup full?

6
| username: Hacker_zuGnSsfP | Original post link

Isn’t it possible to directly back up the SQL?