Purpose
The ALTER SYSTEM CANCEL VALIDATE statement is used to cancel a task that is currently being executed.
Privilege requirements
This statement must be executed by the root user of the sys tenant (root@sys) or the administrator of each tenant. Specifically:
- In MySQL mode, the default administrator is the
rootuser. - In Oracle mode, the default administrator is the
SYSuser.
Syntax
ALTER SYSTEM CANCEL VALIDATE BACKUP [TENANT = mysql_tenant];
Parameters
| Parameter | Description |
|---|---|
| TENANT | Specifies the user tenant whose validation task is to be canceled. This parameter can only be specified by the system tenant. If not specified, the system tenant will cancel all validation tasks being executed across all user tenants in the cluster. |
Examples
The system tenant cancels the backup validation task being executed by a user tenant.
The system tenant cancels the backup validation task being executed by all user tenants.
obclient(root@sys)[(none)]> ALTER SYSTEM CANCEL VALIDATE BACKUP;The system tenant cancels the backup validation task being executed by the specified user tenant
mysqltenant.obclient(root@sys)[(none)]> ALTER SYSTEM CANCEL VALIDATE BACKUP TENANT = mysqltenant;
The user tenant cancels the backup validation task being executed by itself.
obclient> ALTER SYSTEM CANCEL VALIDATE BACKUP;
