【 使用环境 】生产环境
【使用版本】:Obproxy-3.2.3 ,OMS 4.10_CE
【 OB or 其他组件 】OMS转移数据,每天会报一个错误,且报错会导致数据转移中断。如图,昨天6点报错查询失败:
查了下对应的源库proxy抽取数据的日志,该行SQL没有发给OBSERVER,在proxy内部返回了-4016的错误,具体函数如下:
686677:[2023-12-21 06:43:09.690488] WARN [PROXY.API] consume (ob_mysql_response_compress_transform_plugin.cpp:143) [85688][Y0-2B2AFB0036E0] [lt=13] [dc=0] fail to produce(expected size=0, actual size=2, ret=-4016)
686678:[2023-12-21 06:43:09.690528] WARN [PROXY.API] handle_transform_read (ob_transformation_plugin.cpp:233) [85688][Y0-2B2AFB0036E0] [lt=38] [dc=0] fail to consume(to_read=20, ret=-4016)
686679:[2023-12-21 06:43:09.690997] WARN [PROXY] get_str_field_value (ob_session_field_mgr.cpp:1773) [85688][Y0-2B2AFB0036E0] [lt=28] [dc=0] not inited(ret=-4006)
686680:[2023-12-21 06:43:09.691024] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:615) [85688][Y0-2B2AFB0036E0] [lt=27] [dc=0] not inited(ret=-4006)
686681:[2023-12-21 06:43:09.691050] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:627) [85688][Y0-2B2AFB0036E0] [lt=26] [dc=0] not inited(ret=-4006)
686682:[2023-12-21 06:43:09.691076] WARN [PROXY] get_str_field_value (ob_session_field_mgr.cpp:1773) [85688][Y0-2B2AFB0036E0] [lt=26] [dc=0] not inited(ret=-4006)
686683:[2023-12-21 06:43:09.699983] WARN [PROXY] get_str_field_value (ob_session_field_mgr.cpp:1773) [85688][Y0-2B2AFB0036E0] [lt=26] [dc=0] not inited(ret=-4006)
686684:[2023-12-21 06:43:09.700014] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:615) [85688][Y0-2B2AFB0036E0] [lt=31] [dc=0] not inited(ret=-4006)
686685:[2023-12-21 06:43:09.700040] WARN [PROXY] get_tenant_name (ob_session_field_mgr.cpp:627) [85688][Y0-2B2AFB0036E0] [lt=26] [dc=0] not inited(ret=-4006)
686686:[2023-12-21 06:43:09.700066] WARN [PROXY] get_user_name (ob_session_field_mgr.cpp:651) [85688][Y0-2B2AFB0036E0] [lt=26] [dc=0] not inited(ret=-4006)
686689:[2023-12-21 06:43:10.777615] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:4683) [85688][Y0-2B2AFB0036E0] [lt=33] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=49717041)
686690:[2023-12-21 06:43:10.777652] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:6343) [85688][Y0-2B2AFB0036E0] [lt=36] [dc=0] client will abort soon(sm_id=49717041, cs_id=2236397, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:44784}, 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_HANDSHAKE)
问题出现了很多次,比较着急,请看看
net_time_writeout已经调整成600,不起作用