Backup failed but cannot be canceled, subsequent backups are also in wait state

Translated
1

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

Original topic: backup 失败却无法cancel掉，后续的backup也处于wait状态。

| username: jarry_618

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Issue Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】

image
image1764×685 21.8 KB

Initially, the error occurred because there were already files in the backup directory. After deleting the files and attempting to back up again, it remained in a wait state. Using show backups, I tried to cancel all these backups, but it also failed.

2
| username: ffeenn | Original post link

When backing up, check permissions and whether the directory is empty (usually set to a directory in the format of the time command). Also, why not use BR?

3
| username: jarry_618 | Original post link

It’s NFS, and all clients can write. The directory has been checked to be empty.
We have to learn both backup methods… :sweat_smile:

4
| username: ffeenn | Original post link

SHOW PROCESSLIST; Check if the window where you executed the command is closed.

5
| username: ffeenn | Original post link

Check the documentation, it’s a persistent connection. Try killing TiDB {ID}.

6
| username: WalterWj | Original post link

Try restarting the tidb-server node…

7
| username: ffeenn | Original post link

This method is brutally effective.

8
| username: system | Original post link

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