oceanbase社区版4.2.1：
使用腾讯云cos进行备份归档前准备工作，执行命令ALTER SYSTEM SET LOG_ARCHIVE_DEST=‘LOCATION=cos://oceanbase-test-appid/backup/archive?host=cos.ap-xxxx.myqcloud.com&access_id=&access_key=&appid=***&delete_mode=tagging’;
报错ERROR 1235 (0A000): Not supported feature or function什么原因，我已经关闭了桶的list cache特性
access_id是用户id，access_key是第一个秘钥，不需要设置sk的第二个秘钥吗
麻烦收集一下observer的日志，收集一下报错日志前后时间的日志信息
我过滤查询了一下的observer.log和observer.log.wf没有查找到报错相关的，我用的是mysql模式的管理员租户进入查询的。
OB_LOG_1.zip (6.4 MB)
OB_LOG_obcluster_2.zip (5.6 MB)
你重新执行一下alter system，失败后执行下select last_trace_id(); 然后到日志里查下这个trace_id看看有没有有效信息
日志内容记得脱敏一下。
这个trace再在rootservice日志里查一下看看
报错如下：貌似是现在只能支持租户cat rootservice.log | grep YB420AC9A413-000612D3D6143EB8-0-0
[2024-03-07 15:45:31.728590] WDIAG [RS] admin_set_backup_config (ob_root_service.cpp:10311) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143EB8-0-0] [lt=40][errcode=-4007] backup config only support user tenant(ret=-4007)
[2024-03-07 15:45:31.728624] WDIAG [RS] admin_set_config (ob_root_service.cpp:8138) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143EB8-0-0] [lt=31][errcode=-4007] fail to set backup config(ret=-4007, arg={items:[{name:“log_archive_dest”, value:“LOCATION=cos:///backup/archive?host=&access_id=&access_key=&appid=&delete_mode=tagging”, comment:"", zone:"", server:“0.0.0.0:0”, tenant_name:"", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}], is_inner:false})
[2024-03-07 15:45:31.728737] INFO [SHARE] add_event (ob_event_history_table_operator.h:290) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143EB8-0-0] [lt=35] 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, rs_svr_ip, rs_svr_port) VALUES (usec_to_time(1709797531728661), ‘root_service’, ‘admin_set_config’, ‘ret’, -4007, ‘arg’, ‘{items:[{name:“log_archive_dest”, value:“LOCATION=cos:///backup/archive?host=&access_id=&access_key=&appid=&delete_mode=tagging”, comment:"", zone:"", server:“0.0.0.0:0”, tenant_name:"", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}], is_inner:false}’, ‘10.201.164.19’, 2882))
[2024-03-07 15:45:31.728762] WDIAG [RS] process (ob_rs_rpc_processor.h:212) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143EB8-0-0] [lt=22][errcode=-4007] process failed(ret=-4007)
[2024-03-07 15:45:31.728775] INFO [RS] process (ob_rs_rpc_processor.h:232) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143EB8-0-0] [lt=11] [DDL] execute ddl like stmt(ret=-4007, cost=189, ddl_arg=NULL，
但是我语句是ALTER SYSTEM SET LOG_ARCHIVE_DEST=‘LOCATION=cos://oceanbase-test-appid/backup/archive?host=cos.ap-xxxx.myqcloud.com&access_id=&access_key=&appid=***&delete_mode=tagging’ TENANT = mysql_tenant;
会报错ERROR 1210 (HY000): Invalid argument，
rootservice日志是INFO [STORAGE] set (ob_storage_info.cpp:127) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=33] succ to parse storage info(device_type=2, endpoint="", access_id="", extension="&delete_mode=tagging")
[2024-03-07 15:50:30.551135] WDIAG [SHARE] get_row (ob_inner_table_operator.cpp:172) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=36][errcode=-4002] key not valid(ret=-4002, key={tenant_id:1, dest_no:0})
[2024-03-07 15:50:30.551162] WDIAG [SHARE] get_round (ob_archive_persist_helper.cpp:488) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=25][errcode=-4002] failed to get round(ret=-4002)
[2024-03-07 15:50:30.551175] WDIAG [SHARE] is_archive_running (ob_tenant_archive_mgr.cpp:63) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=12][errcode=-4002] failed to get dest round(ret=-4002, tenant_id=1, dest_no=0)
[2024-03-07 15:50:30.551189] WDIAG [SHARE] check_before_update_inner_config (ob_backup_config.cpp:646) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=13][errcode=-4002] failed to check archive running.(ret=-4002, backup_dest=)
[2024-03-07 15:50:30.551208] WDIAG [SHARE] update_inner_config_table (ob_backup_config.cpp:367) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=18][errcode=-4002] fail to check before update inner config(ret=-4002)
[2024-03-07 15:50:30.551220] WDIAG [RS] admin_set_backup_config (ob_root_service.cpp:10339) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=10][errcode=-4002] fail to update inner config table(ret=-4002)
[2024-03-07 15:50:30.551331] INFO [STORAGE.TRANS] rollback_tx (ob_tx_api.cpp:339) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=10] rollback tx(ret=0, *this={is_inited:true, tenant_id:1, this:0x7f9577204030}, tx={this:0x7f95557f22c0, tx_id:{txid:1950360}, state:7, addr:“10.201.164.19:2882”, tenant_id:1, 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:1709797830549007, op_sn:3, alloc_ts:1709797830550067, active_ts:1709797830550067, commit_ts:-1, finish_ts:1709797830551129, timeout_us:9998015, lock_timeout_us:-1, expire_ts:1709797840548082, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1, cluster_version:17180000515, 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-03-07 15:50:30.551493] WDIAG [RS] admin_set_config (ob_root_service.cpp:8138) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=92][errcode=-4002] fail to set backup config(ret=-4002, arg={items:[{name:“log_archive_dest”, value:“LOCATION=cos:///backup/archive?host=&access_id=&access_key=&appid=&delete_mode=tagging”, comment:"", zone:"", server:“0.0.0.0:0”, tenant_name:“sys”, exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}], is_inner:false})
[2024-03-07 15:50:30.551660] INFO [SHARE] add_event (ob_event_history_table_operator.h:290) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=34] 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, rs_svr_ip, rs_svr_port) VALUES (usec_to_time(1709797830551529), ‘root_service’, ‘admin_set_config’, ‘ret’, -4002, ‘arg’, ‘{items:[{name:“log_archive_dest”, value:“LOCATION=cos:///backup/archive?host=&access_id=&access_key=&appid=&delete_mode=tagging”, comment:"", zone:"", server:“0.0.0.0:0”, tenant_name:“sys”, exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}], is_inner:false}’, ‘10.201.164.19’, 2882))
[2024-03-07 15:50:30.551683] WDIAG [RS] process (ob_rs_rpc_processor.h:212) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=21][errcode=-4002] process failed(ret=-4002)
[2024-03-07 15:50:30.551696] INFO [RS] process (ob_rs_rpc_processor.h:232) [57167][T1_L0_G0][T1][YB420AC9A413-000612D3D6143F01-0-0] [lt=11] [DDL] execute ddl like stmt(ret=-4002, cost=1916, ddl_arg=NULL)
这个是不是我的cos的配置信息填写错误呢，access_id 和 access_key 用于设置 COS 的访问密钥 这两个分别是腾讯云的ak，sk还是腾讯云的id和其中的一个秘钥ak或者是sk呢
sys租户不支持备份恢复，要么指定用户租户tenant，要么在用户租户的root用户下执行
那我的sys怎么备份恢复呢，另外一个租户是一个桶才可以吗，可以是桶下面的一个目录吗
系统租户是不需要备份的，没有用户数据，你不应该使用系统租户来存放用户数据
明白了，所以我只需要备份除了系统用户的所有用户就可以了是吧，但是每次智能备份一个租户，4.2.1不能按照集群备份是吧，同时ocp4.2.1直接备份也不能直接备份集群吗
黑屏就只有手动一个一个租户设置了，ocp帮你封装了，有集群备份策略
明白，所以说就是只要是在机器上归档完毕，然后在ocp进行备份操作就可以是吧
我的归档日志处于doing状态，我在ocp上面点击备份，显示租户ocp_monitor（id = 1004）已经在往cos:进行备份，无法变更为新的备份路径cos://，如果确认要变更备份路径，请先停止该租户的日志备份，再重试执行备份。但是我没有进行备份啊，这个什么原因，我root用户执行 SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS\G;
Empty set (0.018 sec)
你黑屏设置的归档先关掉。走ocp的备份策略，里面应该是有白屏操作日志归档的
好的，我试下，谢谢
ocp版本是4.2.1，ocp备份完想要恢复时找不到租户，还有机器只能选择一台，这个应该怎么解决
收集诊断信息反馈给我们，推荐用obdiag，提高效率，一条命令帮你把所有排查问题需要的信息都拿回来了，OceanBase分布式数据库-海量数据 笔笔算数
obdiag gather scene run --scene=observer.log_archive
