Force stop all backup-related tasks

Background

During routine operations, you may not be able to stop backup-related tasks. For example, the following operations may fail:

• Stop a backup task

  For more information, see Stop a backup.

• Stop a backup clearing task

  For more information, see Stop clearing backup data.

• Stop a secondary backup task

  For more information, see Stop a secondary backup.

• Stop a secondary backup clearing task

  For more information, see Stop clearing secondary backup data.

When you stop backup-related tasks by executing the CANCEL statement, if data read and write performance of the storage disk is normal, you must write the backup-related metadata to the disk.

If the execution of the CANCEL statement is suspended, it is likely that the performance of the storage disk is normal but the backup-related metadata cannot be written to the disk. The following two causes are possible:

• Backup data is manually deleted.

  In this case, ongoing backup-related tasks are suspended. This is because the metadata previously written to the disk no longer exists, but the storage medium is still readable and writable. As a result, the backup process is suspended, and the CANCEL statement cannot stop backup-related tasks.

• No network file system (NFS) is mounted to the server that runs RootService of the cluster, and backup data is written to the local disk.

  In this case, a leader/follower switchover is performed to switch RootService to a server that is mounted with NFS. At this moment, the external NFS storage disk is readable and writable but does not contain the backup metadata, which is written to the previous RootService server. As a result, the backup process is suspended, and the CANCEL statement cannot stop backup-related tasks.

Procedure

If you cannot stop a backup-related task by using the CANCEL statement, you can perform the following steps to force stop all backup-related tasks.

1. Log on to the sys tenant as the root user.

2. Execute the following statement to force stop all backup-related tasks:

   obclient> ALTER SYSTEM CANCEL ALL BACKUP FORCE;
   

   The CANCEL statement does not depend on the availability of external storage media. The system directly stops all backup-related tasks.

   Notice

   The effective scope of the force-stop statement: The force-stop CANCEL statement takes effect when you execute it as the database administrator to stop tasks such as archiving and backup tasks. However, this CANCEL statement does not take effect if backup data is missing or an NFS data error has occurred.

What to do next

After you force stop all backup-related tasks, you must reset the backup destination and secondary backup destination. For more information, see Preparations for backup and Preparations for secondary backup.