【详述】跨集群做数据迁移
【是否存算分离】 是
【StarRocks版本】例如：3.0.9
【联系方式】wx：JJ843238436
【问题描述】备份作业状态显示成功
MySQL [member_backup]> SHOW BACKUP \G;
*************************** 1. row ***************************
JobId: 21695377
SnapshotName: roi_commercial_info_detail_backup
DbName: member_backup
State: UPLOAD_SNAPSHOT
BackupObjs: [member_backup.roi_commercial_info_detail]
CreateTime: 2024-05-23 16:42:36
SnapshotFinishedTime: 2024-05-23 16:42:40
UploadFinishedTime: NULL
FinishedTime: NULL
UnfinishedTasks:
Progress:
TaskErrMsg:
Status: [OK]
Timeout: 86400
但是通过 SHOW SNAPSHOT ON member_backup_repo查看仓库对应的数据快照信息显示错误
MySQL [member_backup]> SHOW SNAPSHOT ON member_backup_repo;
±----------------------------------±----------±-------------------+
| Snapshot | Timestamp | Status |
±----------------------------------±----------±-------------------+
| member_backup_backup | | ERROR: no snapshot |
| order_info_backup | | ERROR: no snapshot |
| roi_commercial_info_detail_backup | | ERROR: no snapshot |
±----------------------------------±----------±-------------------+
问题出在什么地方？
备份还没结束，需要等Finished Time 有具体的时间了才是结束的状态，然后才能用show snapshot 命令查到备份的快照信息。