[2023-02-16 10:26:28.904127] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=76] [dc=0] server session do_io_close((*this={ss_id:41, server_sessid:3221845371, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e3c20, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:4, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e3c20, this=0x7fe0485e44f0) [2023-02-16 10:26:28.904333] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=197] [dc=0] server session is closing(ss_id=41, server_sessid=3221845371, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:28.904885] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=42, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:28.906663] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=12] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:28.910671] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=17] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.136:2881}, obproxy_client_port={172.16.11.134:53148}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=42, server_sessid=3222111095, sm_id=7, cmd_size_stats={client_request_bytes:261, server_request_bytes:296, server_response_bytes:522, client_response_bytes:522}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=35, client_request_analyze_time_us=32, cluster_resource_create_time_us=0, pl_lookup_time_us=16, pl_process_time_us=37, congestion_control_time_us=2, congestion_process_time_us=0, do_observer_open_time_us=773, server_connect_time_us=511, server_sync_session_variable_time_us=2911, server_send_saved_login_time_us=1615, server_send_use_database_time_us=522, server_send_session_variable_time_us=772, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=50, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3989, server_request_write_time_us=23, server_process_request_time_us=2496, server_response_read_time_us=6, plugin_decompress_response_time_us=0, server_response_analyze_time_us=10, ok_packet_trim_time_us=26, client_response_write_time_us=90, request_total_time_us=6618}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ svr_ip, sql_port AS svr_port, zone, status, start_service_time is not null AS start_service_time, stop_time is not null as stop_time FROM oceanbase.DBA_OB_SERVERS WHERE svr_port > 0 ORDER BY zone LIMIT 9223372036854775807) [2023-02-16 10:26:28.910834] INFO [PROXY] ob_server_state_processor.cpp:1383 [13822][Y0-00007FE051D00DA0] [lt=117] [dc=0] rs list maybe update by rs refresh task, current used dummy entry maybe old one. We need stop to update server list and dummy entry this time(cluster_name_=obcluster, last_rs_list_hash=0, last_server_list_hash=8829000407225098141, server_list=[[0]{server:"172.16.11.134:2881", is_dup_replica:false, role:"LEADER", type:"FULL"}, [1]{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]) [2023-02-16 10:26:28.910992] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=24] [dc=0] server session do_io_close((*this={ss_id:42, server_sessid:3222111095, server_ip:{172.16.11.136:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e21b0, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e21b0, this=0x7fe0485e44f0) [2023-02-16 10:26:28.911217] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=216] [dc=0] server session is closing(ss_id=42, server_sessid=3222111095, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:28.911694] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=43, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:28.913552] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=17] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:28.918818] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=13] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.135:2881}, obproxy_client_port={172.16.11.134:15804}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=43, server_sessid=3221848746, sm_id=7, cmd_size_stats={client_request_bytes:175, server_request_bytes:210, server_response_bytes:501, client_response_bytes:501}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=28, client_request_analyze_time_us=26, cluster_resource_create_time_us=0, pl_lookup_time_us=40, pl_process_time_us=17, congestion_control_time_us=2, congestion_process_time_us=0, do_observer_open_time_us=721, server_connect_time_us=420, server_sync_session_variable_time_us=2574, server_send_saved_login_time_us=1424, server_send_use_database_time_us=463, server_send_session_variable_time_us=687, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=25, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3838, server_request_write_time_us=15, server_process_request_time_us=3986, server_response_read_time_us=5, plugin_decompress_response_time_us=0, server_response_analyze_time_us=9, ok_packet_trim_time_us=15, client_response_write_time_us=44, request_total_time_us=7899}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ tenant_name, locality, previous_locality, primary_zone FROM oceanbase.DBA_OB_TENANTS where previous_locality is null and tenant_id != 1) [2023-02-16 10:26:43.519523] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=69] [dc=0] server session do_io_close((*this={ss_id:43, server_sessid:3221848746, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485d8310, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485d8310, this=0x7fe0485e44f0) [2023-02-16 10:26:43.519776] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=242] [dc=0] server session is closing(ss_id=43, server_sessid=3221848746, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:43.519996] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=44, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:43.521143] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=14] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:43.524876] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=59] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.134:2881}, obproxy_client_port={172.16.11.134:26950}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=44, server_sessid=3221691093, sm_id=7, cmd_size_stats={client_request_bytes:162, server_request_bytes:197, server_response_bytes:528, client_response_bytes:528}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=35, client_request_analyze_time_us=32, cluster_resource_create_time_us=0, pl_lookup_time_us=36, pl_process_time_us=38, congestion_control_time_us=53, congestion_process_time_us=0, do_observer_open_time_us=491, server_connect_time_us=179, server_sync_session_variable_time_us=1463, server_send_saved_login_time_us=777, server_send_use_database_time_us=309, server_send_session_variable_time_us=376, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=51, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2592, server_request_write_time_us=13, server_process_request_time_us=2870, server_response_read_time_us=4, plugin_decompress_response_time_us=0, server_response_analyze_time_us=11, ok_packet_trim_time_us=0, client_response_write_time_us=25, request_total_time_us=5518}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ zone, status, 0 AS is_merging, region, idc AS spare4, type AS spare5 FROM oceanbase.DBA_OB_ZONES LIMIT 9223372036854775807) [2023-02-16 10:26:43.525635] INFO [PROXY] ob_server_state_processor.cpp:1429 [13822][Y0-00007FE051D00DA0] [lt=81] [dc=0] ObServerStateRefreshCont, update sys tennant's __all_dummy succ((tmp_entry={{this:0x7fe051bb33c0, ref_count:4, cr_version:0, cr_id:0, create_time_us:1676514403525626, last_valid_time_us:1676514403525526, last_access_time_us:1676514403525526, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"AVAIL"}, this:0x7fe051bb33c0, is_inited:true, is_dummy_entry:true, is_entry_from_rslist:false, is_empty_entry_allowed:false, is_need_force_flush:false, has_dup_replica:false, cr_id:0, name:{cluster_name:"obcluster", tenant_name:"sys", database_name:"oceanbase", package_name:"", table_name:"__all_dummy"}, table_id:1099511627911, table_type:"UNKNOWN", part_num:1, replica_num:3, buf_len:32, buf_start:0x7fe051bb34c8, tenant_servers:{this:0x7fe051b1e040, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7fe0487f88a0, server_array_:[[0]{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}) [2023-02-16 10:26:43.525802] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=68] [dc=0] server session do_io_close((*this={ss_id:44, server_sessid:3221691093, server_ip:{172.16.11.134:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e3c20, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1e040, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb33c0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:2, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e3c20, this=0x7fe0485e44f0) [2023-02-16 10:26:43.525963] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=157] [dc=0] server session is closing(ss_id=44, server_sessid=3221691093, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:43.526255] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=6] [dc=0] server session born(ss_id=45, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:43.527802] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=72] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:43.531098] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=18] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.135:2881}, obproxy_client_port={172.16.11.134:16316}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=45, server_sessid=3221851998, sm_id=7, cmd_size_stats={client_request_bytes:175, server_request_bytes:210, server_response_bytes:501, client_response_bytes:501}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=10, client_request_analyze_time_us=9, cluster_resource_create_time_us=0, pl_lookup_time_us=10, pl_process_time_us=38, congestion_control_time_us=1, congestion_process_time_us=0, do_observer_open_time_us=529, server_connect_time_us=236, server_sync_session_variable_time_us=2375, server_send_saved_login_time_us=1207, server_send_use_database_time_us=495, server_send_session_variable_time_us=671, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=46, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3270, server_request_write_time_us=19, server_process_request_time_us=2020, server_response_read_time_us=2, plugin_decompress_response_time_us=0, server_response_analyze_time_us=10, ok_packet_trim_time_us=17, client_response_write_time_us=33, request_total_time_us=5357}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ tenant_name, locality, previous_locality, primary_zone FROM oceanbase.DBA_OB_TENANTS where previous_locality is null and tenant_id != 1) [2023-02-16 10:26:55.068739] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=52] [dc=0] server session do_io_close((*this={ss_id:45, server_sessid:3221851998, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e21b0, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1e040, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb33c0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e21b0, this=0x7fe0485e44f0) [2023-02-16 10:26:55.068921] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=171] [dc=0] server session is closing(ss_id=45, server_sessid=3221851998, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:55.069125] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=46, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:55.070168] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=14] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:55.072146] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=27] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.134:2881}, obproxy_client_port={172.16.11.134:27322}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=46, server_sessid=3221696211, sm_id=7, cmd_size_stats={client_request_bytes:162, server_request_bytes:197, server_response_bytes:528, client_response_bytes:528}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=69, client_request_analyze_time_us=65, cluster_resource_create_time_us=0, pl_lookup_time_us=29, pl_process_time_us=61, congestion_control_time_us=4, congestion_process_time_us=0, do_observer_open_time_us=403, server_connect_time_us=131, server_sync_session_variable_time_us=1689, server_send_saved_login_time_us=844, server_send_use_database_time_us=315, server_send_session_variable_time_us=529, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=104, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2582, server_request_write_time_us=24, server_process_request_time_us=934, server_response_read_time_us=4, plugin_decompress_response_time_us=0, server_response_analyze_time_us=11, ok_packet_trim_time_us=0, client_response_write_time_us=25, request_total_time_us=3584}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ zone, status, 0 AS is_merging, region, idc AS spare4, type AS spare5 FROM oceanbase.DBA_OB_ZONES LIMIT 9223372036854775807) [2023-02-16 10:26:55.072960] INFO [PROXY] ob_server_state_processor.cpp:1383 [13822][Y0-00007FE051D00DA0] [lt=134] [dc=0] rs list maybe update by rs refresh task, current used dummy entry maybe old one. We need stop to update server list and dummy entry this time(cluster_name_=obcluster, last_rs_list_hash=0, last_server_list_hash=8829000407225098141, server_list=[[0]{server:"172.16.11.134:2881", is_dup_replica:false, role:"LEADER", type:"FULL"}, [1]{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]) [2023-02-16 10:26:55.073064] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=28] [dc=0] server session do_io_close((*this={ss_id:46, server_sessid:3221696211, server_ip:{172.16.11.134:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485d8310, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1e040, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb33c0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:2, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485d8310, this=0x7fe0485e44f0) [2023-02-16 10:26:55.073253] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=184] [dc=0] server session is closing(ss_id=46, server_sessid=3221696211, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:26:55.073444] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=47, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:26:55.074736] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=15] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:26:55.077581] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=13] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.136:2881}, obproxy_client_port={172.16.11.134:54034}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=47, server_sessid=3222116797, sm_id=7, cmd_size_stats={client_request_bytes:175, server_request_bytes:210, server_response_bytes:501, client_response_bytes:501}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=9, client_request_analyze_time_us=9, cluster_resource_create_time_us=0, pl_lookup_time_us=5, pl_process_time_us=7, congestion_control_time_us=21, congestion_process_time_us=0, do_observer_open_time_us=397, server_connect_time_us=162, server_sync_session_variable_time_us=2133, server_send_saved_login_time_us=940, server_send_use_database_time_us=372, server_send_session_variable_time_us=820, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=21, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2938, server_request_write_time_us=20, server_process_request_time_us=1556, server_response_read_time_us=2, plugin_decompress_response_time_us=0, server_response_analyze_time_us=9, ok_packet_trim_time_us=14, client_response_write_time_us=46, request_total_time_us=4574}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ tenant_name, locality, previous_locality, primary_zone FROM oceanbase.DBA_OB_TENANTS where previous_locality is null and tenant_id != 1) [2023-02-16 10:27:06.366987] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=110] [dc=0] server session do_io_close((*this={ss_id:47, server_sessid:3222116797, server_ip:{172.16.11.136:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e3c20, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1e040, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb33c0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e3c20, this=0x7fe0485e44f0) [2023-02-16 10:27:06.367243] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=244] [dc=0] server session is closing(ss_id=47, server_sessid=3222116797, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:06.367527] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=48, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:06.369464] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=15] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:27:06.373557] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=20] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.135:2881}, obproxy_client_port={172.16.11.134:17092}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=48, server_sessid=3221856903, sm_id=7, cmd_size_stats={client_request_bytes:162, server_request_bytes:197, server_response_bytes:528, client_response_bytes:528}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=65, client_request_analyze_time_us=62, cluster_resource_create_time_us=0, pl_lookup_time_us=24, pl_process_time_us=36, congestion_control_time_us=14, congestion_process_time_us=0, do_observer_open_time_us=579, server_connect_time_us=203, server_sync_session_variable_time_us=2669, server_send_saved_login_time_us=1381, server_send_use_database_time_us=543, server_send_session_variable_time_us=744, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=91, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3978, server_request_write_time_us=18, server_process_request_time_us=2628, server_response_read_time_us=4, plugin_decompress_response_time_us=0, server_response_analyze_time_us=21, ok_packet_trim_time_us=45, client_response_write_time_us=73, request_total_time_us=6726}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ zone, status, 0 AS is_merging, region, idc AS spare4, type AS spare5 FROM oceanbase.DBA_OB_ZONES LIMIT 9223372036854775807) [2023-02-16 10:27:06.373782] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=105] [dc=0] server session do_io_close((*this={ss_id:48, server_sessid:3221856903, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e21b0, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1e040, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb33c0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e21b0, this=0x7fe0485e44f0) [2023-02-16 10:27:06.373941] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=154] [dc=0] server session is closing(ss_id=48, server_sessid=3221856903, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:06.374180] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=7] [dc=0] server session born(ss_id=49, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:06.376024] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=11] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:27:06.378782] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=17] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.136:2881}, obproxy_client_port={172.16.11.134:54440}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=49, server_sessid=3222119328, sm_id=7, cmd_size_stats={client_request_bytes:261, server_request_bytes:296, server_response_bytes:522, client_response_bytes:522}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=17, client_request_analyze_time_us=16, cluster_resource_create_time_us=0, pl_lookup_time_us=21, pl_process_time_us=10, congestion_control_time_us=1, congestion_process_time_us=0, do_observer_open_time_us=411, server_connect_time_us=197, server_sync_session_variable_time_us=2656, server_send_saved_login_time_us=1604, server_send_use_database_time_us=432, server_send_session_variable_time_us=619, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=22, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3384, server_request_write_time_us=18, server_process_request_time_us=1604, server_response_read_time_us=2, plugin_decompress_response_time_us=0, server_response_analyze_time_us=10, ok_packet_trim_time_us=10, client_response_write_time_us=27, request_total_time_us=5050}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ svr_ip, sql_port AS svr_port, zone, status, start_service_time is not null AS start_service_time, stop_time is not null as stop_time FROM oceanbase.DBA_OB_SERVERS WHERE svr_port > 0 ORDER BY zone LIMIT 9223372036854775807) [2023-02-16 10:27:06.378926] INFO [PROXY] ob_server_state_processor.cpp:1429 [13822][Y0-00007FE051D00DA0] [lt=81] [dc=0] ObServerStateRefreshCont, update sys tennant's __all_dummy succ((tmp_entry={{this:0x7fe051bb2fa0, ref_count:4, cr_version:0, cr_id:0, create_time_us:1676514426378917, last_valid_time_us:1676514426378765, last_access_time_us:1676514426378765, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"AVAIL"}, this:0x7fe051bb2fa0, is_inited:true, is_dummy_entry:true, is_entry_from_rslist:false, is_empty_entry_allowed:false, is_need_force_flush:false, has_dup_replica:false, cr_id:0, name:{cluster_name:"obcluster", tenant_name:"sys", database_name:"oceanbase", package_name:"", table_name:"__all_dummy"}, table_id:1099511627911, table_type:"UNKNOWN", part_num:1, replica_num:3, buf_len:32, buf_start:0x7fe051bb30a8, tenant_servers:{this:0x7fe051b1c120, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7fe0487f8c90, server_array_:[[0]{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}) [2023-02-16 10:27:06.379125] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=75] [dc=0] server session do_io_close((*this={ss_id:49, server_sessid:3222119328, server_ip:{172.16.11.136:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485d8310, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485d8310, this=0x7fe0485e44f0) [2023-02-16 10:27:06.379279] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=149] [dc=0] server session is closing(ss_id=49, server_sessid=3222119328, server_ip={172.16.11.136:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:06.379614] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=6] [dc=0] server session born(ss_id=50, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:06.386077] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=12] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:27:06.392003] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=14] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.135:2881}, obproxy_client_port={172.16.11.134:17096}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=50, server_sessid=3221856908, sm_id=7, cmd_size_stats={client_request_bytes:175, server_request_bytes:210, server_response_bytes:501, client_response_bytes:501}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=14, client_request_analyze_time_us=13, cluster_resource_create_time_us=0, pl_lookup_time_us=25, pl_process_time_us=18, congestion_control_time_us=1, congestion_process_time_us=0, do_observer_open_time_us=503, server_connect_time_us=279, server_sync_session_variable_time_us=7093, server_send_saved_login_time_us=5982, server_send_use_database_time_us=465, server_send_session_variable_time_us=645, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=52, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=8185, server_request_write_time_us=33, server_process_request_time_us=4659, server_response_read_time_us=5, plugin_decompress_response_time_us=0, server_response_analyze_time_us=10, ok_packet_trim_time_us=14, client_response_write_time_us=39, request_total_time_us=12934}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ tenant_name, locality, previous_locality, primary_zone FROM oceanbase.DBA_OB_TENANTS where previous_locality is null and tenant_id != 1) [2023-02-16 10:27:26.315384] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=125] [dc=0] server session do_io_close((*this={ss_id:50, server_sessid:3221856908, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e3f10, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e3f10, this=0x7fe0485e44f0) [2023-02-16 10:27:26.315661] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=250] [dc=0] server session is closing(ss_id=50, server_sessid=3221856908, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:26.315866] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=6] [dc=0] server session born(ss_id=51, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:26.316885] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=11] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:27:26.318719] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=37] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.134:2881}, obproxy_client_port={172.16.11.134:28440}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=51, server_sessid=3221706512, sm_id=7, cmd_size_stats={client_request_bytes:162, server_request_bytes:197, server_response_bytes:528, client_response_bytes:528}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=86, client_request_analyze_time_us=72, cluster_resource_create_time_us=0, pl_lookup_time_us=96, pl_process_time_us=56, congestion_control_time_us=3, congestion_process_time_us=0, do_observer_open_time_us=497, server_connect_time_us=127, server_sync_session_variable_time_us=1633, server_send_saved_login_time_us=816, server_send_use_database_time_us=359, server_send_session_variable_time_us=458, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=92, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2662, server_request_write_time_us=19, server_process_request_time_us=828, server_response_read_time_us=3, plugin_decompress_response_time_us=0, server_response_analyze_time_us=8, ok_packet_trim_time_us=0, client_response_write_time_us=43, request_total_time_us=3566}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ zone, status, 0 AS is_merging, region, idc AS spare4, type AS spare5 FROM oceanbase.DBA_OB_ZONES LIMIT 9223372036854775807) [2023-02-16 10:27:26.318881] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=80] [dc=0] server session do_io_close((*this={ss_id:51, server_sessid:3221706512, server_ip:{172.16.11.134:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e3c20, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e3c20, this=0x7fe0485e44f0) [2023-02-16 10:27:26.319089] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=204] [dc=0] server session is closing(ss_id=51, server_sessid=3221706512, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:26.319345] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=6] [dc=0] server session born(ss_id=52, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:26.321283] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=26] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false) [2023-02-16 10:27:26.324515] INFO [PROXY.SM] ob_mysql_sm.cpp:9275 [13822][Y0-00007FE051D00DA0] [lt=17] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={172.16.11.135:2881}, obproxy_client_port={172.16.11.134:17806}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483655, proxy_sessid=12398422444493438979, ss_id=52, server_sessid=3221858471, sm_id=7, cmd_size_stats={client_request_bytes:261, server_request_bytes:296, server_response_bytes:522, client_response_bytes:522}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=12, client_request_analyze_time_us=11, cluster_resource_create_time_us=0, pl_lookup_time_us=5, pl_process_time_us=7, congestion_control_time_us=1, congestion_process_time_us=0, do_observer_open_time_us=491, server_connect_time_us=229, server_sync_session_variable_time_us=2519, server_send_saved_login_time_us=1300, server_send_use_database_time_us=508, server_send_session_variable_time_us=710, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=20, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3682, server_request_write_time_us=17, server_process_request_time_us=1878, server_response_read_time_us=2, plugin_decompress_response_time_us=0, server_response_analyze_time_us=8, ok_packet_trim_time_us=53, client_response_write_time_us=69, request_total_time_us=5659}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ svr_ip, sql_port AS svr_port, zone, status, start_service_time is not null AS start_service_time, stop_time is not null as stop_time FROM oceanbase.DBA_OB_SERVERS WHERE svr_port > 0 ORDER BY zone LIMIT 9223372036854775807) [2023-02-16 10:27:26.324649] INFO [PROXY] ob_server_state_processor.cpp:1383 [13822][Y0-00007FE051D00DA0] [lt=60] [dc=0] rs list maybe update by rs refresh task, current used dummy entry maybe old one. We need stop to update server list and dummy entry this time(cluster_name_=obcluster, last_rs_list_hash=0, last_server_list_hash=8829000407225098141, server_list=[[0]{server:"172.16.11.134:2881", is_dup_replica:false, role:"LEADER", type:"FULL"}, [1]{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]) [2023-02-16 10:27:26.324738] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [13822][Y0-00007FE051D00DA0] [lt=30] [dc=0] server session do_io_close((*this={ss_id:52, server_sessid:3221858471, server_ip:{172.16.11.135:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7fe0485e21b0, client_session:{this:0x7fe04a89c6f0, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:13822, cs_id:2147483655, proxy_sessid:12398422444493438979, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483655, user_priv_set:0, cluster_name:"obcluster", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:64335}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.134:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.136:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"172.16.11.135:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7fe051b1c120, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7fe051bb2fa0, server_state_version:2, cur_ss:null, bound_ss:0x7fe0485e44f0, lii_ss:null, cluster_resource:{this:0x7fe046d66080, ref_count:8, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcluster"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1676514281144828940, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1676514140373767960, last_rslist_refresh_time_ns:0, server_state_version:2}, client_vc:0x7fe04d2eecc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:64335, ob_server:"0.0.0.0", version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:1, user_var_version:0, db_name_version:1, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7fe0485e21b0, this=0x7fe0485e44f0) [2023-02-16 10:27:26.324920] INFO [PROXY.SS] ob_mysql_server_session.cpp:177 [13822][Y0-00007FE051D00DA0] [lt=178] [dc=0] server session is closing(ss_id=52, server_sessid=3221858471, server_ip={172.16.11.135:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979) [2023-02-16 10:27:26.325020] INFO [PROXY.SS] ob_mysql_server_session.cpp:105 [13822][Y0-00007FE051D00DA0] [lt=6] [dc=0] server session born(ss_id=53, server_ip={172.16.11.134:2881}, cs_id=2147483655, proxy_sessid=12398422444493438979, server_type=1) [2023-02-16 10:27:26.325840] INFO [PROXY] ob_proxy_session_info_handler.cpp:730 [13822][Y0-00007FE051D00DA0] [lt=14] [dc=0] succ to set ob_capability_flag(client_cap=0, server_cap=64335, orig_client_cap=0, orig_server_cap=64335, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=false)