业务连接ob断连2分钟

【 使用环境 】生产环境
【 OB or 其他组件 】ob and obproxy
【 使用版本 】ob:4.2.5.7-107010012026030415
obproxy: 4.2.1.0-11
【问题描述】
1、应用连接报错o.s.b.a.jdbc.DataSourceHealthIndicator:DataSource health check failed cause:org.springfrmework.jdbc.CannotGetJdbcConnectionException:failed to obtain jdbc Connection
15:26-28直接无法连接数据库
2、查看ocp监控
obproxy在15:26-28之间qps tps跌0
3、日志分析
os日志问题时间段无明显报错
(1)obproxy


查看obproxy.log发现大量handle_server_connection_break
查看obproxy_error发现大量断连

obproxy日志来看应该都是Observer主动断开和porxy之间连接
(2)observer
问题时间段发生大量主动断连

(3)找一个proxy_session_id对应observer断连过程


需求:帮忙分析下断连原因
【复现路径】暂时没有复现
【附件及日志】

7 个赞

怀疑是Observer侧异常或变更,引发连锁断连 在发一下obproxy_error.log obproxy.log obproxy_diagnosis.log observer.log报错的时候的日志 看看具体什么问题导致的obproxy在15:26-28之间qps tps跌0

5 个赞

日志级别?

3 个赞

V版

2 个赞

学习了

2 个赞

7/28 20:08 有发生一次 ,


查看这是时间的 obproxy_error (1).log

