【 使用环境 】测试环境
【 OB or 其他组件 】oblogproxy
【 使用版本 】 oblogproxy-ce-for-4x-1.1.3-20230815201457
【问题描述】使用 Java oblogclient 连接报错
【复现路径】按照官网文档进行安装,使用官网的Java示例代码连接后 oblogproxy 报错,无法接收到消息
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000035817
【问题现象及影响】
错误日志:
I20230918 18:57:41.710290 6889 status_thread.cpp:47] COUNTS:[NREADER:3][NCHANNEL:0]
I20230918 18:57:42.311136 6889 status_thread.cpp:64] METRICS:[MEM:8518/32012MB,26.61%][UDISK:45190/186320MB,24.25%][CPU:2,44.4%][LOAD1,5:383%,604%][NETIO:0KB/s,0KB/s]
I20230918 18:57:43.822476 6886 comm.cpp:165] On connect from '192.168.11.50:64268, fd: 8
I20230918 18:57:44.322793 6886 comm.cpp:232] On event fd: 8 got channel, peer: id:3606161473439268872, fd:8, addr:839624896, port:64268
I20230918 18:57:44.323078 6886 msg_buf.cpp:117] got EOF while call next
I20230918 18:57:44.323177 6886 arranger.cpp:74] Arranger on_msg fired: id:3606161473439268872, fd:8, addr:839624896, port:64268
I20230918 18:57:44.323223 6886 arranger.cpp:81] Handshake request from peer: id:3606161473439268872, fd:8, addr:839624896, port:64268, msg: log_type:0, id:172.30.80.1_14060_1695034622, ip:172.30.80.1, version:1.0.7, configuration:tb_white_list=sys.*.* cluster_user=root tb_black_list=| timezone=+8:00 working_mode=storage rootserver_list=192.168.11.37:2882:2881 first_start_timestamp=0 cluster_password=61793AB22A9FC656E894A4E12CD444426BC85AF7 , enable_monitor:0,
I20230918 18:57:44.323469 6886 arranger.cpp:93] ObConfig from peer: id:3606161473439268872, fd:8, addr:839624896, port:64268 after resolve: cluster_id:,cluster_password:29RsDKq828l5Es0woBKl,cluster_url:,cluster_user:root,first_start_timestamp:0,first_start_timestamp_us:0,id:,rootserver_list:192.168.11.37:2882:2881,sys_password:,sys_user:,tb_white_list:sys.*.*,
I20230918 18:57:44.323556 6886 ob_access.cpp:181] About to auth sys: root for observer: 192.168.11.37:2881
I20230918 18:57:44.323737 6886 io.cpp:119] Connect to server success after poll. host=192.168.11.37,port=2881
I20230918 18:57:44.323766 6886 mysql_protocol.cpp:51] Connect to server success: 192.168.11.37:2881, user: root
I20230918 18:57:44.324831 6886 mysql_protocol.cpp:82] Receive handshake packet from server: 192.168.11.37:2881, user: root
I20230918 18:57:44.324888 6886 ob_mysql_packet.cpp:256] Observer version: 5.7.25
I20230918 18:57:44.324908 6886 ob_mysql_packet.cpp:264] Connection id: 3221487779
I20230918 18:57:44.324940 6886 ob_mysql_packet.cpp:355] Auth plugin name: mysql_native_password
I20230918 18:57:44.324983 6886 ob_mysql_packet.cpp:589] Handshake response packet len: 80
I20230918 18:57:44.326602 6886 mysql_protocol.cpp:122] Auth user success of server: 192.168.11.37:2881, user: root
I20230918 18:57:44.326654 6886 mysql_protocol.cpp:214] Query obmysql SQL:show tenant
I20230918 18:57:44.371613 6886 io.cpp:119] Connect to server success after poll. host=192.168.11.37,port=2881
I20230918 18:57:44.371682 6886 mysql_protocol.cpp:51] Connect to server success: 192.168.11.37:2881, user: root
I20230918 18:57:44.371989 6886 mysql_protocol.cpp:82] Receive handshake packet from server: 192.168.11.37:2881, user: root
I20230918 18:57:44.372078 6886 ob_mysql_packet.cpp:256] Observer version: 5.7.25
I20230918 18:57:44.372110 6886 ob_mysql_packet.cpp:264] Connection id: 3221487780
I20230918 18:57:44.372164 6886 ob_mysql_packet.cpp:355] Auth plugin name: mysql_native_password
I20230918 18:57:44.372234 6886 ob_mysql_packet.cpp:589] Handshake response packet len: 80
I20230918 18:57:44.376446 6886 mysql_protocol.cpp:122] Auth user success of server: 192.168.11.37:2881, user: root
I20230918 18:57:44.376504 6886 mysql_protocol.cpp:214] Query obmysql SQL:SELECT svr_min_log_timestamp FROM oceanbase.__all_virtual_server_clog_stat WHERE zone_status='ACTIVE';
I20230918 18:57:44.417495 6886 ob_mysql_packet.cpp:220] Error packet: [31487][#42S02] Table 'oceanbase.__all_virtual_server_clog_stat' doesn't exist
E20230918 18:57:44.417562 6886 mysql_protocol.cpp:239] Failed to query observer:Table 'oceanbase.__all_virtual_server_clog_stat' doesn't exist, unexpected column count: 0
E20230918 18:57:44.417667 6886 clog_meta_routine.cpp:45] Failed to check the existence of svr_min_log_timestamp column in __all_virtual_server_clog_stat, disable clog check
I20230918 18:57:44.417829 6886 arranger.cpp:223] Client connecting: type:0, id:172.30.80.1_14060_1695034622, ip:172.30.80.1, version:1.0.7, configuration:tb_white_list=sys.*.* cluster_user=root tb_black_list=| timezone=+8:00 working_mode=storage rootserver_list=192.168.11.37:2882:2881 first_start_timestamp=0 cluster_password=61793AB22A9FC656E894A4E12CD444426BC85AF7 , pid:0, peer:fd:8, register_time:1695034664, enable_monitor:0, packet_version:2,
I20230918 18:57:44.418687 6886 source_invoke.cpp:75] +++ Created oblogreader with pid: 8558
I20230918 18:57:44.418792 6886 comm.cpp:330] Try close Channel of peer: id:3606161473439268872, fd:8, addr:839624896, port:64268
I20230918 18:57:44.418920 6886 channel.h:46] Closed fd: 8
I20230918 18:57:44.418953 6886 arranger.cpp:241] Remove peer: id:3606161473439268872, fd:8, addr:839624896, port:64268 after source invoked, current channel count:0
I20230918 18:57:44.419078 6886 arranger.cpp:246] Client connected: 172.30.80.1_14060_1695034622 with peer: id:3606161473439268872, fd:8, addr:839624896, port:64268
【附件】