【 使用环境 】生产环境 (1-1-1)
【 OB or 其他组件 】odp-4.3.4.0-1、OceanBase 构建版本号:4.4.2.2-102000022026071514
【 使用版本 】odp-4.3.4.0-1
【问题描述】odp 偶发断联,报 -4016
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):
【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试,在发帖时输入 [@论坛小助手] 即可召唤小助手,欢迎试用!
obproxy_error 部分日志:
2026-10-14 13:20:02.743160,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,4999458us,0us,0us,0us,Y0-00007FD7FBF46500,,172.19.56.152:43648,,0,,Internal error,
2026-10-14 13:20:02.856589,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,4999343us,0us,0us,0us,Y0-00007FD800752360,,172.19.56.152:43662,,0,,Internal error,
2026-10-14 13:20:04.119140,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SHOW,failed,-4016,SHOW MASTER STATUS,4999556us,0us,0us,0us,Y0-00007FD7FBF468C0,,172.19.56.204:47592,,0,,Internal error,
2026-10-14 13:20:07.433602,ndproxy_ce_p,,,,CATL_CE_P_ND01:CAEV:caev,OB_MYSQL,td_instance_data,td_instance_data,OB_MYSQL_COM_QUERY,INSERT,failed,1146,INSERT INTO td_instance_data (ts%2C instance_id%2C BatteryShip_DistributionSysStatus%2C Inverter_OutputCurrent%2C Rudder_Code%2C Ship_Longitude%2C BatteryCluster_MinCellVoltagePackCode%2C BBC_SysIntStatus1%2C BBC_SysIntStatus2%2C BatteryCluster_MaxCellTemperaturePackCode%2C Compartment_AlarmFlag%2C BBC_H2Conc%2C DCAC_Current%2C Custom_OnceSailingTime%2C BatteryCluster_MaxCellVoltagePackCode%2C BatteryCluster_AvgCellTemperature%2C DCBus_Voltage%2C BatteryCluster_MinCellTemperaturePackCode%2C BBC_WCUReturnWPress%2C PTC_Code%2C DCBus_AlarmFlag%2C EMS_FaultWord12%2C EMS_FaultWord11%2C Charger_Voltage%2C EMS_FaultWord10%2C BatteryCluster_Code%2C Rudder_AlarmFlag%2C BatteryPack_CellTemperature%2C Custom_ShipStatus%2C BShipCS_MotorStatus%2C EMS_FaultWord9%2C BBC_BCompTempDtc%2C EMS_FaultWord7%2C EMS_FaultWord8%2C EMS_FaultWord5%2C BBC_BMSStatusCode%2C BBC_ACSideLVUab%2C DCDC_Code%2C EMS_FaultWord6%2C BBC_ACSideLVUac%2C EMS_FaultWord3%2C Compartment_MaxEnvTemperature%2C EMS_FaultWord4%2C EMS_FaultWord1%2C Ship_Latitu,2017us,0us,0us,1293us,Y0-00007FD83F780300,YB42AC122E37-00065E5378FB0924-0-0,172.19.52.74:64500,,0,172.18.46.55:2881,Table 'caev.td_instance_data' doesn't exist,YB42AC122E37-00065E5378FB0924-0-0
2026-10-14 13:20:08.491874,ndproxy_ce_p,,,,CATL_CE_P_ND01:CAEV:caev,OB_MYSQL,td_instance_data,td_instance_data,OB_MYSQL_COM_QUERY,INSERT,failed,1146,INSERT INTO td_instance_data (ts%2C instance_id%2C BatteryShip_DistributionSysStatus%2C Inverter_OutputCurrent%2C Rudder_Code%2C Ship_Longitude%2C BatteryCluster_MinCellVoltagePackCode%2C BBC_SysIntStatus1%2C BBC_SysIntStatus2%2C BatteryCluster_MaxCellTemperaturePackCode%2C Compartment_AlarmFlag%2C BBC_H2Conc%2C DCAC_Current%2C Custom_OnceSailingTime%2C BatteryCluster_MaxCellVoltagePackCode%2C BatteryCluster_AvgCellTemperature%2C DCBus_Voltage%2C BatteryCluster_MinCellTemperaturePackCode%2C BBC_WCUReturnWPress%2C PTC_Code%2C DCBus_AlarmFlag%2C EMS_FaultWord12%2C EMS_FaultWord11%2C Charger_Voltage%2C EMS_FaultWord10%2C BatteryCluster_Code%2C Rudder_AlarmFlag%2C BatteryPack_CellTemperature%2C Custom_ShipStatus%2C BShipCS_MotorStatus%2C EMS_FaultWord9%2C BBC_BCompTempDtc%2C EMS_FaultWord7%2C EMS_FaultWord8%2C EMS_FaultWord5%2C BBC_BMSStatusCode%2C BBC_ACSideLVUab%2C DCDC_Code%2C EMS_FaultWord6%2C BBC_ACSideLVUac%2C EMS_FaultWord3%2C Compartment_MaxEnvTemperature%2C EMS_FaultWord4%2C EMS_FaultWord1%2C Ship_Latitu,2028us,88us,0us,1422us,Y0-00007FD82E886620,YB42AC122E37-00065E5591C98B5F-0-0,172.19.52.74:3690,,0,172.18.46.55:2881,Table 'caev.td_instance_data' doesn't exist,YB42AC122E37-00065E5591C98B5F-0-0
2026-10-14 13:20:12.955378,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,5012635us,0us,0us,0us,Y0-00007FD800752320,,172.19.56.152:44938,,0,,Internal error,
2026-10-14 13:20:12.955814,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,5017117us,0us,0us,0us,Y0-00007FD7FBF46480,,172.19.56.152:44936,,0,,Internal error,
2026-10-14 13:20:16.243128,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,4999948us,0us,0us,0us,Y0-00007FD7FBF46440,,172.19.64.203:54230,,0,,Internal error,
obproxy_diagnosis 部分日志:
[2026-10-14 13:20:00.136852] [93957][Y0-00007FD8B5872640] [ROUTE]([ROUTE](*route_diagnosis=/nTrans First Query:"UPDATE ssot_cell_design_info SET last_update_date = '2026-10-14 13:15:00.411', last_updated_by = 491091, object_version_number = object_version_number + 1, crd_id = 22209614, cell_design_code = 'EPR-26-80YC', plm_cell_design_version = 21244762347, cell_design_name = 'EPR-26-80YC', group_code = 'A', cell_design_version = 10, cell_design_status = 'RELEASED', cell_design_scene = 'Package3.0', plm_folder_id = 14724707551, project_code = 'PS-DMG-A0C', project_stage_name = '售前', cell_product_programme_code = 'SF-CEL-JX2', ssot_update_time = '2026-10-14 11:33:22', ssot_time = '2026-10-14 11:33:22', crd_creation_date = '2026-10-14 10:46:06', crd_created_by = '60263612', crd_last_update_date = '2026-10-14 11:33:23', crd_last_updated_by = '60263612' WHERE id = 2134049 AND OBJECT_VERSION_NUMBER = 1"/nTrans Current Query:"INSERT INTO ssot_cell_design_parameter (creation_date, created_by, last_update_date, last_updated_by, object_version_number, crd_id, cell_design_id, table_line_id, attribute_code, attribute_value, ssot_update_time, ssot_time, crd_creation_date, crd_created_by, crd_last_update_date, crd_last_updated_by) VALUES ('2026-10-14 13:20:00.12', 491091, '2026-10-14 13:20:00.12', 491091, 1, 222096210557, 22209621, '', 'A496', '32.05', '2026-10-14 00:00:00', '2026-10-14 00:00:00', '2026-10-14 10:46:18', '60321488', '2026-10-14 00:00:00', '60321488'), ('2026-10-14 13:20:00.12', 491091, '2026-10-14 13:20:00.12', 491091, 1, 222096210558, 22209621, '', 'A498', '33.44', '2026-10-14 00:00:00', '2026-10-14 00:00:00', '2026-10-14 10:46:18', '60321488', '2026-10-14 00:00:00', '60321488'), ('2026-10-14 13:20:00.12', 491091, '2026-10-14 13:20:00.12', 491091, 1, 222096210559, 22209621, '', 'A500', '23.17', '2026-10-14 00:00:00', '2026-10-14 00:00:00', '2026-10-14 10:46:18', '60321488', '2026-10-14 00:00:00', '60321488'), ('2026-10-1"/n/nRoute Prompts/n> ROUTE_INFO/n [INFO] Will route to transaction coordinator(172.18.46.57:2881) because current query unable to be freely routed/n/n/nRoute Plan/n> SQL_PARSE:{cmd:"OB_MYSQL_COM_QUERY", table:"ssot_cell_design_parameter"}/n> ROUTE_INFO:{route_info_type:"USE_COODINATOR_SESSION", svr_addr:"172.18.46.57:2881", in_transaction:true}/n> HANDLE_RESPONSE:{is_parititon_hit:"false", send_action:"SERVER_SEND_REQUEST", state:"CMD_COMPLETE"}/n)
[2026-10-14 13:20:00.138074] [93958][Y0-00007FD7FBF46480] [LOGIN](hsr={cluster_name:"", tenant_name:"", user_name:"", cluster_id:0, user_tenant_name:"", full_name:"", response:{capability_.capability:0, max_packet_size:0, character_set:0, username:"", database:"", auth_plugin_name:"", connect_attrs:[]}, is_clustername_from_default:false, has_tenant_username:false, has_cluster_username:false}, addr="172.18.46.78:15222", login_result="success")
[2026-10-14 13:20:02.221428] [93958][Y0-00007FD7FBF46480] [LOGIN](hsr={cluster_name:"", tenant_name:"", user_name:"", cluster_id:0, user_tenant_name:"", full_name:"", response:{capability_.capability:0, max_packet_size:0, character_set:0, username:"", database:"", auth_plugin_name:"", connect_attrs:[]}, is_clustername_from_default:false, has_tenant_username:false, has_cluster_username:false}, addr="172.18.46.79:21776", login_result="success")
[2026-10-14 13:20:02.743643] [93940][Y0-00007FD7FBF46500] [CONNECTION](trace_type="PROXY_INTERNAL_TRACE", connection_diagnosis={cs_id:19981248, ss_id:0, proxy_session_id:12399023538051481506, server_session_id:0, client_addr:"172.19.56.152:43648", server_addr:"*Not IP address [0]*:0", proxy_server_addr:"*Not IP address [0]*:0", cluster_name:"CATL_CE_P_ND01", tenant_name:"CFMS_BMP", user_name:"a_dataops_etl", error_code:0, error_msg:"", request_cmd:"OB_MYSQL_COM_QUERY", sql_cmd:"OB_MYSQL_COM_QUERY", req_total_time(us):0}{user_sql:"select @@server_id"})
[2026-10-14 13:20:02.856983] [93953][Y0-00007FD800752360] [CONNECTION](trace_type="PROXY_INTERNAL_TRACE", connection_diagnosis={cs_id:19993644, ss_id:0, proxy_session_id:12399023538051481508, server_session_id:0, client_addr:"172.19.56.152:43662", server_addr:"*Not IP address [0]*:0", proxy_server_addr:"*Not IP address [0]*:0", cluster_name:"CATL_CE_P_ND01", tenant_name:"CFMS_BMP", user_name:"a_dataops_etl", error_code:0, error_msg:"", request_cmd:"OB_MYSQL_COM_QUERY", sql_cmd:"OB_MYSQL_COM_QUERY", req_total_time(us):21}{user_sql:"select @@server_id"})
[2026-10-14 13:20:03.138396] [93940][Y0-00007FD972D399C0] [LOGIN](hsr={cluster_name:"", tenant_name:"", user_name:"", cluster_id:0, user_tenant_name:"", full_name:"", response:{capability_.capability:0, max_packet_size:0, character_set:0, username:"", database:"", auth_plugin_name:"", connect_attrs:[]}, is_clustername_from_default:false, has_tenant_username:false, has_cluster_username:false}, addr="172.18.46.78:15234", login_result="success")
obproxy_stat部分日志:
2026-10-14 13:20:59.499537,ndproxy_ce_p,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,SELECT,failed,-4016,25,0,0,25,125051768us,0us,0us
2026-10-14 13:20:59.499550,ndproxy_ce_p,,CATL_CE_P_ND01:LUBAN:sfw,OB_MYSQL,UPDATE,success,,12,1,0,0,145011us,262us,144488us
2026-10-14 13:20:59.499570,ndproxy_ce_p,,CATL_CE_P_ND01:COS:cwp,OB_MYSQL,INSERT,success,,26,0,0,0,66576us,4963us,48911us
2026-10-14 13:20:59.499583,ndproxy_ce_p,,CATL_CE_P_ND01:QIS:qis_5m1e,OB_MYSQL,SELECT,success,,1116,1,0,10,20707674us,25252us,20596200us
2026-10-14 13:20:59.499593,ndproxy_ce_p,,CATL_CE_P_ND01:NPMS:npms,OB_MYSQL,OTHERS,success,,1,0,0,0,8us,0us,0us
2026-10-14 13:20:59.499598,ndproxy_ce_p,,CATL_CE_P_ND01:NPMS:npms,OB_MYSQL,SELECT,success,,4,0,0,0,3938us,2620us,554us
2026-10-14 13:20:59.499608,ndproxy_ce_p,,CATL_CE_P_ND01:MWR_PN:hap,OB_MYSQL,COMMIT,success,,33,0,0,0,11280us,607us,9617us
2026-10-14 13:20:59.499614,ndproxy_ce_p,,CATL_CE_P_ND01:QIS:qis_5m1e,OB_MYSQL,OTHERS,success,,202,0,0,0,1784us,0us,0us
2026-10-14 13:20:59.499623,ndproxy_ce_p,,CATL_CE_P_ND01:CAEV:caev,OB_MYSQL,SELECT,success,,448,0,0,0,1392943us,21692us,1337088us
2026-10-14 13:20:59.499635,ndproxy_ce_p,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,SHOW,failed,-4016,4,0,0,4,20025490us,0us,0us
2026-10-14 13:20:59.499647,ndproxy_ce_p,,CATL_CE_P_ND01:LUBAN:pmo,OB_MYSQL,SELECT,success,,605,573,0,0,25925031us,42729us,25838037us
2026-10-14 13:20:59.499662,ndproxy_ce_p,,CATL_CE_P_ND01:NPMS:npms,OB_MYSQL,SET,success,,2,0,0,0,558us,30us,445us
2026-10-14 13:20:59.499671,ndproxy_ce_p,,CATL_CE_P_ND01:CAEV:caev,OB_MYSQL,INSERT,failed,1146,7,0,0,0,14415us,313us,9779us
obproxy_digest部分日志:
2026-10-14 13:20:00.550388,ndproxy_ce_p,,,,CATL_CE_P_ND01:DEP:bip,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,success,,select 1,480330us,73us,0us,480162us,Y0-00007FD80C6031D0,,10.58.5.34:46372,,0,172.18.46.57:2881
2026-10-14 13:20:01.143581,ndproxy_ce_p,,,,CATL_CE_P_ND01:COS:cwp,OB_MYSQL,cwp_project_inventory,cwp_project_inventory,OB_MYSQL_COM_QUERY,SELECT,success,,SELECT count(0) FROM (SELECT cpi.project_id%2C cpi.project_code%2C cpi.project_name%2C cpi.project_type%2C cpi.cos_project_type%2C cpi.pms_project_id%2C cpi.pms_programme_id%2C (CASE cpi.cos_project_type WHEN 0 THEN '待维护项目' WHEN 1 THEN '客户项目' WHEN 2 THEN '电芯项目' WHEN 3 THEN '产品平台' WHEN 4 THEN '技术平台' WHEN 5 THEN '其他类型' ELSE '未识别错误的项目类型' END) AS cos_project_type_name%2C cpi.creation_date%2C cpi.last_update_date%2C sppp.plan_id pdp_plan_id%2C sppp.plan_name pdp_plan_name%2C cpi.output_time%2C cpi.discharge_override%2C sdlp.program_name programmeName%2C sdlp.plm_programme_code%2C sdlp.new_cell%2C CASE WHEN sdlp.status = 'COMPLETE' THEN '已完成' WHEN sdlp.status = 'EFFECT' THEN '在运行' WHEN sdlp.status = 'INVALID' THEN '无效方案' WHEN sdlp.status = 'UN_BIND' THEN '未绑定PDP计划' ELSE '方案状态无效' END status%2C (CASE sdlp.product_type WHEN 1 THEN 'Cell' WHEN 2 THEN 'Module' WHEN 3 THEN 'Pack' WHEN 4 THEN '系统' WHEN 5 THE,445983us,111us,0us,445760us,Y0-00007FD85F0D4160,,172.19.128.165:22692,,0,172.18.46.57:2881
2026-10-14 13:20:01.752639,ndproxy_ce_p,,,,CATL_CE_P_ND01:DEP:bip,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,success,,select 1,201737us,742us,0us,200995us,Y0-00007FD80C6031D0,,10.58.5.34:46372,,0,172.18.46.57:2881
2026-10-14 13:20:02.743152,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,4999458us,0us,0us,0us,Y0-00007FD7FBF46500,,172.19.56.152:43648,,0,
2026-10-14 13:20:02.856582,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SELECT,failed,-4016,select @@server_id,4999343us,0us,0us,0us,Y0-00007FD800752360,,172.19.56.152:43662,,0,
2026-10-14 13:20:03.706715,ndproxy_ce_p,,,,CATL_CE_P_ND01:COS:cwp,OB_MYSQL,cwp_project_inventory,cwp_project_inventory,OB_MYSQL_COM_QUERY,SELECT,success,,SELECT t.project_id%2C t.project_code%2C t.project_name%2C t.project_type%2C t.cos_project_type%2C t.pms_project_id%2C t.pms_programme_id%2C t.cos_project_type_name%2C t.creation_date%2C t.last_update_date%2C t.pdp_plan_id%2C t.pdp_plan_name%2C t.output_time%2C t.discharge_override%2C t.programmeName%2C t.plm_programme_code%2C t.current_stage%2C t.current_stage_name%2C t.lpdtMemberCode%2C t.lpdtMemberName%2C t.ceMemberCode%2C t.ceMemberName%2C t.projectApprovedTime%2C t.frCurrentStageCode%2C t.new_cell%2C t.status%2C t.product_type_name FROM (SELECT cpi.project_id%2C cpi.project_code%2C cpi.project_name%2C cpi.project_type%2C cpi.cos_project_type%2C cpi.pms_project_id%2C cpi.pms_programme_id%2C (CASE cpi.cos_project_type WHEN 0 THEN '待维护项目' WHEN 1 THEN '客户项目' WHEN 2 THEN '电芯项目' WHEN 3 THEN '产品平台' WHEN 4 THEN '技术平台' WHEN 5 THEN '其他类型' ELSE '未识别错误的项目类型' END) AS cos_project_type_name%2C cpi.creation_date%2C cpi.last_update_date%2C sppp.plan_id,2542752us,372us,0us,2535177us,Y0-00007FD85F0D4160,YB42AC122E39-00065E3B509B8226-0-0,172.19.128.165:22692,,0,172.18.46.57:2881
2026-10-14 13:20:04.119133,ndproxy_ce_p,,,,CATL_CE_P_ND01:CFMS_BMP:,OB_MYSQL,,,OB_MYSQL_COM_QUERY,SHOW,failed,-4016,SHOW MASTER STATUS,4999556us,0us,0us,0us,Y0-00007FD7FBF468C0,,172.19.56.204:47592,,0,