[root@aobceocp01 log]# tail -f obproxy.log [2022-08-11 15:24:48.927105] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:5702) [754][Y0-7F4B593C2DF0] [lt=6] [dc=0] client will abort soon(sm_id=21484, cs_id=2147686964, proxy_sessid=8742, ss_id=30625, server_sessid=3222032134, client_ip={*Not IP address [0]*:0}, server_ip={21.32.3.91:2881}, cluster_name=obcentoscluster, tenant_name=sys, user_name=proxyro, db=oceanbase, event="VC_EVENT_EOS", request_cmd="Query", sql_cmd="Query", sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ * FROM oceanbase.__all_virtual_zone_stat LIMIT 9223372036854775807) [2022-08-11 15:24:48.927132] WARN [PROXY.SM] update_cmd_stats (ob_mysql_sm.cpp:7585) [754][Y0-7F4B593C2DF0] [lt=7] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={21.32.3.91:2881}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcentoscluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=1, cs_id=2147686964, proxy_sessid=8742, ss_id=30625, server_sessid=3222032134, sm_id=21484, cmd_size_stats={client_request_bytes:106, server_request_bytes:124, server_response_bytes:0, client_response_bytes:0}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=23, client_request_analyze_time_us=23, cluster_resource_create_time_us=0, pl_lookup_time_us=0, pl_process_time_us=0, congestion_control_time_us=0, congestion_process_time_us=0, do_observer_open_time_us=1, server_connect_time_us=0, server_sync_session_variable_time_us=0, server_send_saved_login_time_us=0, server_send_use_database_time_us=0, server_send_session_variable_time_us=0, 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=1, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=49, server_request_write_time_us=26, server_process_request_time_us=0, server_response_read_time_us=0, plugin_decompress_response_time_us=0, server_response_analyze_time_us=0, ok_packet_trim_time_us=0, client_response_write_time_us=0, request_total_time_us=4992955}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ * FROM oceanbase.__all_virtual_zone_stat LIMIT 9223372036854775807) [2022-08-11 15:24:48.927209] WARN [PROXY.SM] update_stats (ob_mysql_sm.cpp:7719) [754][Y0-7F4B593C2DF0] [lt=31] [dc=0] Slow transaction: ((client_ip={*Not IP address [0]*:0}, server_ip={21.32.3.91:2881}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, ob_proxy_protocol=1, cs_id=2147686964, proxy_sessid=8742, ss_id=30625, server_sessid=3222032134, sm_id=21484, state=1, trans_stats_={client_requests:1, server_responses:0, pl_lookup_retries:0, server_retries:0, client_request_bytes:106, server_request_bytes:124, server_response_bytes:0, client_response_bytes:0, client_transaction_idle_time_us=0, client_process_request_time_us=50, client_request_read_time_us=23, client_request_analyze_time_us=23, cluster_resource_create_time_us=0, pl_lookup_time_us=0, pl_process_time_us=0, congestion_control_time_us=0, congestion_process_time_us=0, do_observer_open_time_us=1, server_connect_time_us=0, sync_session_variable_time_us=0, send_saved_login_time_us=0, send_use_database_time_us=0, send_session_vars_time_us=0, send_all_session_vars_time_us=0, send_last_insert_id_time_us=0, send_start_trans_time_us=0, build_server_request_time_us=1, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=49, server_request_write_time_us=26, server_process_request_time_us=0, server_response_read_time_us=0, plugin_decompress_response_time_us=0, server_response_analyze_time_us=0, ok_packet_trim_time_us=0, client_response_write_time_us=0, trans_time_us=4993062}, last_sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ * FROM oceanbase.__all_virtual_zone_stat LIMIT 9223372036854775807) [2022-08-11 15:24:48.927276] INFO [PROXY.SS] ob_mysql_server_session.cpp:139 [754][Y0-7F4B593C2DF0] [lt=30] [dc=0] server session do_io_close((*this={ss_id:30625, server_sessid:3222032134, server_ip:{21.32.3.91:2881}, is_inited:true, magic:19136237, state:1, server_vc:0x7f4b59394380, client_session:{this:0x7f4b5fe72530, 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:754, cs_id:2147686964, proxy_sessid:8742, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147686964, user_priv_set:512, cluster_name:"obcentoscluster", 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}, 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}, 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:5, 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}, 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:"21.32.3.90: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:"21.32.3.55: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:"21.32.3.91: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:0x7f4b5f11f6a0, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f4b5f11f1d0, server_state_version:5, cur_ss:0x7f4b593baea0, bound_ss:null, lii_ss:null, cluster_resource:{this:0x7f4b7d600c10, ref_count:9, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcentoscluster"}, cluster_id:5}, cr_state:"CR_AVAIL", version:905, last_access_time_ns:1660202403197971982, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1660197702866167911, last_rslist_refresh_time_ns:1660202509496763169, server_state_version:5, dummy_entry:{{this:0x7f4b59388920, ref_count:1, cr_version:0, cr_id:5, create_time_us:1660158706091888, last_valid_time_us:1660158706091845, last_access_time_us:1660158883872211, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"DELETED"}, this:0x7f4b59388920, 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:5, name:{cluster_name:"obcentoscluster", 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:38, buf_start:0x7f4b59388a20, tenant_servers:{this:0x7f4b5f1215c0, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f4b5ff66d80, server_array_:[[0]{server:"21.32.3.91:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"21.32.3.90:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"21.32.3.55:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}}, client_vc:0x7f4b6e673fc0, using_ldg:false, trace_stats:NULL}, transact_count:2, server_trans_stat:1, session_info:{cap:2639, 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}, 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_=0x7f4b59394380, this=0x7f4b593baea0) [2022-08-11 15:24:48.927460] INFO [PROXY.SS] ob_mysql_server_session.cpp:173 [754][Y0-7F4B593C2DF0] [lt=183] [dc=0] server session is closing(ss_id=30625, server_sessid=3222032134, server_ip={21.32.3.91:2881}, cs_id=2147686964, proxy_sessid=8742) [2022-08-11 15:24:48.927489] INFO [PROXY.CS] ob_mysql_client_session.cpp:83 [754][Y0-7F4B593C2DF0] [lt=7] [dc=0] client session destroy(cs_id=2147686964, proxy_sessid=8742, client_vc=NULL) [2022-08-11 15:24:48.927518] INFO [PROXY.SM] ob_mysql_sm.cpp:7027 [754][Y0-7F4B593C2DF0] [lt=9] [dc=0] deallocating sm(sm_id=21484) [2022-08-11 15:24:49.650102] INFO [PROXY.CS] ob_mysql_transact.cpp:4940 [741][Y0-7F4B6E652640] [lt=79] [dc=0] succ to global variable proxy_route_policy(policy=) [2022-08-11 15:24:49.652647] INFO [PROXY.CS] ob_mysql_transact.cpp:4940 [741][Y0-7F4B6E652640] [lt=19] [dc=0] succ to global variable proxy_route_policy(policy=) [2022-08-11 15:24:49.653804] INFO [PROXY.CS] ob_mysql_transact.cpp:4940 [741][Y0-7F4B6E652640] [lt=12] [dc=0] succ to global variable proxy_route_policy(policy=) [2022-08-11 15:24:58.738191] INFO [PROXY] ob_table_cache.cpp:689 [741][Y0-7F4B7D1EC890] [lt=13] [dc=0] this table entry will erase from tc map((*it={{this:0x7f4b5f44bf80, ref_count:4, cr_version:0, cr_id:2, create_time_us:1660202679082647, last_valid_time_us:1660202679082609, last_access_time_us:1660202681184023, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"DELETED"}, this:0x7f4b5f44bf80, 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:2, name:{cluster_name:"obgctest", 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:31, buf_start:0x7f4b5f44c080, tenant_servers:{this:0x7f4b5f121530, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f4b6e6b06d0, server_array_:[[0]{server:"21.32.3.186:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"21.32.3.187:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"21.32.3.188:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}) [2022-08-11 15:25:01.794007] INFO [PROXY.SM] ob_mysql_sm.cpp:3234 [751][Y0-7F4B5F05F760] [lt=16] [dc=0] this cached dummy entry need force renew((cached_dummy_entry={{this:0x7f4b5f44bf80, ref_count:3, cr_version:0, cr_id:2, create_time_us:1660202679082647, last_valid_time_us:1660202679082609, last_access_time_us:1660202681184023, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"DELETED"}, this:0x7f4b5f44bf80, 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:2, name:{cluster_name:"obgctest", 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:31, buf_start:0x7f4b5f44c080, tenant_servers:{this:0x7f4b5f121530, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f4b6e6b06d0, server_array_:[[0]{server:"21.32.3.186:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"21.32.3.187:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"21.32.3.188:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}) [2022-08-11 15:25:04.015059] INFO [PROXY.CS] ob_mysql_client_session.cpp:501 [754][Y0-7F4B593C2DF0] [lt=7] [dc=0] proxy mysql client session born(cs_id=2147686965) [2022-08-11 15:25:04.015088] INFO [PROXY.CS] ob_mysql_client_session.cpp:326 [754][Y0-7F4B593C2DF0] [lt=21] [dc=0] client session born(cs_id=2147686965, proxy_sessid=0, is_local_connection=true, client_vc=0x7f4b6e673fc0, client_fd=0, client_addr="0.0.0.0") [2022-08-11 15:25:04.015113] INFO [PROXY.CS] ob_mysql_client_session.cpp:204 [754][Y0-7F4B593C2DF0] [lt=12] [dc=0] Starting new transaction using sm(cs_id=2147686965, get_transact_count()=0, sm_id=21485) [2022-08-11 15:25:04.015125] INFO [PROXY.SM] ob_mysql_sm.cpp:438 [754][Y0-7F4B593C2DF0] [lt=6] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true) [2022-08-11 15:25:04.015357] INFO [PROXY.SS] ob_mysql_server_session.cpp:102 [754][Y0-7F4B593C2DF0] [lt=5] [dc=0] server session born(ss_id=30626, server_ip={21.32.3.55:2881}, cs_id=2147686965, proxy_sessid=0, server_type=1) [2022-08-11 15:25:04.015628] INFO [PROXY.TXN] ob_mysql_transact.cpp:3440 [754][Y0-7F4B593C2DF0] [lt=18] [dc=0] succ to set proxy_sessid(cs_id=2147686965, proxy_sessid=8743, server_ip={21.32.3.55:2881}, ss_id=30626, server_sessid=3221716027, is_proxy_mysql_client=true, ss_fd=427, client_addr="21.32.3.185:53242") [2022-08-11 15:25:04.017383] INFO [PROXY] ob_proxy_session_info_handler.cpp:676 [754][Y0-7F4B593C2DF0] [lt=15] [dc=0] get global vars version(value=0, version=0) [2022-08-11 15:25:04.017416] INFO [PROXY] ob_proxy_session_info_handler.cpp:709 [754][Y0-7F4B593C2DF0] [lt=18] [dc=0] succ to set ob_capability_flag(client_cap=2639, server_cap=2639, orgin_cap=2639, support_checksum=true, is_auth_request=true) [2022-08-11 15:25:04.017430] INFO [PROXY] ob_proxy_session_info_handler.cpp:731 [754][Y0-7F4B593C2DF0] [lt=6] [dc=0] succ to set checksum_switch(enable_transmission_checksum=1, old_switch=1, is_auth_request=true) [2022-08-11 15:25:04.017551] INFO [PROXY.SS] ob_mysql_server_session.cpp:139 [754][Y0-7F4B593C2DF0] [lt=7] [dc=0] server session do_io_close((*this={ss_id:30626, server_sessid:3221716027, server_ip:{21.32.3.55:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f4b59394380, client_session:{this:0x7f4b5fe72530, 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:754, cs_id:2147686965, proxy_sessid:8743, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147686965, user_priv_set:512, cluster_name:"obcentoscluster", 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}, 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}, 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:5, 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}, 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:"21.32.3.55: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:"21.32.3.91: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:"21.32.3.90: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:0x7f4b5f11f6a0, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f4b5f11f1d0, server_state_version:5, cur_ss:null, bound_ss:0x7f4b593baea0, lii_ss:null, cluster_resource:{this:0x7f4b7d600c10, ref_count:9, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcentoscluster"}, cluster_id:5}, cr_state:"CR_AVAIL", version:905, last_access_time_ns:1660202403197971982, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1660197702866167911, last_rslist_refresh_time_ns:1660202509496763169, server_state_version:5, dummy_entry:{{this:0x7f4b59388920, ref_count:1, cr_version:0, cr_id:5, create_time_us:1660158706091888, last_valid_time_us:1660158706091845, last_access_time_us:1660158883872211, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"DELETED"}, this:0x7f4b59388920, 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:5, name:{cluster_name:"obcentoscluster", 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:38, buf_start:0x7f4b59388a20, tenant_servers:{this:0x7f4b5f1215c0, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f4b5ff66d80, server_array_:[[0]{server:"21.32.3.91:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"21.32.3.90:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"21.32.3.55:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}}, client_vc:0x7f4b6e673fc0, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:2639, 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}, 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_=0x7f4b59394380, this=0x7f4b593baea0) [2022-08-11 15:25:04.017749] INFO [PROXY.SS] ob_mysql_server_session.cpp:173 [754][Y0-7F4B593C2DF0] [lt=198] [dc=0] server session is closing(ss_id=30626, server_sessid=3221716027, server_ip={21.32.3.55:2881}, cs_id=2147686965, proxy_sessid=8743) [2022-08-11 15:25:04.017822] INFO [PROXY.SS] ob_mysql_server_session.cpp:102 [754][Y0-7F4B593C2DF0] [lt=7] [dc=0] server session born(ss_id=30627, server_ip={21.32.3.55:2881}, cs_id=2147686965, proxy_sessid=8743, server_type=1) [2022-08-11 15:25:04.019190] INFO [PROXY] ob_proxy_session_info_handler.cpp:709 [754][Y0-7F4B593C2DF0] [lt=16] [dc=0] succ to set ob_capability_flag(client_cap=2639, server_cap=2639, orgin_cap=2639, support_checksum=true, is_auth_request=false) [2022-08-11 15:25:04.020804] INFO [PROXY.SM] ob_mysql_sm.cpp:7565 [754][Y0-7F4B593C2DF0] [lt=12] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={21.32.3.55:2881}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obcentoscluster, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=1, cs_id=2147686965, proxy_sessid=8743, ss_id=30627, server_sessid=3221716028, sm_id=21485, cmd_size_stats={client_request_bytes:25, server_request_bytes:43, server_response_bytes:11, client_response_bytes:11}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=28, client_request_analyze_time_us=27, cluster_resource_create_time_us=0, pl_lookup_time_us=0, pl_process_time_us=0, congestion_control_time_us=0, congestion_process_time_us=0, do_observer_open_time_us=289, server_connect_time_us=51, server_sync_session_variable_time_us=1975, server_send_saved_login_time_us=1003, server_send_use_database_time_us=248, server_send_session_variable_time_us=723, 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=17, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2675, server_request_write_time_us=11, server_process_request_time_us=578, server_response_read_time_us=1, plugin_decompress_response_time_us=0, server_response_analyze_time_us=6, ok_packet_trim_time_us=3, client_response_write_time_us=11, request_total_time_us=3289}, sql=SET @@autocommit = 1) [2022-08-11 15:25:04.020927] INFO [PROXY.CS] ob_mysql_transact.cpp:4940 [754][Y0-7F4B593C2DF0] [lt=31] [dc=0] succ to global variable proxy_route_policy(policy=) ^C [root@aobceocp01 log]#