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

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】

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.

| 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?

| 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:

| username: ffeenn | Original post link

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

| username: ffeenn | Original post link

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

| username: WalterWj | Original post link

Try restarting the tidb-server node…

| username: ffeenn | Original post link

This method is brutally effective.

| username: system | Original post link

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