[2024-12-02 15:08:06.035852] INFO  [STORAGE.TABLELOCK] process_lock_task_ (ob_table_lock_service.cpp:911) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=9] [table lock] lock_table(ctx={task_type_:9, is_in_trans_:true, table_id_:18446744073709551615, partition_id_:18446744073709551615, tablet_list_:[], obj_list_:[{obj_type:5, obj_id:1}], lock_op_type_:4, origin_timeout_us_:599997447, timeout_us_:599997447, abs_timeout_ts_:1733123886033298, tx_desc_:{this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:2, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2}, tx_param_:{cluster_id:1732871094, timeout_us:86400000000, lock_timeout_us:-1, access_mode:0, isolation:1}, current_savepoint_:0, need_rollback_ls_:[], lock_mode_:1, lock_owner_:{pack:0, type:0, id:0, reserved:0, valid_flag:0}, schema_version_:-1, tx_is_killed_:false, is_from_sql_:false, ret_code_before_end_stmt_or_tx_:1425431954, stmt_savepoint_:0})
[2024-12-02 15:08:06.035971] INFO  [STORAGE.TABLELOCK] pack_and_call_rpc_ (ob_table_lock_service.cpp:1818) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=50] send table lock rpc(ret=0, ret="OB_SUCCESS", retry_ctx.send_rpc_count_=1, addr="192.168.0.175:2882", request={task_type_:9, lsid_:{id:1}, params_:[{lock_id:{obj_type:5, obj_id:1}, lock_mode:1, owner_id:{pack:0, type:0, id:0, reserved:0, valid_flag:0}, op_type:4, is_deadlock_avoid_enabled:true, is_try_lock:false, expired_time:1733123886033298, schema_version:-1, is_for_replace:false}], tx_desc_:{this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:4, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2}})
[2024-12-02 15:08:06.036437] INFO  [STORAGE.TABLELOCK] process_lock_task_ (ob_table_lock_service.cpp:949) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=35] [table lock] lock_table(ret=0, ctx={task_type_:9, is_in_trans_:true, table_id_:18446744073709551615, partition_id_:18446744073709551615, tablet_list_:[], obj_list_:[{obj_type:5, obj_id:1}], lock_op_type_:4, origin_timeout_us_:599997447, timeout_us_:599997447, abs_timeout_ts_:1733123886033298, tx_desc_:{this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:4, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[{id:{id:1}, addr:"192.168.0.175:2882", epoch:926279358932763, first_scn:{branch:0, seq:3162}, last_scn:{branch:0, seq:3162}, last_touch_ts:1}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2}, tx_param_:{cluster_id:1732871094, timeout_us:86400000000, lock_timeout_us:-1, access_mode:0, isolation:1}, current_savepoint_:0, need_rollback_ls_:[], lock_mode_:1, lock_owner_:{pack:0, type:0, id:0, reserved:0, valid_flag:0}, schema_version_:-1, tx_is_killed_:false, is_from_sql_:false, ret_code_before_end_stmt_or_tx_:0, stmt_savepoint_:0})
[2024-12-02 15:08:06.038143] INFO  [RS] create_job (ob_rs_job_table_operator.cpp:202) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=9] rootservice job started(job_id=12, job_info="INSERT INTO __all_rootservice_job (sql_text, gmt_create, gmt_modified, job_id, job_type, progress, job_status, rs_svr_ip, rs_svr_port) VALUES (X'414C5445522053595354454D20524553544F5245206D7973716C5F68792046524F4D202766696C653A2F2F2F686F6D652F61646D696E2F323032342D31312D32392D31382D30302D30312720574954482027706F6F6C5F6C6973743D6D715F706F6F6C5F687927', usec_to_time(1733123286037770), usec_to_time(1733123286037770), 12, 'RESTORE_TENANT', 0, 'INPROGRESS', '192.168.0.175', 2882)", common::lbt()="0x11ab55d8 0x91dbaa4 0x91da5dc 0xa817ae4 0xb840bf8 0x11aca09c 0x1d09c6ac 0x1d09d504 0x11ab1264 0x1b956a10 0x1b954c64 0xffff86b92508 0xffff86bf9cdc")
[2024-12-02 15:08:06.038165] INFO  [RS.RESTORE] fill_backup_info_ (ob_restore_util.cpp:227) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=13] start fill backup path(arg={tenant_name:"mysql_hy", uri:"file:///home/admin/2024-11-29-18-00-01", restore_option:"pool_list=mq_pool_hy", restore_scn:{val:18446744073709551615, v:3}, passwd_array:"", kms_info:"", table_items:[], with_restore_scn:false, encrypt_key:"", kms_uri:"", kms_encrypt_key:"", restore_timestamp:"", initiator_job_id:0, initiator_tenant_id:1})
[2024-12-02 15:08:06.038326] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=18] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/format.obbak, serializer={cluster_name:"myoceanbase", tenant_name:"mysql_hy", path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", cluster_id:1731668961, tenant_id:1004, incarnation:1, dest_id:1013, dest_type:0})
[2024-12-02 15:08:06.038417] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=17] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/format.obbak, serializer={cluster_name:"myoceanbase", tenant_name:"mysql_hy", path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", cluster_id:1731668961, tenant_id:1004, incarnation:1, dest_id:1013, dest_type:0})
[2024-12-02 15:08:06.038461] INFO  [SHARE] func (ob_backup_data_store.cpp:310) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=12] backup set dir name(ret=0, backup_set_dir_name=backup_set_16_full)
[2024-12-02 15:08:06.038555] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=11] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/single_backup_set_info.obbak, serializer={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.038582] INFO  [SHARE] read_backup_set_info (ob_backup_data_store.cpp:788) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=26] read backup set info(backup_set_info={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.038662] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=19] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/format.obbak, serializer={cluster_name:"myoceanbase", tenant_name:"mysql_hy", path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", cluster_id:1731668961, tenant_id:1004, incarnation:1, dest_id:1013, dest_type:0})
[2024-12-02 15:08:06.038695] INFO  [SHARE] func (ob_backup_data_store.cpp:310) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=12] backup set dir name(ret=0, backup_set_dir_name=backup_set_16_full)
[2024-12-02 15:08:06.038773] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=9] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/single_backup_set_info.obbak, serializer={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.038795] INFO  [SHARE] read_backup_set_info (ob_backup_data_store.cpp:788) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=21] read backup set info(backup_set_info={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.038823] INFO  [SHARE] do_get_backup_set_array_ (ob_backup_data_store.cpp:1142) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=18] find one full backup set(backup_set_file={backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}})
[2024-12-02 15:08:06.038850] INFO  [SHARE] do_get_backup_set_array_ (ob_backup_data_store.cpp:1195) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=16] find all backup set for restore(tmp_backup_set_list=[{backup_set_path:"file:///home/admin/2024-11-29-18-00-01/backup_set_16_full", backup_set_desc:{backup_set_id:16, backup_type:{type:1}, min_restore_scn:{val:1732874528445031000, v:0}, total_bytes:56089492}}])
[2024-12-02 15:08:06.038903] INFO  [SHARE] parse_piece_file_ (ob_archive_store.cpp:1723) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=12] succeed to parse dest and round and piece id(dest_id=1013, round_id=3, piece_id=11)
[2024-12-02 15:08:06.038916] INFO  [SHARE] parse_piece_file_ (ob_archive_store.cpp:1723) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=10] succeed to parse dest and round and piece id(dest_id=1013, round_id=3, piece_id=12)
[2024-12-02 15:08:06.038937] INFO  [RS.RESTORE] get_restore_log_array_for_complement_log_ (ob_restore_util.cpp:1545) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=8] get restore log path list(backup_set_list=[{backup_set_path:"file:///home/admin/2024-11-29-18-00-01/backup_set_16_full", backup_set_desc:{backup_set_id:16, backup_type:{type:1}, min_restore_scn:{val:1732874528445031000, v:0}, total_bytes:56089492}}], log_path_list=["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log"])
[2024-12-02 15:08:06.039019] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=12] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/single_backup_set_info.obbak, serializer={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.039041] INFO  [SHARE] read_backup_set_info (ob_backup_data_store.cpp:788) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=21] read backup set info(backup_set_info={ObExternBackupDataDesc:{type:7, version:1}, backup_set_file:{backup_set_id:16, incarnation:1, tenant_id:1004, dest_id:1013, backup_type:{type:1}, plus_archivelog:true, date:20241129, prev_full_backup_set_id:0, prev_inc_backup_set_id:0, stats:{input_bytes:5101928615, output_bytes:56089492, tablet_count:2014, finish_tablet_count:2014, macro_block_count:2431, finish_macro_block_count:2431, extra_bytes:0, finish_file_count:0, log_file_count:9, finish_log_file_count:9}, start_time:1732874401814350, end_time:1732874665370545, status:1, result:0, encryption_mode:0, passwd:"", file_status:0, backup_path:"file:///home/admin/myoceanbase/mysql_data_backup/2024-11-29-18-00-01", start_replay_scn:{val:1732837523422832000, v:0}, min_restore_scn:{val:1732874528445031000, v:0}, tenant_compatible:17180066816, backup_compatible:4, data_turn_id:0, meta_turn_id:1, cluster_version:17180066816, consistent_scn:{val:1732874437122873000, v:0}}})
[2024-12-02 15:08:06.039120] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=17] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/infos/locality_info.obbak, serializer={ObExternBackupDataDesc:{type:12, version:1}, tenant_id:1004, backup_set_id:16, cluster_id:1731668961, compat_mode:0, tenant_name:"mysql_hy", cluster_name:"myoceanbase", locality:"FULL{1}@zone1", primary_zone:"zone1", sys_time_zone:"+08:00", sys_time_zone_wrap:{cur_version:-1, class:2, tz_info:0xfffe3e14b420, error_on_overlap_time:false, tz_info_pos:{tz_name:"", tz_id:-1, default_transition_type:{lower_time:-9223372036854775808, info:{offset_sec:0, tran_type_id:-1, is_dst:false, abbr:""}}, tz_transition_types:[], tz_revert_types:[], curr_idx:0, next_tz_transition_types:[], next_tz_revert_types:[]}, tz_info_offset:{id:-1, offset:28800, error_on_overlap_time:false}}})
[2024-12-02 15:08:06.039204] INFO  [SHARE] read_single_file (ob_backup_store.cpp:380) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=25] succeed to read single file.(full_path=file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/infos/meta_info/ls_attr_info.1.obbak, serializer={ObExternBackupDataDesc:{type:22, version:1}, backup_scn_:{val:1732874420916288000, v:0}, ls_attr_array:[{id:{id:1}, ls_group_id:0, flag:{flag:0, is_duplicate:false, is_block_tablet_in:false}, status:2, operation_type_:1, create_scn:{val:1, v:0}}, {id:{id:1001}, ls_group_id:1001, flag:{flag:0, is_duplicate:false, is_block_tablet_in:false}, status:2, operation_type_:1, create_scn:{val:1731900463310700000, v:0}}]})
[2024-12-02 15:08:06.039231] INFO  [RS.RESTORE] fill_backup_info_ (ob_restore_util.cpp:237) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=19] finish fill backup path(arg={tenant_name:"mysql_hy", uri:"file:///home/admin/2024-11-29-18-00-01", restore_option:"pool_list=mq_pool_hy", restore_scn:{val:18446744073709551615, v:3}, passwd_array:"", kms_info:"", table_items:[], with_restore_scn:false, encrypt_key:"", kms_uri:"", kms_encrypt_key:"", restore_timestamp:"", initiator_job_id:0, initiator_tenant_id:1}, job={restore_key:{tenant_id:1, job_id:12}, initiator_job_id:0, initiator_tenant_id:1, tenant_id:0, backup_tenant_id:1004, restore_type:{restore_type:"FULL"}, status:0, comment:"", restore_start_ts:0, restoring_start_ts:0, restore_scn:{val:1732874528445031000, v:0}, consistent_scn:{val:1732874437122873000, v:0}, post_data_version:0, source_cluster_version:17180066816, source_data_version:17180066816, restore_option:"pool_list=mq_pool_hy", backup_dest:"file:///home/admin/2024-11-29-18-00-01", description:"", tenant_name:"mysql_hy", pool_list:"mq_pool_hy", locality:"", primary_zone:"", compat_mode:0, compatible:0, kms_info:"", kms_encrypt:false, concurrency:0, passwd_array:"", multi_restore_path_list:{backup_set_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full"], backup_piece_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p11", "file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p12"], log_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log"]}, white_list:{table_items:[]}, recover_table:false, using_complement_log:false, backup_compatible:4})
[2024-12-02 15:08:06.039261] INFO  [RS.RESTORE] fill_physical_restore_job (ob_restore_util.cpp:103) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=29] finish fill_physical_restore_job(job_id=12, arg={tenant_name:"mysql_hy", uri:"file:///home/admin/2024-11-29-18-00-01", restore_option:"pool_list=mq_pool_hy", restore_scn:{val:18446744073709551615, v:3}, passwd_array:"", kms_info:"", table_items:[], with_restore_scn:false, encrypt_key:"", kms_uri:"", kms_encrypt_key:"", restore_timestamp:"", initiator_job_id:0, initiator_tenant_id:1}, job={restore_key:{tenant_id:1, job_id:12}, initiator_job_id:0, initiator_tenant_id:1, tenant_id:0, backup_tenant_id:1004, restore_type:{restore_type:"FULL"}, status:0, comment:"", restore_start_ts:0, restoring_start_ts:0, restore_scn:{val:1732874528445031000, v:0}, consistent_scn:{val:1732874437122873000, v:0}, post_data_version:0, source_cluster_version:17180066816, source_data_version:17180066816, restore_option:"pool_list=mq_pool_hy", backup_dest:"file:///home/admin/2024-11-29-18-00-01", description:"", tenant_name:"mysql_hy", pool_list:"mq_pool_hy", locality:"", primary_zone:"", compat_mode:0, compatible:0, kms_info:"", kms_encrypt:false, concurrency:0, passwd_array:"", multi_restore_path_list:{backup_set_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full"], backup_piece_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p11", "file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p12"], log_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log"]}, white_list:{table_items:[]}, recover_table:false, using_complement_log:false, backup_compatible:4})
[2024-12-02 15:08:06.039285] INFO  [SHARE.SCHEMA] get_tenant_info (ob_schema_getter_guard.cpp:2130) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=22] tenant not exist(tenant_name=mysql_hy)
[2024-12-02 15:08:06.039714] INFO  [COMMON] get_jobs (ob_physical_restore_table_operator.cpp:419) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=10] [RESTORE] get restore jobs(ret=0, job_cnt=0)
[2024-12-02 15:08:06.041872] INFO  [COMMON] insert_job (ob_physical_restore_table_operator.cpp:136) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=8] [RESTORE] insert job(ret=0, ret="OB_SUCCESS", tenant_id_=1, job_info={restore_key:{tenant_id:1, job_id:12}, initiator_job_id:0, initiator_tenant_id:1, tenant_id:0, backup_tenant_id:1004, restore_type:{restore_type:"FULL"}, status:0, comment:"", restore_start_ts:1733123286033314, restoring_start_ts:0, restore_scn:{val:1732874528445031000, v:0}, consistent_scn:{val:1732874437122873000, v:0}, post_data_version:0, source_cluster_version:17180066816, source_data_version:17180066816, restore_option:"pool_list=mq_pool_hy", backup_dest:"file:///home/admin/2024-11-29-18-00-01", description:"", tenant_name:"mysql_hy", pool_list:"mq_pool_hy", locality:"", primary_zone:"", compat_mode:0, compatible:0, kms_info:"", kms_encrypt:false, concurrency:0, passwd_array:"", multi_restore_path_list:{backup_set_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full"], backup_piece_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p11", "file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log/piece_d1013r3p12"], log_path_list:["file:///home/admin/2024-11-29-18-00-01/backup_set_16_full/complement_log"]}, white_list:{table_items:[]}, recover_table:false, using_complement_log:false, backup_compatible:4})
[2024-12-02 15:08:06.042823] INFO  [DATA_DICT] gen_and_serialize_dict_metas (ob_data_dict_storager.cpp:241) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=4] all schema_array is empty, use default msg(DEFAULT_DDL_MDS_MSG=ddl_trans commit)
[2024-12-02 15:08:06.042852] INFO  [STORAGE.TRANS] statistics (ob_location_adapter.cpp:72) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=11] location adapter statistics(renew_access=0, total_access=4, error_count=0, renew_rate=0.000000000e+00)
[2024-12-02 15:08:06.042880] INFO  [STORAGE.TRANS] notify_data_source_ (ob_trans_part_ctx.cpp:7670) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=14] notify MDS(ret=0, trans_id_={txid:4033827}, ls_id_={id:1}, notify_type="REGISTER_SUCC", log_ts={val:18446744073709551615, v:3}, notify_array.count()=1, notify_array=[{register_no_:0, seq_no_:{branch:0, seq:3171}, has_submitted_:false, has_synced_:false, type:"DDL_TRANS", data_.length():17, has_deserialized_buffer_ctx_:false}], total_time=0)
[2024-12-02 15:08:06.042914] INFO  [STORAGE.TRANS] register_mds_into_tx (ob_trans_service.cpp:960) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=22] register multi data source result(ret=0, ret="OB_SUCCESS", arg={tenant_id:1, tx_desc:{this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:8, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[{id:{id:1}, addr:"192.168.0.175:2882", epoch:926279358932763, first_scn:{branch:0, seq:3162}, last_scn:{branch:0, seq:3172}, last_touch_ts:1733123286035461}], exec_info_reap_ts:1733123286035460, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2}, ls_id:{id:1}, type:6, buf_.length():0x11, seq_no:{branch:0, seq:3171}, request_id:0, register_flag:{need_flush_redo_instantly_:false, mds_base_scn_:{val:18446744073709551615, v:3}}}, result={result:0, tx_result:{incomplete:false, parts:[{id:{id:1}, addr:"192.168.0.175:2882", epoch:926279358932763, first_scn:{branch:0, seq:3162}, last_scn:{branch:0, seq:3172}, last_touch_ts:1733123286035460}], touched_ls_list:[], conflict_txs:[]}}, tx_desc={this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:8, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[{id:{id:1}, addr:"192.168.0.175:2882", epoch:926279358932763, first_scn:{branch:0, seq:3162}, last_scn:{branch:0, seq:3172}, last_touch_ts:1733123286035461}], exec_info_reap_ts:1733123286035460, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2}, local_retry_cnt=0, retry_cnt=0, request_id=0, time_guard=time guard have no click events for optimization)
[2024-12-02 15:08:06.042979] INFO  [SERVER] register_multi_data_source (ob_inner_sql_connection.cpp:1199) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=61] register mds in inner_sql_connection(ret=0, ret="OB_SUCCESS", this=0xfffea6c26050, local_execute=true, get_resource_conn_id()=18446744073709551615, get_session().get_sessid()=1, get_session().get_tx_desc()={this:0xfffebbf64dd0, tx_id:{txid:4033827}, state:2, addr:"192.168.0.175: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:{branch:0, seq:1}, op_sn:8, alloc_ts:1733123286035455, active_ts:1733123286035455, commit_ts:-1, finish_ts:-1, timeout_us:599997695, lock_timeout_us:-1, expire_ts:1733123886033150, coord_id:{id:-1}, parts:[{id:{id:1}, addr:"192.168.0.175:2882", epoch:926279358932763, first_scn:{branch:0, seq:3162}, last_scn:{branch:0, seq:3172}, last_touch_ts:1733123286035461}], exec_info_reap_ts:1733123286035460, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1732871094, cluster_version:17180066816, seq_base:1733123286032294, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, conflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, modified_tables:[], ref:2})
[2024-12-02 15:08:06.043128] INFO  [STORAGE.TRANS] prepare_mds_tx_op_ (ob_trans_part_ctx.cpp:7299) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=7] prepare_mds_tx_op(ret=0, trans_id_={txid:4033827}, ls_id_={id:1}, mds_array=[{register_no_:1, seq_no_:{branch:0, seq:3171}, has_submitted_:false, has_synced_:false, type:"DDL_TRANS", data_.length():17, has_deserialized_buffer_ctx_:false}], tx_op_array=[], op_scn={val:0, v:0})
[2024-12-02 15:08:06.043186] INFO  [STORAGE.TRANS] notify_data_source_ (ob_trans_part_ctx.cpp:7670) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=17] notify MDS(ret=0, trans_id_={txid:4033827}, ls_id_={id:1}, notify_type="TX_END", log_ts={val:18446744073709551615, v:3}, notify_array.count()=1, notify_array=[{register_no_:1, seq_no_:{branch:0, seq:3171}, has_submitted_:true, has_synced_:false, type:"DDL_TRANS", data_.length():17, has_deserialized_buffer_ctx_:false}], total_time=0)
[2024-12-02 15:08:06.043204] INFO  [STORAGE.TRANS] get_number (ob_id_service.cpp:393) [2319552][DDLQueueTh0][T1][YB42C0A800AF-000628430C9F1B92-0-0] [lt=15] get number(ret=0, service_type_=0, range=1, base_id=1733123286042828000, start_id=1733123286042828000, end_id=1733123286042828001)
[2024-12-02 15:08:06.046026] INFO  [RS] physical_restore_tenant (ob_root_service.cpp:9823) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=8] [RESTORE] physical restore tenant start(arg={tenant_name:"mysql_hy", uri:"file:///home/admin/2024-11-29-18-00-01", restore_option:"pool_list=mq_pool_hy", restore_scn:{val:18446744073709551615, v:3}, passwd_array:"", kms_info:"", table_items:[], with_restore_scn:false, encrypt_key:"", kms_uri:"", kms_encrypt_key:"", restore_timestamp:"", initiator_job_id:0, initiator_tenant_id:1}, ret=0)
[2024-12-02 15:08:06.046071] INFO  [SHARE] add_event (ob_event_history_table_operator.h:266) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=20] 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, value3, value4, value5, value6, rs_svr_ip, rs_svr_port) VALUES (usec_to_time(1733123286046047), 'physical_restore', 'restore_start', 'ret', 0, 'tenant_name', 'mysql_hy', '', '', '', '', '192.168.0.175', 2882))
[2024-12-02 15:08:06.046094] INFO  [SHARE] add_event (ob_event_history_table_operator.h:266) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=11] 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(1733123286046082), 'physical_restore', 'change_restore_status', 'job_id', 12, 'tenant_name', 'mysql_hy', 'status', 'CREATE_TENANT', '', '', '', '192.168.0.175', 2882))
[2024-12-02 15:08:06.046104] INFO  [RS] process_ (ob_rs_rpc_processor.h:226) [2319552][DDLQueueTh0][T0][YB42C0A800AF-000628430C9F1B92-0-0] [lt=8] [DDL] execute ddl like stmt(ret=0, cost=12789, ddl_arg=NULL)