2026-07-28 20:02:54.276054,fdproxy,,,,::,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,-4124,,41us,0us,0us,0us,Y0-00007F270FD5B020,,,,0,,Connect error,
2026-07-28 20:02:54.944295,fdproxy,,,,::,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,-4124,,36us,0us,0us,0us,Y0-00007F270FD5B020,,,,0,,Connect error,
2026-07-28 20:02:57.277157,fdproxy,,,,::,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,-4124,,35us,0us,0us,0us,Y0-00007F26D0BF82D0,,,,0,,Connect error,
2026-07-28 20:02:57.942632,fdproxy,,,,::,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,-4124,,32us,0us,0us,0us,Y0-00007F26D0BF82D0,,,,0,,Connect error,
2026-07-28 20:02:58.088954,fdproxy,,,,catl_cloudDB_FD:CTSCREEN:ctscreen,OB_MYSQL,screen,screen,OB_MYSQL_COM_QUERY,INSERT,failed,1364,INSERT INTO screen  ( factory%2C%0Aline%2C%0A%0Aclasstype%2C%0Aupdatetime%2C%0Astationinfo%2C%0Aaveragect%2C%0Aallcountct%2C%0Apasscountct%2C%0Afailcountct%2C%0Actset%2C%0Aplancount%2C%0Acurrentcount )  VALUES  ( 'M2'%2C%0A'PL05N'%2C%0A%0A'夜班'%2C%0A'2026-07-28 

通过 Y0-00007F270FD5B020 去搜索

[2026-07-28 20:00:12.256594] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.256609] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.256623] WARN [PROXY] get_user_name (ob_session_field_mgr.cpp:653) [45904][Y0-00007F270FD5B020] [lt=14] [dc=0] fail to get user name(ret=-4018)
[2026-07-28 20:00:12.256670] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=4] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723055, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:12.256708] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=36] [dc=0] client session destroy(cs_id=1723055, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:12.256719] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] deallocating sm(sm_id=57870681)
[2026-07-28 20:00:12.676570] INFO [PROXY.NET] ob_mysql_session_accept.cpp:36 [45904][Y0-00007F270FD5B020] [lt=2] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f26e55aad30, client_ip={172.18.46.52:10340})
[2026-07-28 20:00:12.676596] INFO [PROXY.NET] ob_unix_net_vconnection.cpp:1255 [45904][Y0-00007F270FD5B020] [lt=7] [dc=0] vip connect(protocol=6, fd=1086, vid=0, vaddr={172.18.46.52:2883}, caddr={172.18.46.52:10340}, daddr={10.167.205.33:2883})
[2026-07-28 20:00:12.676608] INFO [PROXY.CS] ob_mysql_client_session.cpp:370 [45904][Y0-00007F270FD5B020] [lt=10] [dc=0] client session born(cs_id=1723057, proxy_sessid=0, is_local_connection=false, client_vc=0x7f26e55aad30, client_fd=1086, client_addr="172.18.46.52:10340")
[2026-07-28 20:00:12.676625] INFO [PROXY.CS] ob_mysql_client_session.cpp:241 [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] Starting new transaction using sm(cs_id=1723057, get_transact_count()=0, sm_id=57870686)
[2026-07-28 20:00:12.676631] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true)
[2026-07-28 20:00:12.676636] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.676661] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=25] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.680591] INFO [PROXY.SM] ob_mysql_sm.cpp:2563 [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] client login audit(client_addr={172.18.46.52:10340}, hsr.cluster_name_=catl_cloudDB_FD, hsr.tenant_name_=proxysys, hsr.user_name_=root, status="success")
[2026-07-28 20:00:12.719546] INFO [PROXY.SM] ob_mysql_sm.cpp:9000 [45904][Y0-00007F270FD5B020] [lt=7] [dc=0] [setup_error_transfer] Now closing connection caused by OB_MYSQL_COM_QUIT(sm_id=57870686, request_cmd="Quit", sql_cmd="Quit", sql=)
[2026-07-28 20:00:12.719558] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=9] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723057, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:true, cs_id:1723057, user_priv_set:-1, cluster_name:"catl_cloudDB_FD", tenant_name:"proxysys", user_name:"root"}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:3, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:12.719593] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=32] [dc=0] client session destroy(cs_id=1723057, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:12.719606] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] deallocating sm(sm_id=57870686)
[2026-07-28 20:00:12.923919] INFO [PROXY.NET] ob_mysql_session_accept.cpp:36 [45904][Y0-00007F270FD5B020] [lt=4] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f26e55aad30, client_ip={10.167.205.65:40104})
[2026-07-28 20:00:12.923952] INFO [PROXY.NET] ob_unix_net_vconnection.cpp:1255 [45904][Y0-00007F270FD5B020] [lt=12] [dc=0] vip connect(protocol=6, fd=1226, vid=0, vaddr={10.167.205.65:2883}, caddr={10.167.205.65:40104}, daddr={10.167.205.33:2883})
[2026-07-28 20:00:12.923961] INFO [PROXY.CS] ob_mysql_client_session.cpp:370 [45904][Y0-00007F270FD5B020] [lt=7] [dc=0] client session born(cs_id=1723058, proxy_sessid=0, is_local_connection=false, client_vc=0x7f26e55aad30, client_fd=1226, client_addr="10.167.205.65:40104")
[2026-07-28 20:00:12.923975] INFO [PROXY.CS] ob_mysql_client_session.cpp:241 [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] Starting new transaction using sm(cs_id=1723058, get_transact_count()=0, sm_id=57870688)
[2026-07-28 20:00:12.923982] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true)
[2026-07-28 20:00:12.923987] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.924009] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=22] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.924095] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=13] [dc=0] the request already in buffer, continue to handle it(buffer len=16, is_auth_rquest=true)
[2026-07-28 20:00:12.924102] INFO [PROXY.SM] ob_mysql_sm.cpp:610 [45904][Y0-00007F270FD5B020] [lt=2] [dc=0] ObMysqlSM::state_client_request_read(event="VC_EVENT_EOS", sm_id=57870688, client_vc=0x7f26e55aad30)
[2026-07-28 20:00:12.924108] WARN [PROXY.SM] state_client_request_read (ob_mysql_sm.cpp:783) [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] EOS before client request parsing finished(sm_id=57870688, ret=-4124)
[2026-07-28 20:00:12.924124] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8124) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] client will abort soon(sm_id=57870688, cs_id=1723058, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={10.167.205.65:40104}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_LOGIN)
[2026-07-28 20:00:12.924145] INFO [PROXY.TXN] ob_mysql_transact.cpp:142 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] [ObMysqlTransact::bad_request] parser marked request bad
[2026-07-28 20:00:12.924147] WARN [PROXY.SM] setup_error_transfer (ob_mysql_sm.cpp:9009) [45904][Y0-00007F270FD5B020] [lt=2] [dc=0] [setup_error_transfer] Now closing connection(sm_id=57870688, client_ip={10.167.205.65:40104}, request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_LOGIN)
[2026-07-28 20:00:12.924164] INFO [PROXY.SM] ob_mysql_sm.cpp:9534 [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] will deallocate sm(sm_id=57870688, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0)
[2026-07-28 20:00:12.924168] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.924182] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=14] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.924197] WARN [PROXY] get_user_name (ob_session_field_mgr.cpp:653) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] fail to get user name(ret=-4018)
[2026-07-28 20:00:12.924251] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=1] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723058, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:12.924283] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=30] [dc=0] client session destroy(cs_id=1723058, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:12.924293] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] deallocating sm(sm_id=57870688)
[2026-07-28 20:00:13.070018] INFO [PROXY.NET] ob_mysql_session_accept.cpp:36 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f26e55aad30, client_ip={127.0.0.1:64768})
[2026-07-28 20:00:13.070043] INFO [PROXY.NET] ob_unix_net_vconnection.cpp:1255 [45904][Y0-00007F270FD5B020] [lt=9] [dc=0] vip connect(protocol=6, fd=1284, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:64768}, daddr={127.0.0.1:2883})
[2026-07-28 20:00:13.070053] INFO [PROXY.CS] ob_mysql_client_session.cpp:370 [45904][Y0-00007F270FD5B020] [lt=8] [dc=0] client session born(cs_id=1723059, proxy_sessid=0, is_local_connection=true, client_vc=0x7f26e55aad30, client_fd=1284, client_addr="127.0.0.1:64768")
[2026-07-28 20:00:13.070067] INFO [PROXY.CS] ob_mysql_client_session.cpp:241 [45904][Y0-00007F270FD5B020] [lt=6] [dc=0] Starting new transaction using sm(cs_id=1723059, get_transact_count()=0, sm_id=57870690)
[2026-07-28 20:00:13.070072] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true)
[2026-07-28 20:00:13.070076] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:13.070097] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=21] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:13.070169] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6032) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=57870690)
[2026-07-28 20:00:13.070189] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8124) [45904][Y0-00007F270FD5B020] [lt=19] [dc=0] client will abort soon(sm_id=57870690, cs_id=1723059, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:64768}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Delete session", sql=OB_MYSQL_COM_HANDSHAKE)
[2026-07-28 20:00:13.070215] INFO [PROXY.SM] ob_mysql_sm.cpp:9534 [45904][Y0-00007F270FD5B020] [lt=4] [dc=0] will deallocate sm(sm_id=57870690, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0)
[2026-07-28 20:00:13.070221] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=4] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723059, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:13.070259] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=36] [dc=0] client session destroy(cs_id=1723059, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:13.070272] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] deallocating sm(sm_id=57870690)
[2026-07-28 20:00:14.107027] INFO [PROXY.NET] ob_mysql_session_accept.cpp:36 [45892][Y0-00007F270FD5B020] [lt=4] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f26e55aad30, client_ip={10.167.198.37:39090})
[2026-07-28 20:00:14.107057] INFO [PROXY.NET] ob_unix_net_vconnection.cpp:1255 [45892][Y0-00007F270FD5B020] [lt=9] [dc=0] vip connect(protocol=6, fd=943, vid=0, vaddr={10.167.198.37:2883}, caddr={10.167.198.37:39090}, daddr={10.167.205.63:2883})
[2026-07-28 20:00:14.107066] INFO [PROXY.CS] ob_mysql_client_session.cpp:370 [45892][Y0-00007F270FD5B020] [lt=7] [dc=0] client session born(cs_id=1321868, proxy_sessid=0, is_local_connection=false, client_vc=0x7f26e55aad30, client_fd=943, client_addr="10.167.198.37:39090")
[2026-07-28 20:00:14.107078] INFO [PROXY.CS] ob_mysql_client_session.cpp:241 [45892][Y0-00007F270FD5B020] [lt=5] [dc=0] Starting new transaction using sm(cs_id=1321868, get_transact_count()=0, sm_id=57870695)
[2026-07-28 20:00:14.107084] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45892][Y0-00007F270FD5B020] [lt=3] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true)
[2026-07-28 20:00:14.107089] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45892][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:14.107108] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45892][Y0-00007F270FD5B020] [lt=19] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:14.107517] INFO [PROXY.SM] ob_mysql_sm.cpp:1979 [45892][Y0-00007F270FD5B020] [lt=14] [dc=0] final client capability flag in negotiation(last_client_cap=0, is_client_support_ob20=false)
[2026-07-28 20:00:14.107523] INFO [PROXY] ob_vip_tenant_conn.cpp:162 [45892][Y0-00007F270FD5B020] [lt=3] [dc=0] vip tenant connect is not in vip_tenant_conn_cache(key_name=CTMS#catl_cloudDB_FD|, ret=-4018)
[2026-07-28 20:00:14.107527] INFO [PROXY.SM] ob_mysql_sm.cpp:2563 [45892][Y0-00007F270FD5B020] [lt=3] [dc=0] client login audit(client_addr={10.167.198.37:39090}, hsr.cluster_name_=catl_cloudDB_FD, hsr.tenant_name_=CTMS, hsr.user_name_=a_ctms, status="success")
[2026-07-28 20:00:14.109117] INFO [PROXY.SS] ob_mysql_server_session.cpp:106 [45892][Y0-00007F270FD5B020] [lt=4] [dc=0] server session born(ss_id=51566125, server_ip={10.167.205.32:2881}, cs_id=1321868, proxy_sessid=0, server_type=1)
[2026-07-28 20:00:14.110946] INFO [PROXY.TXN] ob_mysql_transact.cpp:4726 [45892][Y0-00007F270FD5B020] [lt=4] [dc=0] succ to set proxy_sessid(cs_id=1321868, proxy_sessid=767807932145581179, server_ip={10.167.205.32:2881}, ss_id=51566125, server_sessid=3224141916, is_proxy_mysql_client=false, ss_fd=1148, client_addr="10.167.198.37:39090")
[2026-07-28 20:00:14.113480] INFO [PROXY] ob_proxy_session_info_handler.cpp:713 [45892][Y0-00007F270FD5B020] [lt=6] [dc=0] get global vars version(value=0, version=0)
[2026-07-28 20:00:14.113489] INFO [PROXY] ob_proxy_session_info_handler.cpp:746 [45892][Y0-00007F270FD5B020] [lt=5] [dc=0] succ to set ob_capability_flag in negotiation(client_cap=0, server_cap=916303, orig_client_cap=0, orig_server_cap=916303, client_support_ob_v2=false, server_support_checksum=true, server_support_ob_v2=true, is_auth_request=true)
[2026-07-28 20:00:14.113497] INFO [PROXY] ob_proxy_session_info_handler.cpp:773 [45892][Y0-00007F270FD5B020] [lt=5] [dc=0] succ to set checksum_switch(enable_transmission_checksum=1, old_switch=1, is_auth_request=true)
[2026-07-28 20:00:14.113606] INFO [PROXY] ob_session_field_mgr.cpp:1250 [45892][Y0-00007F270FD5B020] [lt=2] [dc=0] user variable not exist(name=_min_cluster_version, ret=-4018)
[2026-07-28 20:00:14.113624] INFO [PROXY.SM] ob_mysql_sm.cpp:10217 [45892][Y0-00007F270FD5B020] [lt=5] [dc=0] Slow Query: ((client_ip={10.167.198.37:39090}, server_ip={10.167.205.32:2881}, obproxy_client_port={10.167.205.33:43740}, server_trace_id=Y0-0, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=a_ctms, tenant_name=CTMS, cluster_name=catl_cloudDB_FD, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=0, cs_id=1321868, proxy_sessid=767807932145581179, ss_id=51566125, server_sessid=3224141916, sm_id=57870695, cmd_size_stats={client_request_bytes:258, server_request_bytes:384, server_response_bytes:11, client_response_bytes:11}, cmd_time_stats={client_transaction_idle_time_us=290, client_request_read_time_us=57, client_request_analyze_time_us=52, cluster_resource_create_time_us=0, pl_lookup_time_us=9, pl_process_time_us=7, bl_lookup_time_us=0, bl_process_time_us=0, congestion_control_time_us=1, congestion_process_time_us=0, do_observer_open_time_us=1562, server_connect_time_us=1546, 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_session_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, server_send_init_sql_time_us=0, build_server_request_time_us=0, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3499, server_request_write_time_us=5, server_process_request_time_us=2227, server_response_read_time_us=198, plugin_decompress_response_time_us=0, server_response_analyze_time_us=3, ok_packet_trim_time_us=200, client_response_write_time_us=206, request_total_time_us=6143}, sql=OB_MYSQL_COM_LOGIN, trans_internal_routing_state=not in trans)
[2026-07-28 20:00:14.114389] INFO [PROXY] ob_proxy_session_info_handler.cpp:773 [45892][Y0-00007F270FD5B020] [lt=25] [dc=0] succ to set checksum_switch(enable_transmission_checksum=1, old_switch=1, is_auth_request=false)
[2026-07-28 20:01:11.748245] WARN [PROXY.SM] handle_server_setup_error (ob_mysql_sm.cpp:8405) [45892][Y0-00007F270FD5B020] [lt=18] [dc=0] trace_log(trans_state_.trace_log_= | dropped=0)
[2026-07-28 20:01:11.748270] INFO [PROXY.SS] ob_mysql_server_session.cpp:153 [45892][Y0-00007F270FD5B020] [lt=24] [dc=0] server session do_io_close((*this={ss_id:51566125, server_sessid:3224141916, server_ip:{10.167.205.32:2881}, is_inited:true, magic:19136237, state:1, server_vc:0x7f2700e4f950, client_session:{this:0x7f270f39a600, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45892, cs_id:1321868, proxy_sessid:767807932145581179, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:1321868, user_priv_set:412325314558, cluster_name:"catl_cloudDB_FD", tenant_name:"CTMS", user_name:"a_ctms"}, 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:1, sys_var_version:7, user_var_version:1, db_name_version:1, last_insert_id_version:0, sess_info_version:5}, 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:0, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:916303, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3,  

2 个赞

可以看到有很多 报错

[2026-07-28 20:00:12.676636] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.676661] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=25] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.680591] INFO [PROXY.SM] ob_mysql_sm.cpp:2563 [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] client login audit(client_addr={172.18.46.52:10340}, hsr.cluster_name_=catl_cloudDB_FD, hsr.tenant_name_=proxysys, hsr.user_name_=root, status="success")
[2026-07-28 20:00:12.719546] INFO [PROXY.SM] ob_mysql_sm.cpp:9000 [45904][Y0-00007F270FD5B020] [lt=7] [dc=0] [setup_error_transfer] Now closing connection caused by OB_MYSQL_COM_QUIT(sm_id=57870686, request_cmd="Quit", sql_cmd="Quit", sql=)
[2026-07-28 20:00:12.719558] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=9] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723057, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:true, cs_id:1723057, user_priv_set:-1, cluster_name:"catl_cloudDB_FD", tenant_name:"proxysys", user_name:"root"}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:3, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:12.719593] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=32] [dc=0] client session destroy(cs_id=1723057, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:12.719606] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] deallocating sm(sm_id=57870686)
[2026-07-28 20:00:12.923919] INFO [PROXY.NET] ob_mysql_session_accept.cpp:36 [45904][Y0-00007F270FD5B020] [lt=4] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f26e55aad30, client_ip={10.167.205.65:40104})
[2026-07-28 20:00:12.923952] INFO [PROXY.NET] ob_unix_net_vconnection.cpp:1255 [45904][Y0-00007F270FD5B020] [lt=12] [dc=0] vip connect(protocol=6, fd=1226, vid=0, vaddr={10.167.205.65:2883}, caddr={10.167.205.65:40104}, daddr={10.167.205.33:2883})
[2026-07-28 20:00:12.923961] INFO [PROXY.CS] ob_mysql_client_session.cpp:370 [45904][Y0-00007F270FD5B020] [lt=7] [dc=0] client session born(cs_id=1723058, proxy_sessid=0, is_local_connection=false, client_vc=0x7f26e55aad30, client_fd=1226, client_addr="10.167.205.65:40104")
[2026-07-28 20:00:12.923975] INFO [PROXY.CS] ob_mysql_client_session.cpp:241 [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] Starting new transaction using sm(cs_id=1723058, get_transact_count()=0, sm_id=57870688)
[2026-07-28 20:00:12.923982] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true)
[2026-07-28 20:00:12.923987] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.924009] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=22] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.924095] INFO [PROXY.SM] ob_mysql_sm.cpp:521 [45904][Y0-00007F270FD5B020] [lt=13] [dc=0] the request already in buffer, continue to handle it(buffer len=16, is_auth_rquest=true)
[2026-07-28 20:00:12.924102] INFO [PROXY.SM] ob_mysql_sm.cpp:610 [45904][Y0-00007F270FD5B020] [lt=2] [dc=0] ObMysqlSM::state_client_request_read(event="VC_EVENT_EOS", sm_id=57870688, client_vc=0x7f26e55aad30)
[2026-07-28 20:00:12.924108] WARN [PROXY.SM] state_client_request_read (ob_mysql_sm.cpp:783) [45904][Y0-00007F270FD5B020] [lt=5] [dc=0] EOS before client request parsing finished(sm_id=57870688, ret=-4124)
[2026-07-28 20:00:12.924124] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8124) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] client will abort soon(sm_id=57870688, cs_id=1723058, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={10.167.205.65:40104}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_LOGIN)
[2026-07-28 20:00:12.924145] INFO [PROXY.TXN] ob_mysql_transact.cpp:142 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] [ObMysqlTransact::bad_request] parser marked request bad
[2026-07-28 20:00:12.924147] WARN [PROXY.SM] setup_error_transfer (ob_mysql_sm.cpp:9009) [45904][Y0-00007F270FD5B020] [lt=2] [dc=0] [setup_error_transfer] Now closing connection(sm_id=57870688, client_ip={10.167.205.65:40104}, request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_LOGIN)
[2026-07-28 20:00:12.924164] INFO [PROXY.SM] ob_mysql_sm.cpp:9534 [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] will deallocate sm(sm_id=57870688, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0)
[2026-07-28 20:00:12.924168] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] fail to get cluster name(ret=-4018)
[2026-07-28 20:00:12.924182] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:629) [45904][Y0-00007F270FD5B020] [lt=14] [dc=0] fail to get tenant name(ret=-4018)
[2026-07-28 20:00:12.924197] WARN [PROXY] get_user_name (ob_session_field_mgr.cpp:653) [45904][Y0-00007F270FD5B020] [lt=15] [dc=0] fail to get user name(ret=-4018)
[2026-07-28 20:00:12.924251] INFO [PROXY.SS] ob_mysql_client_session.cpp:652 [45904][Y0-00007F270FD5B020] [lt=1] [dc=0] client session do_io_close((*this={this:0x7f2703ce63f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:45904, cs_id:1723058, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, 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}, 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:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, 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:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f26e55aad30, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f26e55aad30, this=0x7f2703ce63f0)
[2026-07-28 20:00:12.924283] INFO [PROXY.CS] ob_mysql_client_session.cpp:94 [45904][Y0-00007F270FD5B020] [lt=30] [dc=0] client session destroy(cs_id=1723058, proxy_sessid=0, client_vc=NULL)
[2026-07-28 20:00:12.924293] INFO [PROXY.SM] ob_mysql_sm.cpp:9653 [45904][Y0-00007F270FD5B020] [lt=3] [dc=0] deallocating sm(sm_id=57870688)
2 个赞

报错基本上都是

断链过程(基于日志链路)

1.  accepted connection
2. vip connect
3.client session born
4.Starting new transaction using sm  正常建立
5. the request already in buffer, continue to handle it
6.fail to get cluster name(ret=-4018) 
7.the request already in buffer, continue to handle it
8.ObMysqlSM::state_client_request_read(event="VC_EVENT_EOS", 立刻收到 VC_EVENT_EOS(客户端 EOF/FIN)
9.  EOS before client request parsing finished
10. client will abort soon
11. [ObMysqlTransact::bad_request] parser marked request bad
2 个赞

日志级别?

可以把这个段时间的日志 收集一下 发一下
obproxy_error.log obproxy.log obproxy_diagnosis.log observer.log报错的时候的日志

1 个赞

稍等,日志有点大。

看着你发的日志信息是 登录过程中被客户端断连了

1 个赞

日志 私有你消息了,你看看能下载不?

fail to get cluster name(ret=-4018)
一直报这个

fail to get cluster name(ret=-4018) 一直报这个

看着日志信息 不对呀 这个是ocp的日志呀 不是obproxy的日和observer.log

这个不是问题的根因 这个应该登录前拿不到 cluster/tenant/user信息 属于正常 主要看4124这个报错


看看 是不是odp 的 日志

这个是的 看看时间上对不对

昨晚的 observer 日志没了。
不过这个 fail to get cluster name(ret=-4018) 还在报错的,如果需要我剋有发 一份 最新的给您。