odpinsert报错

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 OB or 其他组件 】odp
【 使用版本 】
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
2025-10-17 14:54:49.472481,ceobproxy,CATL_CE_O_ND01:VCS:vcs,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,failed,1235,INSERT INTO t_appointment_record_detail ( visitor_reg_config_id%2C appointment_record_id%2C field_configuration_id%2C base_type%2C field_name%2C field_id%2C field_value%2C extension_field%2C created_by_code%2C created_by_name%2C last_updated_by_code%2C last_updated_by_name%2C delete_flag%2C object_version_number%2C creation_date%2C created_by%2C last_update_date%2C last_updated_by ) VALUES ( 3%2C 159308%2C 9%2C 1%2C ‘到访公司’%2C ‘visitedCompany’%2C ‘{“value”:“16”%2C"fieldName":“CAIT-SH”%2C"aliasValue":“上海智科”%2C"xingAnValue":“CAIT-SH”}’%2C '[{“id”:1739862420832%2C"isAdd":1%2C"fieldName":“CATY-ZH”%2C"value":“CETL-PN”%2C"valueName":“CETL-PN”%2C"aliasValue":“屏南电子”%2C"fieldIndex":“12”%2C"XingAnValue":“CETL-PN”}%2C{“id”:1742177172275%2C"value":“RQ-CATL”%2C"valueName":“RQ-CATL”%2C"aliasValue":“瑞庆时代”%2C"fieldIndex":“13”%2C"XingAnValue":“CATL-RQ”}%2C{“id”:1743508239230%2C"value":“CAIT-SH”%2C"valueName":"CAIT-SH,736us,74us,0us,523us,Y0-00007F683E021260,YB42AC122E3A-00062DCF54E05FF8-0-0,172.19.128.163:19936,0,172.18.46.58:2881,Not supported feature or function,YB42AC122E3A-00062DCF54E05FF8-0-0

2025-10-17 14:54:49.479306,ceobproxy,CATL_CE_O_ND01:VCS:vcs,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,failed,1317,INSERT INTO t_appointment_record_detail ( visitor_reg_config_id%2C appointment_record_id%2C field_configuration_id%2C base_type%2C field_name%2C field_id%2C field_value%2C extension_field%2C created_by_code%2C created_by_name%2C last_updated_by_code%2C last_updated_by_name%2C delete_flag%2C object_version_number%2C creation_date%2C created_by%2C last_update_date%2C last_updated_by ) VALUES ( 3%2C 159308%2C 9%2C 1%2C ‘到访公司’%2C ‘visitedCompany’%2C '{“value”:“16”%2C"fieldName":“CAIT-SH”%2C"aliasValue":“上海智科”%2C"xingAnValue"

2025-10-17 14:54:50.822974,ceobproxy,CATL_CE_O_ND01:VCS:vcs,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,failed,1235,INSERT INTO t_appointment_record_detail ( visitor_reg_config_id%2C appointment_record_id%2C field_configuration_id%2C base_type%2C field_name%2C field_id%2C field_value%2C extension_field%2C created_by_code%2C created_by_name%2C last_updated_by_code%2C last_updated_by_name%2C delete_flag%2C object_version_number%2C creation_date%2C created_by%2C last_update_date%2C last_updated_by ) VALUES ( 3%2C 159309%2C 9%2C 1%2C ‘到访公司’%2C ‘visitedCompany’%2C ‘{“value”:“0”%2C"fieldName":“ND-CATL”%2C"aliasValue":“宁德时代”%2C"xingAnValue":“CATL-ND”}’%2C '[{“id”:1739862420832%2C"isAdd":1%2C"fieldName":“CATY-ZH”%2C"value":“CETL-PN”%2C"valueName":“CETL-PN”%2C"aliasValue":“屏南电子”%2C"fieldIndex":“12”%2C"XingAnValue":“CETL-PN”}%2C{“id”:1742177172275%2C"value":“RQ-CATL”%2C"valueName":“RQ-CATL”%2C"aliasValue":“瑞庆时代”%2C"fieldIndex":“13”%2C"XingAnValue":“CATL-RQ”}%2C{“id”:1743508239230%2C"value":“CAIT-SH”%2C"valueName":"CAIT-SH,998us,57us,0us,796us,Y0-00007F67C8214B70,YB42AC122E3A-00062DCEE19A9607-0-0,172.19.128.163:56206,0,172.18.46.58:2881,Not supported feature or function,YB42AC122E3A-00062DCEE19A9607-0-0

2025-10-17 14:54:50.828230,ceobproxy,CATL_CE_O_ND01:VCS:vcs,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,failed,1317,INSERT INTO t_appointment_record_detail ( visitor_reg_config_id%2C appointment_record_id%2C field_configuration_id%2C base_type%2C field_name%2C field_id%2C field_value%2C extension_field%2C created_by_code%2C created_by_name%2C last_updated_by_code%2C last_updated_by_name%2C delete_flag%2C object_version_number%2C creation_date%2C created_by%2C last_update_date%2C last_updated_by ) VALUES ( 3%2C 159309%2C 9%2C 1%2C ‘到访公司’%2C ‘visitedCompany’%2C '{“value”:“0”%2C"fieldName":“ND-CATL”%2C"aliasValue":“宁德时代”%2C"xingAnValue":

2025-10-17 14:54:53.454675,ceobproxy,CATL_CE_O_ND01:VCS:vcs,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,failed,1235,INSERT INTO t_appointment_record_detail ( visitor_reg_config_id%2C appointment_record_id%2C field_configuration_id%2C base_type%2C field_name%2C field_id%2C field_value%2C extension_field%2C created_by_code%2C created_by_name%2C last_updated_by_code%2C last_updated_by_name%2C delete_flag%2C object_version_number%2C creation_date%2C created_by%2C last_update_date%2C last_updated_by ) VALUES ( 3%2C 159310%2C 9%2C 1%2C ‘到访公司’%2C ‘visitedCompany’%2C ‘{“value”:“0”%2C"fieldName":“ND-CATL”%2C"aliasValue":“宁德时代”%2C"xingAnValue":“CATL-ND”}’%2C '[{“id”:1739862420832%2C"isAdd":1%2C"fieldName":“CATY-ZH”%2C"value":“CETL-PN”%2C"valueName":“CETL-PN”%2C"aliasValue":“屏南电子”%2C"fieldIndex":“12”%2C"XingAnValue":“CETL-PN”}%2C{“id”:1742177172275%2C"value":“RQ-CATL”%2C"valueName":“RQ-CATL”%2C"aliasValue":“瑞庆时代”%2C"fieldIndex":“13”%2C"XingAnValue":“CATL-RQ”}%2C{“id”:1743508239230%2C"value":“CAIT-SH”%2C"valueName":"CAIT-SH,734us,42us,0us,548us,Y0-00007F680858F9B0,YB42AC122E3A-00062DCECC5C6995-0-0,172.19.128.163:24857,0,172.18.46.58:2881,Not supported feature or function,YB42AC122E3A-00062DCECC5C6995-0-0

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

#3

针对您提到的在生产环境中使用 ODP 进行 INSERT 操作时遇到的错误，错误码分别为 1235 和 1317 的问题，我们可以首先使用 obdiag 工具进行日志采集，以便进一步诊断问题的原因。根据您提供的错误码，1235 通常与 SQL 语句语法有关，而 1317 则可能与事务处理中的超时或锁定冲突相关。

推荐使用的 obdiag 命令

日志采集场景

日志采集场景: SQL 执行出错
日志采集命令:

obdiag gather scene run --scene=observer.sql_err --env "{db_connect='-h<主机IP> -P<端口> -u<用户名>@<租户名> -p<密码> -D<数据库名>', trace_id='<trace_id>'}"

请将上述命令中的 <主机IP>、<端口>、<用户名>、<租户名>、<密码> 和 <数据库名> 替换为实际的连接信息，并提供一个具体的 trace_id 以便于定位具体的 SQL 语句。

需要您提供的信息

为了更准确地诊断问题，请您提供以下信息：

  1. 具体的 SQL 语句：您尝试执行的 INSERT 语句是什么？
  2. 错误详细信息：完整的错误消息，包括任何附加的错误描述。
  3. 环境信息：您当前的 OceanBase 版本号，以及 ODP 的版本号。
  4. 事务上下文：您是否在一个事务中执行多个操作？如果是，请提供事务的结构。
  5. 表结构：涉及的表的结构定义，包括索引和约束。
  6. 并发情况：是否有其他并发操作或事务在同一时间对相同的数据进行操作？

请您按照上述命令进行日志采集，并将生成的日志文件提供给我们，我们将进一步分析问题的原因并给出解决方案。感谢您的配合！

附上敏捷诊断工具 obdiag 使用帮助链接

#4

alter proxyconfig set enable_ob_protocol_v2_with_client=true;参数导致的问题，后期的话会修复该问题