通过2883 obproxy链接异常

OceanBase 技术问题
,
#1

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：

【SOP系列 22 】——故障诊断第一步(自助诊断和诊断信息收集)

obproxy报错如下

[2025-10-04 20:51:31.123101] INFO [PROXY] handle_active_timeout (ob_client_vc.cpp:735) [10930][Y0-00007F406DA7A3B0] [lt=0] [dc=0] mysql client active timeout(active_timeout_ms=0, next_action=1, info={user_name:“proxyro@sys#zhouming:0”, database_name:“oceanbase”, cluster_name:“zhouming”, request_param:{sql:"", is_deep_copy:false, current_idc_name:"", is_user_idc_name_set:false, need_print_trace_stat:false, target_addr:, ob_client_flags_.flags_:0, client_vc_type:0}})

obclient 报错如下

[root@oceanbase1 ~]# obclient -uroot@sys#zhouming -pZhouming1 -P2883 -h192.168.56.183
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 11

【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试，在发帖时输入 [@论坛小助手] 即可召唤小助手，欢迎试用！

5 个赞
#3

这是啥情况

3 个赞
#4

学习下

2 个赞
#5

也想知道是什么原因，看看楼下的大佬的回复。

1 个赞
#6

学习一下

1 个赞
#7

这个报错有点像proxyro密码错误，obproxy.log里面有相关报错能看出来，你找的都是INFO级别日志

image
image1310×160 7.53 KB

2 个赞
#8

[2025-10-06 00:41:08.636599] [7143][Y0-00002AF49392E760] [LOGIN](trace_type=“PROXY_INTERNAL_TRACE”, connection_diagnosis={cs_id:18, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:9944”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“proxysys”, user_name:“root”, error_code:0, error_msg:“Can not find any matching row in the user table”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):17066}{user_sql:""})
[2025-10-06 00:44:19.530628] [7143][Y0-00002AF49352E760] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:19, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:10424”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“sys”, user_name:“root”, error_code:1045, error_msg:“fail to check observer version, proxyro@sys access denied, error resp { code:1045, msg:Access denied for user ‘proxyro’@'xxx.xx”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):327937}{internal_sql:“SELECT ob_version() AS cluster_version”, login_result:“failed”})
[2025-10-06 00:44:41.022030] [7143][Y0-00002AF49392E760] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:28, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:10470”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“sys”, user_name:“root”, error_code:1045, error_msg:“fail to check observer version, proxyro@sys access denied, error resp { code:1045, msg:Access denied for user ‘proxyro’@'xxx.xx”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):204965}{internal_sql:“SELECT ob_version() AS cluster_version”, login_result:“failed”})
[2025-10-06 00:52:42.212313] [7143][Y0-00002AF49352E760] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:37, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:11638”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“sys”, user_name:“root”, error_code:1045, error_msg:“fail to check observer version, proxyro@sys access denied, error resp { code:1045, msg:Access denied for user ‘proxyro’@'xxx.xx”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):262273}{internal_sql:“SELECT ob_version() AS cluster_version”, login_result:“failed”})
[2025-10-06 00:52:47.929243] [7143][Y0-00002AF49392E760] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:46, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:11650”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“sys”, user_name:“root”, error_code:1045, error_msg:“fail to check observer version, proxyro@sys access denied, error resp { code:1045, msg:Access denied for user ‘proxyro’@'xxx.xx”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):232454}{internal_sql:“SELECT ob_version() AS cluster_version”, login_result:“failed”})
[2025-10-06 00:52:53.004425] [7143][Y0-00002AF49352E760] [LOGIN](trace_type=“PROXY_INTERNAL_TRACE”, connection_diagnosis={cs_id:55, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“192.168.56.181:11670”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:“zhouming”, tenant_name:“proxysys”, user_name:“root”, error_code:0, error_msg:“Can not find any matching row in the user table”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_LOGIN”, req_total_time(us):0}{user_sql:""})

1 个赞
#9

密码应该没有错， 我单独用proxyro登录通过2881登录OBSERVER

1 个赞
#10

[2025-10-06 00:52:47.928738] INFO [PROXY] handle_active_timeout (ob_client_vc.cpp:735) [7152][Y0-00002AF48C8882D0] [lt=0] [dc=0] mysql client active timeout(active_timeout_ms=0, next_action=1, info={user_name:“proxyro@sys#zhouming:0”, database_name:“oceanbase”, cluster_name:“zhouming”, request_param:{sql:"", is_deep_copy:false, current_idc_name:"", is_user_idc_name_set:false, need_print_trace_stat:false, target_addr:, ob_client_flags_.flags_:0, client_vc_type:0}})

obproxy的日志

2 个赞
#11

这里报了proxyro的密码不对。。我估计是obproxy中记录的proxyro密码和集群记录的密码不匹配，你的环境是手动部署或者修改过proxyro的密码？
要不然就修改下obproxy中proxyro的密码，保持集群一致

https://www.oceanbase.com/knowledge-base/oceanbase-database-proxy-1000000001046115?back=kb

#12

学习学习

#13

666