[admin@obd ~]$ mysql -h 192.168.1.119 -uroot -P2881 -psystex@123 -c -A oceanbase Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 3222015217 Server version: 5.7.25 OceanBase_CE 4.3.5.1 (r101000042025031818-b6d5706eb3d2c5f501c7fa646ddbf32f3dc87069) (Built Mar 18 2025 18:12:30) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [oceanbase]> SET ob_enable_show_trace='ON'; Query OK, 0 rows affected (0.00 sec) MySQL [oceanbase]> alter system set cpu_count=15; Query OK, 0 rows affected (1.14 sec) MySQL [oceanbase]> select last_trace_id(); +-----------------------------------+ | last_trace_id() | +-----------------------------------+ | YB42C0A80177-00063A2FCEDD76D8-0-0 | +-----------------------------------+ 1 row in set (0.01 sec) MySQL [oceanbase]> select query_sql,svr_ip from gv$ob_sql_audit where trace_id='YB42C0A80177-00063A2FCEDD76D8-0-0'; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+ | query_sql | svr_ip | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+ | INSERT INTO __all_sys_parameter (zone, svr_type, svr_ip, svr_port, name, value, info, config_version, gmt_modified, section, scope, source, edit_level, data_type) VALUES ('', 'observer', 'ANY', 0, 'cpu_count', '15', '', 1752827057506678, usec_to_time(1752827057506678), 'OBSERVER', 'CLUSTER', 'DEFAULT', 'DYNAMIC_EFFECTIVE', 'INT') ON DUPLICATE KEY UPDATE value = '15', info = '', config_version = 1752827057506678, gmt_modified = usec_to_time(1752827057506678), section = 'OBSERVER', scope = 'CLUSTER', source = 'DEFAULT', edit_level = 'DYNAMIC_EFFECTIVE', data_type = 'INT' | 192.168.1.117 | | START TRANSACTION | 192.168.1.117 | | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=116 AND col_stat.PARTITION_ID IN (116) AND col_stat.COLUMN_ID IN (17)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 192.168.1.117 | | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,col_stat.spare1 as compress_type,col_stat.cg_macro_blk_cnt as cg_macro_blk_cnt,col_stat.cg_micro_blk_cnt as cg_micro_blk_cnt,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=116 AND col_stat.PARTITION_ID IN (116) AND col_stat.COLUMN_ID IN (16)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 192.168.1.117 | | UPDATE __all_zone SET value = 1752827057506678, info = '', gmt_modified = now(6) WHERE zone = '' AND name = 'config_version' | 192.168.1.117 | | UPDATE __all_zone SET value = 1752827057518019, info = '', gmt_modified = now(6) WHERE zone = '' AND name = 'lease_info_version' | 192.168.1.117 | | COMMIT | 192.168.1.117 | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+ 7 rows in set (0.04 sec) 192.168.1.117 [root@ob1 ~]# grep "YB42C0A80177-00063A2FCEDD76D8-0-0" /home/admin/newcluster/oceanbase/log/observer.log* /home/admin/newcluster/oceanbase/log/observer.log:[2025-07-18 16:24:17.513131] INFO [COMMON] handle (ob_io_struct.cpp:3079) [4850][T1_DiskCB0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=78] callback runner call handle(get_queue_count()=0, req={is_inited_:true, tenant_id_:1, control_block_:0x7fd813317450, ref_cnt_:1, raw_buf_:0x7fd7cfbd6150, fd_:{first_id:1152921504606928220, second_id:2124, third_id:0, fd_id:-1, slot_version:-1, device_handle:0x7fd8149e1130}, is_object_device_req():false, trace_id_:YB42C0A80177-00063A2FCEDD76D8-0-0, retry_count_:0, tenant_io_mgr_:{ptr:0x7fd800df0030}, storage_accesser:{ptr:null}, io_result_:{is_inited_:true, is_finished_:false, is_canceled_:false, has_estimated_:false, complete_size_:4096, offset_:1450353, size_:1509, timeout_us_:8913000, result_ref_cnt_:2, out_ref_cnt_:1, flag_:{mode:"READ", group_id_:0, func_type_:0, wait_event_id_:1, is_sync_:false, is_unlimited_:false, is_detect_:false, is_write_through_:false, is_sealed_:true, is_time_detect_:false, need_close_dev_and_fd_:false, reserved_:0}, ret_code_:{io_ret_:0, fs_errno_:0}, tenant_id_:1, tenant_io_mgr_:{ptr:0x7fd800df0030}, user_data_buf_:null, buf_:null, io_callback_:0x7fd7d00d8080, time_log:{begin_ts:1752827057512581, enqueue_used:3, dequeue_used:59, submit_used:2, return_used:421, callback_enqueue_used:4, callback_dequeue_used:58, callback_finish_used:-1, end_used:-1}}, part_id:-1}) [root@ob1 ~]# grep "YB42C0A80177-00063A2FCEDD76D8-0-0" /home/admin/newcluster/oceanbase/log/rootservice.log* [root@ob1 ~]# grep "YB42C0A80177-00063A2FCEDD76D8-0-0" /home/admin/newcluster/oceanbase/log/rootservice.log* /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:16.428492] INFO [RS] execute (ob_system_admin_util.cpp:1293) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=40] execute set config request(arg={items:[{name:"cpu_count", value:"15", 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}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.511767] INFO [STORAGE.TRANS] get_number (ob_id_service.cpp:384) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=11] get number(ret=0, service_type_=0, range=1, base_id=1752827057510699000, start_id=1752827057510699000, end_id=1752827057510699001) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.511987] INFO [STORAGE] create_memtable (ob_protected_memtable_mgr_handle.h:158) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=33] memtable_mgr_handle_ is not exist, need create(tablet_meta.ls_id_={id:1}, tablet_meta.tablet_id_={id:118}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.512060] INFO [STORAGE] init (ob_medium_compaction_mgr.cpp:149) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=66] success to init medium clog recorder(ret=0, ls_id={id:1}, tablet_id={id:118}, max_saved_version=0) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.512162] INFO [STORAGE.TRANS] init_storage_recorder (ob_tablet_memtable_mgr.cpp:139) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=100] success to init storage recorder(ret=0, ls_id={id:1}, tablet_id={id:118}, max_saved_schema_version=0, max_saved_medium_scn=0, compat_mode=0) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.512188] INFO [STORAGE] create_memtable_ (ob_tablet_memtable_mgr.cpp:341) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=13] succeed to create memtable(arg={schema_version_:0, clog_checkpoint_scn_:{val:1752674403000239000, v:0}, new_clog_checkpoint_scn_:{val:1752674403000239000, v:0}, for_replay_:false, for_inc_direct_load_:false}, ret=0, ls_id={id:1}, new_tablet_memtable={ObITabletMemtable:{ObITable:{this:0x7fd7fadbd1a0, key:{tablet_id:{id:118}, column_group_idx:0, slice_range:{start_slice_idx:0, end_slice_idx:0}, table_type:"MEMTABLE", scn_range:{start_scn:{val:1752674403000239000, v:0}, end_scn:{val:4611686018427387903, v:0}}}, ref_cnt:2, upper_trans_version:9223372036854775807, timestamp:1752827057512185}, ls_id_:{id:1}, allow_freeze_:true, is_flushed_:false, is_tablet_freeze_:false, logging_blocked_:false, resolved_active_memtable_left_boundary_:true, unset_active_memtable_logging_blocked_:false, has_backoffed_:false, offlined_:false, read_barrier_:false, freeze_clock_:0, freeze_state_:1, unsubmitted_cnt_:0, init_timestamp_:1752827057512185, max_schema_version_:0, write_ref_cnt_:0, max_end_scn_:{val:0, v:0}, rec_scn_:{val:4611686018427387903, v:0}, freeze_scn_:{val:4611686018427387903, v:0}, freezer_:0x7fd7ed7c3010, memtable_mgr_handle_:{memtable_mgr:0x7fd7fadf6fc0, pool:0x7fd7ff0a0030}, mt_stat_.frozen_time_:0, mt_stat_.ready_for_flush_time_:0, mt_stat_.create_flush_dag_time_:0, mt_stat_.release_time_:0, mt_stat_.push_table_into_gc_queue_time_:0, mt_stat_.last_print_time_:0}, this:0x7fd7fadbd1a0, state:0, max_data_schema_version:0, max_column_cnt:0, local_allocator:{ListHandle:{freeze_stat:0, id:-1, clock:9223372036854775807}, host:0x7fd7fe47a2b0, arena_handle:{allocated:0}}, contain_hotspot_row:false, snapshot_version:{val:4611686018427387903, v:0}, contain_hotspot_row:false, ls_id:{id:1}, transfer_freeze_flag:false, recommend_snapshot_version:{val:18446744073709551615, v:3}}, this={ObIMemtableMgr:{Memtables:this:0x7fd7fadf6fc0, ref_cnt:2, is_inited:true, tablet_id:{id:118}, freezer:0x7fd7ed7c3010, memtable_head:0, memtable_tail:1, t3m:0x7fd7fe404030, tables:[0x7fd7fadbd1a0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]}, schema_recorder:{ObIStorageClogRecorder:{max_saved_version_:0, clog_scn_:{val:18446744073709551615, v:3}, log_handler_:0x7fd7ed7bdd10}, ls_id:{id:1}, tablet_id:{id:118}}}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.512275] INFO [STORAGE] inner_create_memtable (ob_tablet.cpp:5185) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=83] succeeded to create memtable for tablet(ret=0, tablet_id={id:118}, ls_id={id:1}, schema_version=0, for_replay=false, for_direct_load=false, input_clog_checkpoint_scn={val:1752674403000239000, v:0}, latest_clog_checkpoint_scn={val:1752674403000239000, v:0}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.512296] INFO [STORAGE] create_memtable (ob_tablet.cpp:5131) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=16] table store update memtable success(ret=0, ls_id={id:1}, tablet_id={id:118}, table_store_addr={ptr:0x7fd7fe3301c4, addr:{[ver=1,mode=0,seq=42665][2nd=12][3rd=0][offset=913408,size=580,type=2,seq=1][trans_seq=0, sec_part=0][6th=1]}}, this=0x7fd7fe32fb00) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513303] WDIAG [STORAGE.TRANS] lock_row_on_frozen_stores_ (ob_memtable.cpp:1312) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=17][errcode=-5024] internal lock row failed(ret=-5024, ret="OB_ERR_PRIMARY_KEY_DUPLICATE") /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513355] WDIAG [STORAGE] insert_row_without_rowkey_check (ob_tablet.cpp:4643) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=47][errcode=-5024] fail to set memtable(ret=-5024) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513374] WDIAG [STORAGE] insert_row_to_tablet (ob_ls_tablet_service.cpp:5667) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=13][errcode=-5024] failed to write table row(ret=-5024, table id=118, col_descs=[cnt:18, column_id=18 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=19 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=20 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=21 {type:"BIGINT", collation:"binary", coercibility:"NUMERIC"} order=0, column_id=22 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=16 {type:"TIMESTAMP", collation:"binary", coercibility:"NUMERIC"} order=0, column_id=17 {type:"TIMESTAMP", collation:"binary", coercibility:"NUMERIC"} order=0, column_id=23 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=24 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=25 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=26 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=27 {type:"BIGINT", collation:"binary", coercibility:"NUMERIC"} order=0, column_id=28 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=29 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=30 {type:"BIGINT", collation:"binary", coercibility:"NUMERIC"} order=0, column_id=31 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=32 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0, column_id=33 {type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"} order=0], datum_row={row_flag:{flag:"INSERT", flag_type:0}, trans_id:{txid:0}, scan_index:0, mvcc_row_flag:{first:0, uncommitted:0, shadow:0, compact:0, ghost:0, last:0, reserved:0, flag:0}, snapshot_version:0, fast_filter_skipped:false, have_uncommited_row:false, group_idx:0, count:18, datum_buffer:{capacity:18, datums:0x7fd7a8fb2ad0, local_datums:0x7fd7a8fb2720}, datums:[col_id=0:{len: 0, flag: 0, null: 0, ptr: 0x7fd7a8fb2ae0}, col_id=1:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25a8, hex: 6F62736572766572, int: 8243124926671970927, cstr: observer}, col_id=2:{len: 3, flag: 0, null: 0, ptr: 0x7fd7a8fb25b0, hex: 414E59, cstr: ANY}, col_id=3:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25b3, hex: 0000000000000000, int: 0}, col_id=4:{len: 9, flag: 0, null: 0, ptr: 0x7fd7a8fb25bb, hex: 6370755F636F756E74, cstr: cpu_count}, col_id=5:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25c4, hex: FE941DDA2F3A0600, int: 1752827057509630}, col_id=6:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25cc, hex: 76891DDA2F3A0600, int: 1752827057506678}, col_id=7:{len: 3, flag: 0, null: 0, ptr: 0x7fd7a8fb25d4, hex: 494E54, cstr: INT}, col_id=8:{len: 2, flag: 0, null: 0, ptr: 0x7fd7a8fb25d7, hex: 3135, cstr: 15}, col_id=9:null, col_id=10:{len: 0, flag: 0, null: 0, ptr: 0x7fd7a8fb2d10}, col_id=11:null, col_id=12:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25d9, hex: 4F42534552564552, int: 5928239395853517391, cstr: OBSERVER}, col_id=13:null, col_id=14:{len: 8, flag: 0, null: 0, ptr: 0x7fd7a8fb25e1, hex: 76891DDA2F3A0600, int: 1752827057506678}, col_id=15:{len: 7, flag: 0, null: 0, ptr: 0x7fd7a8fb25e9, hex: 434C5553544552, cstr: CLUSTER}, col_id=16:{len: 7, flag: 0, null: 0, ptr: 0x7fd7a8fb25f0, hex: 44454641554C54, cstr: DEFAULT}, col_id=17:{len: 17, flag: 0, null: 0, ptr: 0x7fd7a8fb25f7, hex: 44594E414D49435F454646454354495645, cstr: DYNAMIC_EFFECTIVE}]}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513548] INFO [STORAGE] print_count (ob_query_iterator_factory.cpp:45) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=124] ObQueryIteratorFactory statistics(multi_scan_merge_alloc_count=0, multi_scan_merge_release_count=0, multi_get_merge_alloc_count=0, multi_get_merge_release_count=0, table_scan_alloc_count=0, table_scan_release_count=0, insert_dup_alloc_count=80, insert_dup_release_count=80, col_map_alloc_count=0, col_map_release_count=0) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513604] WDIAG [STORAGE] insert_row (ob_ls_tablet_service.cpp:3241) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=42][errcode=-5024] failed to write row(ret=-5024) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.513712] INFO [STORAGE.TRANS] rollback (ob_memtable_context.cpp:851) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=14] memtable handle rollback to successfuly(from_seq_no={branch:0, seq:5}, to_seq_no={branch:0, seq:3}, remove_cnt=1, elapsed=0, this={ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=1744641276074800 max_table_version=1744641276074800 trans_version={val:4611686018427387903, v:0} commit_version={val:0, v:0} lock_wait_start_ts=0 replay_compact_version={val:0, v:0}} end_code=0 tx_status=0 is_readonly=false ref=0 trans_id={txid:14001668} ls_id=1 row_callback[alloc:0, free:0, unsubmit:0] redo[fill:0,sync_succ:0, sync_fail:0] main_list_len=0 pending_log_size=0 callback_list:{cnt=1 stat:[tx_end=0, rollback_to=1, fast_commit=0, remove_memtable=0, ext_info_log=0] detail:[(log_epoch,length,logged,synced,appended,removed,unlog_removed,branch_removed)|0:(-1,0,0,0,1,1,1,0)|]}}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.523926] WDIAG [SQL.ENG] get_next_left_row (ob_nested_loop_join_vec_op.cpp:167) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=32][errcode=-4008] failed to get next left row from friver iterator(ret=-4008) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.526407] WDIAG [SQL.ENG] get_next_left_row (ob_nested_loop_join_vec_op.cpp:167) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=37][errcode=-4008] failed to get next left row from friver iterator(ret=-4008) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528059] INFO [STORAGE] create_memtable (ob_protected_memtable_mgr_handle.h:158) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=32] memtable_mgr_handle_ is not exist, need create(tablet_meta.ls_id_={id:1}, tablet_meta.tablet_id_={id:116}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528119] INFO [STORAGE] init (ob_medium_compaction_mgr.cpp:149) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=55] success to init medium clog recorder(ret=0, ls_id={id:1}, tablet_id={id:116}, max_saved_version=0) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528136] INFO [STORAGE.TRANS] init_storage_recorder (ob_tablet_memtable_mgr.cpp:139) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=15] success to init storage recorder(ret=0, ls_id={id:1}, tablet_id={id:116}, max_saved_schema_version=0, max_saved_medium_scn=0, compat_mode=0) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528160] INFO [STORAGE] create_memtable_ (ob_tablet_memtable_mgr.cpp:341) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=11] succeed to create memtable(arg={schema_version_:0, clog_checkpoint_scn_:{val:1752674403000239000, v:0}, new_clog_checkpoint_scn_:{val:1752674403000239000, v:0}, for_replay_:false, for_inc_direct_load_:false}, ret=0, ls_id={id:1}, new_tablet_memtable={ObITabletMemtable:{ObITable:{this:0x7fd7fadbd9b0, key:{tablet_id:{id:116}, column_group_idx:0, slice_range:{start_slice_idx:0, end_slice_idx:0}, table_type:"MEMTABLE", scn_range:{start_scn:{val:1752674403000239000, v:0}, end_scn:{val:4611686018427387903, v:0}}}, ref_cnt:2, upper_trans_version:9223372036854775807, timestamp:1752827057528156}, ls_id_:{id:1}, allow_freeze_:true, is_flushed_:false, is_tablet_freeze_:false, logging_blocked_:false, resolved_active_memtable_left_boundary_:true, unset_active_memtable_logging_blocked_:false, has_backoffed_:false, offlined_:false, read_barrier_:false, freeze_clock_:0, freeze_state_:1, unsubmitted_cnt_:0, init_timestamp_:1752827057528156, max_schema_version_:0, write_ref_cnt_:0, max_end_scn_:{val:0, v:0}, rec_scn_:{val:4611686018427387903, v:0}, freeze_scn_:{val:4611686018427387903, v:0}, freezer_:0x7fd7ed7c3010, memtable_mgr_handle_:{memtable_mgr:0x7fd7fadf71b0, pool:0x7fd7ff0a0030}, mt_stat_.frozen_time_:0, mt_stat_.ready_for_flush_time_:0, mt_stat_.create_flush_dag_time_:0, mt_stat_.release_time_:0, mt_stat_.push_table_into_gc_queue_time_:0, mt_stat_.last_print_time_:0}, this:0x7fd7fadbd9b0, state:0, max_data_schema_version:0, max_column_cnt:0, local_allocator:{ListHandle:{freeze_stat:0, id:-1, clock:9223372036854775807}, host:0x7fd7fe47a2b0, arena_handle:{allocated:0}}, contain_hotspot_row:false, snapshot_version:{val:4611686018427387903, v:0}, contain_hotspot_row:false, ls_id:{id:1}, transfer_freeze_flag:false, recommend_snapshot_version:{val:18446744073709551615, v:3}}, this={ObIMemtableMgr:{Memtables:this:0x7fd7fadf71b0, ref_cnt:2, is_inited:true, tablet_id:{id:116}, freezer:0x7fd7ed7c3010, memtable_head:0, memtable_tail:1, t3m:0x7fd7fe404030, tables:[0x7fd7fadbd9b0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]}, schema_recorder:{ObIStorageClogRecorder:{max_saved_version_:0, clog_scn_:{val:18446744073709551615, v:3}, log_handler_:0x7fd7ed7bdd10}, ls_id:{id:1}, tablet_id:{id:116}}}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528264] INFO [STORAGE] inner_create_memtable (ob_tablet.cpp:5185) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=101] succeeded to create memtable for tablet(ret=0, tablet_id={id:116}, ls_id={id:1}, schema_version=0, for_replay=false, for_direct_load=false, input_clog_checkpoint_scn={val:1752674403000239000, v:0}, latest_clog_checkpoint_scn={val:1752674403000239000, v:0}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.528288] INFO [STORAGE] create_memtable (ob_tablet.cpp:5131) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=18] table store update memtable success(ret=0, ls_id={id:1}, tablet_id={id:116}, table_store_addr={ptr:0x7fd7df74b068, addr:{[ver=1,mode=0,seq=42665][2nd=12][3rd=0][offset=925696,size=580,type=2,seq=1][trans_seq=0, sec_part=0][6th=1]}}, this=0x7fd7df74aa10) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.531896] INFO [SQL] get_cache_obj (ob_sql_stat_record.cpp:621) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=4] sql stat record not found(ret=-5138, key={sql_id:"1D0BA376E273B9D622641124D8C59264", plan_hash:4241745642569367216, source_addr:"0.0.0.0:0"}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532027] INFO [SHARE] got_version (ob_config_manager.cpp:424) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=7] Got new config version(current_version=1752636330590083, version=1752827057506678) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532092] INFO [SHARE] got_version (ob_config_manager.cpp:466) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=42] Schedule update config task successfully! /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532139] INFO [RS] update_config (ob_system_admin_util.cpp:1175) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=9] got new sys config version(new_version=1752827057506678, item={name:"cpu_count", value:"15", comment:"", zone:"", server:"0.0.0.0:0", tenant_name:"", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532254] INFO [RS] execute (ob_system_admin_util.cpp:1318) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=35] set config succ(arg={items:[{name:"cpu_count", value:"15", 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}) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532417] INFO [SHARE] add_event (ob_event_history_table_operator.h:266) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=33] 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(1752827057532288), 'root_service', 'admin_set_config', 'ret', 0, 'arg', '{name:"cpu_count", value:"15", comment:"", zone:"", server:"0.0.0.0:0", tenant_name:"", exec_tenant_id:1, tenant_ids:[], want_to_set_tenant_config:false}', 'is_inner', 0, '', '', '', '192.168.1.117', 2882)) /home/admin/newcluster/oceanbase/log/rootservice.log:[2025-07-18 16:24:17.532450] INFO [RS] process_ (ob_rs_rpc_processor.h:236) [4931][T1_L0_G0][T1][YB42C0A80177-00063A2FCEDD76D8-0-0] [lt=31] [DDL] execute ddl like stmt(ret=0, cost=1104054, ddl_arg=NULL) [root@ob1 ~]#