创建oss 备份后无法恢复

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述 创建oss 备份后无法恢复到本地
【背景】做过哪些操作?创建仓库,备份后执行恢复报错

【StarRocks版本】例如:3.15
【集群规模】例如:3fe(1 follower+2observer)+3be(fe与be混部)
【表模型】例如:聚合模型
【导入或者导出方式】例如:Flink
CREATE REPOSITORY tjn
WITH BROKER
ON LOCATION “oss://sr-back/”
PROPERTIES(
“fs.oss.accessKeyId” = “",
“fs.oss.accessKeySecret” = "
”,
“fs.oss.endpoint” = “oss-cn-beijing.aliyuncs.com
);

BACKUP SNAPSHOT st_status.tjn20231211type
TO tjn
on (st_stats_visitor_type);

RESTORE SNAPSHOT st_status.tjn20231210type
FROM st_buck_test
ON (st_stats_visitor_type)
PROPERTIES (
“backup_timestamp”=“2023-12-10-13-08-29-012”
);

CREATE TABLE IF NOT EXISTS st_stats_visitor_type (

pv int(11) DEFAULT “0” COMMENT “pv总数”,

uv int(11) DEFAULT “0” COMMENT “uv总数”,

ip int(11) DEFAULT “0” COMMENT “ip总数”,

vv int(11) DEFAULT “0” COMMENT “会话总数”,

bounce int(11) DEFAULT “0” COMMENT “跳出总数”,

duration int(11) DEFAULT “0” COMMENT “浏览时长”,

date DATE COMMENT ‘创建时间-日期’,

month int DEFAULT “0” COMMENT ‘创建时间-月’,

hour int DEFAULT “0” COMMENT ‘创建时间-时’,

week int DEFAULT “0” COMMENT ‘创建时间-周’,

star_time datetime COMMENT “统计时间”,

end_time datetime COMMENT “统计时间”,

domain_id bigint(20) COMMENT “网站ID”,

user_id bigint(20) COMMENT “用户id”,

referer_type tinyint(4) COMMENT “来路类型,1:直接访问,2:搜索引擎,3:外部链接”,

referer_domain varchar(255) COMMENT “来路域名,直接访问为空,搜索引擎为引擎id,外部链接为外部域名”,

province varchar(64) COMMENT “省”,

city varchar(64) COMMENT “城市”,

country varchar(64) COMMENT “国家”,

client_type tinyint(4) DEFAULT “0” COMMENT “客户端类型,0为电脑端,1为移动端”,

type tinyint(4) COMMENT “访客类型:0为新访客,1为老访客”

) ENGINE=OLAP

DUPLICATE KEY(pv, uv, ip, vv, bounce, duration)

COMMENT “访客类型统计表”

PARTITION BY RANGE (star_time) (

START ("2023-09-01") END ("2030-01-01") EVERY (INTERVAL 1 DAY)

)

DISTRIBUTED BY HASH(domain_id)

PROPERTIES (

“replication_num” = “3”,

“in_memory” = “false”,

“enable_persistent_index” = “false”,

“replicated_storage” = “true”,

“compression” = “ZSTD”

);

报这个错

BACKUP是成功的吗?show backup和 SHOW SNAPSHOT 看看吧

image

昨天正常的时候我就一直报哪个错,执行不了

可能是 backup 的集群版本太老,新版本不再兼容了