【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】OB
【 使用版本 】OceanBase4.3.1社区版
【问题描述】设置minio作为数据备份提示:9026- backup destination is not valid
【复现路径】执行以下指令对Oceanbase进行数据备份,报错:9026- backup destination is not valid
obclient [(none)]> ALTER SYSTEM SET DATA_BACKUP_DEST='s3://minio-oceanbase/backup/data?
'> host=http://192.168.114.129:11010
'> &access_id=xxxxxx
'> &access_key=xxxxxx
'> &s3_region=xxx
'> &delete_mode=delete';
ERROR 9026 (HY000): backup destination is not valid
去掉"&s3_region=xxx"和"&delete_mode=delete’;"的部分,报一样的错误
通过grep rootservice.log查看日志信息如下:
[2024-07-31 16:39:07.642460] WDIAG [STORAGE] set (ob_storage_info.cpp:139) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=8][errcode=-9026] backup device is not nfs, endpoint/access_id/access_key do not allow to be empty(ret=-9026, device_type=4, endpoint="", access_id="access_id=admin
[2024-07-31 16:39:07.642479] WDIAG [SHARE] parse_backup_dest_str_ (ob_backup_struct.cpp:1399) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=18][errcode=-9026] failed to init storage_info(ret=-9026, type=4, pos=33, backup_dest="s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642498] WDIAG [SHARE] set (ob_backup_struct.cpp:1419) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=18][errcode=-9026] failed to parse backup dest str(ret=-9026, backup_dest="s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642515] WDIAG [SHARE] set_without_decryption (ob_backup_struct.cpp:1548) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=16][errcode=-9026] fail to set backup dest(ret=-9026)
[2024-07-31 16:39:07.642530] WDIAG [SHARE] parse_from (ob_backup_config.cpp:406) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=13][errcode=-9026] fail to set backup dest(ret=-9026)
[2024-07-31 16:39:07.642536] WDIAG [SHARE] init (ob_backup_config.cpp:345) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=4][errcode=-9026] fail to parse value(ret=-9026, type={type:0}, value=s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642545] WDIAG [RS] admin_set_backup_config (ob_root_service.cpp:11215) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=7][errcode=-9026] fail to init backup config parser mgr(ret=-9026, item={name:"data_backup_dest", value:"s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642684] INFO [STORAGE.TRANS] rollback_tx (ob_tx_api.cpp:365) [29912][T1_L0_G0][T1003][YB420AA0AB09-00061E602A0FC511-0-0] [lt=10] rollback tx(ret=0, *this={is_inited_:true, tenant_id_:1003, this:0x7faec5e04030}, tx={this:0x7faf9a1c7d90, tx_id:{txid:2009365}, state:7, addr:"192.168.114.128:2882", tenant_id:1003, session_id:1, assoc_session_id:1, xid:NULL, xa_mode:"", xa_start_addr:"0.0.0.0:0", access_mode:0, tx_consistency_type:0, isolation:1, snapshot_version:{val:18446744073709551615, v:3}, snapshot_scn:0, active_scn:{branch:0, seq:1}, op_sn:3, alloc_ts:1722415147642125, active_ts:1722415147642125, commit_ts:-1, finish_ts:1722415147642125, timeout_us:119998692, lock_timeout_us:-1, expire_ts:1722415267640817, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1722247714, cluster_version:17180066048, seq_base:1722415147642124, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, cflict_txs:[], abort_cause:-6002, commit_expire_ts:0, commit_task_.is_registered():false, ref:2})
[2024-07-31 16:39:07.642813] WDIAG [RS] admin_set_config (ob_root_service.cpp:8840) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=9][errcode=-9026] fail to set backup config(ret=-9026, arg={items:[{name:"data_backup_dest", value:"s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642861] INFO [SHARE] add_event (ob_event_history_table_operator.h:261) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=16] event table add task(ret=0, event_table_name="__all_rootservice_event_history", sql=INSERT INTO __all_rootservice_event_history (gmt_create, module, event, name1, value1, name2, value2, name3, value3, value4, value5, value6, rs_svr_ip, rs_svr_port) VALUES (usec_to_time(1722415147642829), 'root_service', 'admin_set_config', 'ret', -9026, 'arg', '{name:"data_backup_dest", value:"s3://minio-oceanbase/backup/data?
[2024-07-31 16:39:07.642873] WDIAG [RS] process_ (ob_rs_rpc_processor.h:212) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=11][errcode=-9026] process failed(ret=-9026)
[2024-07-31 16:39:07.642879] INFO [RS] process_ (ob_rs_rpc_processor.h:232) [29912][T1_L0_G0][T1][YB420AA0AB09-00061E602A0FC511-0-0] [lt=4] [DDL] execute ddl like stmt(ret=-9026, cost=1446, ddl_arg=NULL)
请问当前版本oceanbase是不支持使用minio进行数据备份吗?