SHOW RESTORE

Description

This statement is used to view the RESTORE task

SHOW RESTORE [FROM db_name];

Description of return results

• JobId: unique job id.
• Label: the name of the backup to be restored.
• Timestamp: time version of the backup to be restored.
• DbName: database belonged to.

• State: current stage.

  • PENDING: initial state after job submission.
  • SNAPSHOTING: executing snapshot.
  • DOWNLOAD: snapshot completed, ready to download the snapshot in the respository.
  • DOWNLOADING: snapshot is being downloaded.
  • COMMIT: snapshot download completed, ready to take effect.
  • COMMITING: in effect.
  • FINISHED: job finished successfully.
  • CANCELLED: job failed.
• AllowLoad: whether to allow load during recovery (currently not supported).
• ReplicationNum: specify the number of replication to recover.
• RestoreJobs：tables and partitions to recover.
• CreateTime：task submission time.
• MetaPreparedTime：completion time of metadata preparation.
• SnapshotFinishedTime：snapshot finished time.
• DownloadFinishedTime：snapshot downloading finished time.
• FinishedTime：job finished time.
• UnfinishedTasks：unfinished subtask id will be displayed in snapshot, download, and COMMITING phases.
• Status：if the job fails, show the failure information.
• Timeout：timeout period of job, in seconds.

Example

1. View the latest RESTORE task under example_db.

   SHOW RESTORE FROM example_db;

keywords

SHOW, RESTORE

​