【详述】starrocks分区表备份到oss报错
【背景】做过哪些操作？
-
创建 repository
CREATE REPOSITORY sr_backup_repository
WITH BROKER
ON LOCATION “oss://test-datacenter-sr-backup-forever/dataworker_db”
PROPERTIES(
“fs.oss.accessKeyId” = “LTAI5tFgAWxxx”,
“fs.oss.accessKeySecret” = “rW7doM8xxx”,
“fs.oss.endpoint” = “oss-cn-shenzhen-internal.aliyuncs.com”
);
show repositories; 正常
-
root用户登录mysql client后执行备份操作
BACKUP SNAPSHOT dataworker_db.ads_eip_amz_ads_hourly_stream_snapshot_20250106
TO sr_backup_repository
ON (ads_eip_amz_ads_hourly_stream PARTITION (p20241206)); -
执行 show backup 发现报错
| 7463119 | ads_eip_amz_ads_hourly_stream_snapshot_20250106 | dataworker_db | UPLOADING | [dataworker_db.ads_eip_amz_ads_hourly_streamPARTITIONS (p20241206)] | 2025-01-06 18:37:26 | 2025-01-06 18:37:29 | NULL | NULL | 7463121=11266, 7463120=11266, 7463123=11267, 7463122=11266, 7463125=11267, 7463124=11267, 7463127=11262, 7463126=11262, 7463129=11262, 7463128=11262 | [7463121: 0/0], [7463120: 0/0], [7463123: 0/0], [7463122: 0/0], [7463125: 0/0], [7463124: 0/0], [7463127: 0/0], [7463126: 0/0], [7463129: 0/0], [7463128: 0/0] | [7463121: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448093: The OSS Access Key Id you provided does not exist in our records.], [7463120: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448102: The OSS Access Key Id you provided does not exist in our records.], [7463123: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448096: The OSS Access Key Id you provided does not exist in our records.], [7463122: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448111: The OSS Access Key Id you provided does not exist in our records.], [7463125: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448105: The OSS Access Key Id you provided does not exist in our records.], [7463124: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448114: The OSS Access Key Id you provided does not exist in our records.], [7463127: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448117: The OSS Access Key Id you provided does not exist in our records.], [7463126: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448099: The OSS Access Key Id you provided does not exist in our records.], [7463129: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448108: The OSS Access Key Id you provided does not exist in our records.], [7463128: S3: fail to list oss://test-datacenter-sr-backup-forever/dataworker_db/__starrocks_repository_sr_backup_repository/__ss_ads_eip_amz_ads_hourly_stream_snapshot_20250106/__ss_content/__db_11401/__tbl_7447966/__part_7448089/__idx_7447967/__7448090: The OSS Access Key Id you provided does not exist in our records.] | [OK] | 86400 |
accessKeyId accessKeySecret endpoint 确定没有配错
【StarRocks版本】2.5.13
【集群规模】例如：3fe（3 follower）+3be（fe与be混部）
【机器信息】16核64G