[2024-09-27 10:32:35.719499] INFO [STORAGE] set (ob_storage_info.cpp:127) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=32] succ to parse storage info(device_type=2, endpoint="host=cos.ap-beijing.myqcloud.com", access_id="access_id=XXXXXXXXXXXXXXXXXXXXXXXXX", extension="appid=1111111111&delete_mode=delete") [2024-09-27 10:32:35.720313] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:278) [8651][T1_L0_G0][T1001][YB427F000001-000622DCADFDA762-0-0] [lt=20] succeed to calculate base table sharding info(table_id=18446744073709551614, ref_table_id=348, is_global_index=false) [2024-09-27 10:32:35.720872] WDIAG [SHARE] parse_one_row_ (ob_inner_table_operator.cpp:947) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=23][errcode=-4018] no row exist(ret=-4018) [2024-09-27 10:32:35.720886] WDIAG [SHARE] do_get_row_ (ob_inner_table_operator.cpp:620) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=13][errcode=-4018] failed to parse row(ret=-4018, sql=select * from __all_log_archive_progress where tenant_id = 1002 AND dest_no = 0, exec_tenant_id=1001) [2024-09-27 10:32:35.720917] WDIAG [SHARE] get_row (ob_inner_table_operator.cpp:176) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=5][errcode=-4018] failed to get row(ret=-4018, need_lock=false, key={tenant_id:1002, dest_no:0}) [2024-09-27 10:32:35.720927] WDIAG [SHARE] get_round (ob_archive_persist_helper.cpp:488) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=10][errcode=-4018] failed to get round(ret=-4018) [2024-09-27 10:32:35.720936] INFO [STORAGE] set (ob_storage_info.cpp:127) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=3] succ to parse storage info(device_type=2, endpoint="host=cos.ap-beijing.myqcloud.com", access_id="access_id=XXXXXXXXXXXXXXXXXXXXXXXXX", extension="appid=1111111111&delete_mode=delete") [2024-09-27 10:32:35.720950] INFO [STORAGE] set (ob_storage_info.cpp:127) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=8] succ to parse storage info(device_type=2, endpoint="host=cos.ap-beijing.myqcloud.com", access_id="access_id=XXXXXXXXXXXXXXXXXXXXXXXXX", extension="appid=1111111111&delete_mode=delete") [2024-09-27 10:32:35.885621] WDIAG list_objects (ob_storage_cos_base.cpp:584) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=7][errcode=-9071] fail to list objects(ret=-9071, uri=cos://oceanbase-1111111111/gcar/backup/archive) [2024-09-27 10:32:35.885644] WDIAG list_files (ob_storage_cos_base.cpp:397) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=23][errcode=-9071] fail to list object in cos_base(ret=-9071, uri=cos://oceanbase-1111111111/gcar/backup/archive, tmp_dir=gcar/backup/archive/) [2024-09-27 10:32:35.885654] WDIAG [STORAGE] list_files (ob_storage.cpp:406) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=6][errcode=-9071] failed to list_files(ret=-9071, uri=cos://oceanbase-1111111111/gcar/backup/archive) [2024-09-27 10:32:35.885658] WDIAG scan_dir (ob_object_device.cpp:411) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=4][errcode=-9071] fail to do list/dir scan!(ret=-9071, is_dir_scan=false, dir_name=cos://oceanbase-1111111111/gcar/backup/archive) [2024-09-27 10:32:35.885665] WDIAG is_empty_directory (ob_backup_io_adapter.cpp:592) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=6][errcode=-9071] fail to scan dir!(ret=-9071, uri=cos://oceanbase-1111111111/gcar/backup/archive) [2024-09-27 10:32:35.885670] WDIAG [SHARE] dest_is_empty_directory (ob_backup_store.cpp:243) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=3][errcode=-9071] fail to init store(ret=-9071, backup_dest={root_path:"cos://oceanbase-1111111111/gcar/backup/archive", storage_info:{endpoint:"host=cos.ap-beijing.myqcloud.com", access_id:"access_id=XXXXXXXXXXXXXXXXXXXXXXXXX", extension:"appid=1111111111&delete_mode=delete", type:"COS"}}) [2024-09-27 10:32:35.885684] WDIAG [SHARE] check_dest_validity (ob_backup_store.cpp:435) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=13][errcode=-9071] fail to check dest is empty dirctory(ret=-9071, backup_dest={root_path:"cos://oceanbase-1111111111/gcar/backup/archive", storage_info:{endpoint:"host=cos.ap-beijing.myqcloud.com", access_id:"access_id=XXXXXXXXXXXXXXXXXXXXXXXXX", extension:"appid=1111111111&delete_mode=delete", type:"COS"}}) [2024-09-27 10:32:35.885690] WDIAG [SHARE] check_before_update_inner_config (ob_backup_config.cpp:654) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=5][errcode=-9071] fail to update archive dest config(ret=-9071, tenant_id=1002) [2024-09-27 10:32:35.885695] WDIAG [SHARE] update_inner_config_table (ob_backup_config.cpp:367) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=4][errcode=-9071] fail to check before update inner config(ret=-9071) [2024-09-27 10:32:35.885699] WDIAG [RS] admin_set_backup_config (ob_root_service.cpp:10623) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=3][errcode=-9071] fail to update inner config table(ret=-9071) [2024-09-27 10:32:35.885779] INFO [STORAGE.TRANS] rollback_tx (ob_tx_api.cpp:339) [8651][T1_L0_G0][T1001][YB427F000001-000622DCADFDA762-0-0] [lt=3] rollback tx(ret=0, *this={is_inited_:true, tenant_id_:1001, this:0x2b1345204030}, tx={this:0x2b140a1a0d80, tx_id:{txid:15809865}, state:7, addr:"127.0.0.1:2882", tenant_id:1001, session_id:3221730473, assoc_session_id:3221730473, 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:1727404355718026, op_sn:3, alloc_ts:1727404355719086, active_ts:1727404355719086, commit_ts:-1, finish_ts:1727404355885605, timeout_us:9998490, lock_timeout_us:-1, expire_ts:1727404365717576, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1726196774, cluster_version:17180000768, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:true, cflict_txs:[], abort_cause:-6002, commit_expire_ts:0, commit_task_.is_registered():false, ref:2}) [2024-09-27 10:32:35.885818] INFO [SQL] get_cache_obj (ob_sql_stat_record.cpp:607) [8651][T1_L0_G0][T1001][YB427F000001-000622DCADFDA762-0-0] [lt=31] sql stat record not found(ret=-5138, key={sql_id:"2805522DD41E1B57DA11967AC5FA258C", plan_hash:2172533512788588953, source_addr:"0.0.0.0:0"}) [2024-09-27 10:32:35.885877] WDIAG [RS] admin_set_config (ob_root_service.cpp:8403) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=10][errcode=-9071] fail to set backup config(ret=-9071, arg={items:[{name:"log_archive_dest", value:"LOCATION=cos://oceanbase-1111111111/gcar/backup/archive?host=cos.ap-beijing.myqcloud.com&access_id=XXXXXXXXXXXXXXXXXXXXXXXXX&access_key=xXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&appid=1111111111&delete_mode=delete", comment:"", zone:"", server:"0.0.0.0:0", tenant_name:"gcar", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}], is_inner:false}) [2024-09-27 10:32:35.885933] INFO [SHARE] add_event (ob_event_history_table_operator.h:266) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=28] 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(1727404355885905), 'root_service', 'admin_set_config', 'ret', -9071, 'arg', '{name:"log_archive_dest", value:"LOCATION=cos://oceanbase-1111111111/gcar/backup/archive?host=cos.ap-beijing.myqcloud.com&access_id=XXXXXXXXXXXXXXXXXXXXXXXXX&access_key=xXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&appid=1111111111&delete_mode=delete", comment:"", zone:"", server:"0.0.0.0:0", tenant_name:"gcar", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}', 'is_inner', 0, '', '', '', '127.0.0.1', 2882)) [2024-09-27 10:32:35.885942] WDIAG [RS] process_ (ob_rs_rpc_processor.h:215) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=8][errcode=-9071] process failed(ret=-9071) [2024-09-27 10:32:35.885947] INFO [RS] process_ (ob_rs_rpc_processor.h:235) [8651][T1_L0_G0][T1][YB427F000001-000622DCADFDA762-0-0] [lt=4] [DDL] execute ddl like stmt(ret=-9071, cost=166920, ddl_arg=NULL)