全文检索Size overflow

[猎马人Jay]

为什么我的表只有4条数据，检索问题也只有几个字也会报这个错

The error may exist in org/example/rag_demo/mapper/MCPToolsMapper.xml\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: SELECT id, MATCH (name) AGAINST (? IN NATURAL LANGUAGE MODE) AS nameScore, MATCH (description) AGAINST (? IN NATURAL LANGUAGE MODE) AS descriptionScore FROM tool_registry;\r\n### Cause: java.sql.SQLException: Size overflow\n; uncategorized SQLException; SQL state [HY000]; error code [4019]; Size overflow"

ob版本号4.3.5，Mysql事务型

sql语句
SELECT id,
MATCH (name) AGAINST (#{question} IN NATURAL LANGUAGE MODE) AS nameScore,
MATCH (description) AGAINST (#{question} IN NATURAL LANGUAGE MODE) AS descriptionScore
FROM tool_registry;

[和顺]

@猎马人Jay 麻烦提供一下：

1、show variables like ‘version_comment’;
2、show create table xxx \G
3、模拟业务sql查询报 4019
4、在当前报错的session里查 select last_trace_id();
5、使用第4步获取的trace_id替换后查 select decode_trace_id(‘xxx’);
6、在第5步对应的机器上根据 trace_id 过滤后提供对应的日志,具体待过滤的日志附件根据实际情况
grep “trace_id_xxxx” observer.log
7、 方便的话，帮忙把4条测试数据脱敏后提供一下。

[淇铭]

如果你使用的不是社区版 建议走企业工单或者咨询企业客户经理