为了更快的定位您的问题,请提供以下信息,谢谢
【详述】从HDFS恢复表报错:
get nothing from remote path: hdfs://x.x.x.x:8020/starrocks/order_list/__starrocks_repository_repo_gbx_01/__ss_repo_gbx_01/__ss_content/__db_10196/__tbl_55741/__part_55740/__idx_55742/__55759]
【背景】测试数据库备份恢复
【业务影响】
【是否存算分离】否
【StarRocks版本】例如:3.1.4
【集群规模】例如:3fe+3be(fe与be混部)
【具体操作】:
– 创建备份仓库REPOSITORY
CREATE REPOSITORY repo_gbx_01
WITH BROKER
ON LOCATION “hdfs://x.x.x.x:8020/starrocks/order_list”;
– 查看仓库REPOSITORY
show repositories;
– 备份di_dmp库order_list表
BACKUP SNAPSHOT di_dmp.repo_gbx_01
TO repo_gbx_01
ON(order_list);
– 查看备份进度:
SHOW backup from di_dmp;
– 查看快照信息
SHOW SNAPSHOT ON repo_gbx_01
– 在新集群恢复数据
mysql -h x.x.x.x -P 9030 -uroot -p
CREATE REPOSITORY repo_gbx_01
WITH BROKER
ON LOCATION “hdfs://x.x.x.x:8020/starrocks/order_list”;
create database di_dmp;
RESTORE SNAPSHOT di_dmp.repo_gbx_01
FROM repo_gbx_01
PROPERTIES (
“backup_timestamp”=“2024-01-22-16-18-55-624”,
“replication_num” = “1”
);
– 查看恢复进度:
SHOW RESTORE from di_dmp;
TaskErrMsg报错:
get nothing from remote path: hdfs://x.x.x.x:8020/starrocks/order_list/__starrocks_repository_repo_gbx_01/__ss_repo_gbx_01/__ss_content/__db_10196/__tbl_55741/__part_55740/__idx_55742/__55759]