【 使用环境 】生产环境
【 OB or 其他组件 】obproxy
【 使用版本 】4.1.0.0
【问题描述】在obproxy.log 文件中查询慢sql日志,发现sql字段有的不显示
举例:
sql=*^G,
sql=SET @@autocommit = 1
sql= ,
【复现路径】无
日志如下
[2024-07-22 15:24:37.399997] WARN [PROXY.SM] update_cmd_stats (ob_mysql_sm.cpp:9761) [2134156][Y0-00007F4F213F22E0] [lt=52] [dc=0] Slow
Query: ((client_ip={192.125.38.55:54446}, server_ip={192.125.38.19:2881}, obproxy_client_port={192.125.38.13:53710}, server_trace_id=YB42
C07D2613-00060300627A5F8E-0-0, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=root, tenant_name=sys, cluster_name=oceanbase5
, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2908464, proxy_sessid=13870284264836401133, ss_id=1503520848, serv
er_sessid=3222067525, sm_id=256178987, cmd_size_stats={client_request_bytes:119, server_request_bytes:235, server_response_bytes:52, clie
nt_response_bytes:52}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=9, client_request_analyze_time_us=7
, cluster_resource_create_time_us=0, pl_lookup_time_us=25235, pl_process_time_us=19, bl_lookup_time_us=0, bl_process_time_us=0, congestio
n_control_time_us=2, congestion_process_time_us=0, do_observer_open_time_us=7, server_connect_time_us=0, server_sync_session_variable_tim
e_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_sessio
n_user_variable_time_us=0, server_send_all_session_variable_time_us=0, server_send_start_trans_time_us=0, server_send_xa_start_time_us=0,
build_server_request_time_us=11, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=25293, server_request_write_t
ime_us=104, server_process_request_time_us=1280390, server_response_read_time_us=6, plugin_decompress_response_time_us=0, server_response
_analyze_time_us=40, ok_packet_trim_time_us=43, client_response_write_time_us=138, request_total_time_us=1305991}, sql=*^G, trans_interna
l_routing_state=not in trans)