[Question]: 添加文档报错

[macaulishxcoo]

描述你的问题

大佬，我上传了pdf文件，新建了知识库，在知识库查看（知识库详情）添加文档选中上传的文件显示：
添加文档失败: Request failed with status code 500，这个要怎么解决啊？
希望得到回复，谢谢！！！

[dosubot]

Hi @macaulishxcoo! I'm Dosu and I’m helping the ragflow-plus team.

这个 500 错误通常有以下几种常见原因：

1. 文件未正确上传或未入库：PDF 文件必须通过 Ragflow-Plus 后台的文件管理界面上传，确保文件在 file 表有记录。如果是通过其他方式上传，或者 parent_id 不一致，后台可能找不到文件，导致报错。相关讨论

2. MinIO 存储桶配置问题：后台解析文档时会访问 MinIO 存储桶。如果桶名或 parent_id 配置不对，或者 MinIO 服务未启动，会出现“存储桶不存在”或“文件找不到”的错误。相关讨论

3. Embedding 服务未启动或配置错误：文档解析依赖 embedding 服务（如 Ollama）。如果 embedding 地址填的是 localhost，容器无法访问主机服务，或者模型未拉取（如 bge-m3），会导致解析失败。相关讨论

4. 数据库字段或 SQL 错误：有过因 SQL 字段拼写错误（如 process_duation 拼成 process_duration）导致 500 错误的案例。相关讨论

排查建议：

• 确认 PDF 文件是通过后台文件管理上传，并在 file 表有记录，parent_id 与知识库 id 一致。
• 检查 MinIO 服务是否正常，桶名和配置是否正确。
• 检查 embedding 服务（如 Ollama）是否启动，地址建议用 http://host.docker.internal:11434，并确保模型已拉取（ollama pull bge-m3:latest）。
• 查看后台日志，定位 500 错误的详细堆栈信息，尤其关注“文件不存在”、“存储桶不存在”、“embedding 连接失败”或 SQL 错误。
• 可以尝试上传一个小的 PDF 文件测试，排除文件本身问题。

如果还有问题，可以补充后台报错日志（堆栈信息），这样能更快定位具体原因。

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

[macaulishxcoo]

2025-12-11 07:13:20,942 - INFO - werkzeug - Press CTRL+C to quit

2025-12-11 07:14:14,212 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:14] "GET /api/v1/users/me HTTP/1.0" 200 -

2025-12-11 07:14:14,425 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:14] "GET /api/v1/users?currentPage=1&size=10&username=&email=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:29,579 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:29] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:29,598 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:29] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:29,617 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:29] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:34,062 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:34] "DELETE /api/v1/files/994659ead65911f0a3e37ecabf2949dd HTTP/1.0" 200 -

2025-12-11 07:14:34,087 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:34] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:43,201 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:43] "POST /api/v1/files/upload HTTP/1.0" 200 -

2025-12-11 07:14:43,225 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:43] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:49,345 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:49] "GET /api/v1/knowledgebases?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:49,365 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:49] "GET /api/v1/knowledgebases?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:49,384 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:49] "GET /api/v1/knowledgebases?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:50,827 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:50] "GET /api/v1/knowledgebases/0430774b0cca44e1ac4a2745e27aeb66/documents?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

2025-12-11 07:14:52,333 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:52] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

Traceback (most recent call last):

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 755, in cmd_query

self._cmysql.query(

_mysql_connector.MySQLInterfaceError: Unknown column 'process_duation' in 'field list'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/app/services/knowledgebases/service.py", line 676, in add_documents_to_knowledgebase

cursor.execute(doc_query, doc_params)

File "/usr/local/lib/python3.10/site-packages/mysql/connector/cursor_cext.py", line 351, in execute

self._connection.cmd_query(

File "/usr/local/lib/python3.10/site-packages/mysql/connector/opentelemetry/context_propagation.py", line 97, in wrapper

return method(cnx, *args, **kwargs)

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 763, in cmd_query

raise get_mysql_exception(

mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'process_duation' in 'field list'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/app/routes/knowledgebases/routes.py", line 129, in add_documents_to_knowledgebase

result = KnowledgebaseService.add_documents_to_knowledgebase(kb_id=kb_id, file_ids=file_ids)

File "/app/services/knowledgebases/service.py", line 721, in add_documents_to_knowledgebase

raise Exception(f"添加文档到知识库失败: {str(e)}")

Exception: 添加文档到知识库失败: 1054 (42S22): Unknown column 'process_duation' in 'field list'

2025-12-11 07:14:54,931 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 07:14:54] "POST /api/v1/knowledgebases/0430774b0cca44e1ac4a2745e27aeb66/documents HTTP/1.0" 500 -

我修改了E:\workspaces\ragflow-plus-main\management\server\services\knowledgebases\service.py的process_duation字段，但还是报 添加文档到知识库失败 错误.
我排查了，文件是按照要求上传的，且文件管理文档存在；
MinIO 服务应该是启动了，没有报其他错误；
模型bgm-m3正常拉取，配置正常。

[zstar1003]

这是ragflow早期版本引入的一处拼写错误。

解决方案：

方案一：

1. 修改数据库模型 - 在 api/db/db_models.py 中：

   # 将这行
   process_duation = FloatField(default=0)
   # 改为
   process_duration = FloatField(default=0)

2. 修改管理服务代码 - 在 management/server/services/knowledgebases/service.py 中：

   -- 将 process_duation 改为 process_duration
   INSERT INTO document (
       ...
       process_begin_at,
       process_duration,  -- 修正拼写
       meta_fields, run, status
   ) VALUES (...)

方案二：直接修改mysql表里的字段，将process_duration改成process_duation

[macaulishxcoo]

好的，这个问题应该是解决了，但是还是报Request failed with status code 500，但是不同的错误
raceback (most recent call last):

File "/app/routes/knowledgebases/routes.py", line 129, in add_documents_to_knowledgebase

result = KnowledgebaseService.add_documents_to_knowledgebase(kb_id=kb_id, file_ids=file_ids)

File "/app/services/knowledgebases/service.py", line 721, in add_documents_to_knowledgebase

raise Exception(f"添加文档到知识库失败: {str(e)}")

Exception: 添加文档到知识库失败: 1364 (HY000): Field 'suffix' doesn't have a default value

2025-12-11 08:57:15,532 - INFO - werkzeug - 172.18.0.8 - - [11/Dec/2025 08:57:15] "POST /api/v1/knowledgebases/e13b9e22bb514c8ebce1fa2a14dfcf36/documents HTTP/1.0" 500 -

[zstar1003]

这个错误是因为数据库中的 document 表有一个 suffix 字段，但你的插入语句中没有提供这个字段的值，而且该字段在数据库层面没有设置默认值。

问题分析：

1. 数据库表结构与代码模型不匹配 - 数据库中有 suffix 字段，但 Document模型定义 中没有这个字段

2. SQL插入语句缺少字段 - 管理服务的插入语句 没有包含 suffix 字段

解决方案：

方法1：修改插入语句添加 suffix 字段

在 service.py 的 SQL 语句中添加 suffix 字段：

doc_query = """
    INSERT INTO document (
        id, create_time, create_date, update_time, update_date,
        thumbnail, kb_id, parser_id, parser_config, source_type,
        type, created_by, name, location, size,
        token_num, chunk_num, progress, progress_msg, process_begin_at,
        process_duation, meta_fields, run, status, suffix
    ) VALUES (
        %s, %s, %s, %s, %s,
        %s, %s, %s, %s, %s,
        %s, %s, %s, %s, %s,
        %s, %s, %s, %s, %s,
        %s, %s, %s, %s, %s
    )
"""

并在参数列表中添加 suffix 值：

doc_params = [
    doc_id,
    create_time,
    current_date,
    create_time,
    current_date,
    None,
    kb_id,
    default_parser_id,
    default_parser_config,
    default_source_type,
    file_type,
    created_by,
    file_name,
    file_location,
    file_size,
    0,
    0,
    0.0,
    None,
    None,
    0.0,
    None,
    "0",
    "1",
    file_type.split('.')[-1] if '.' in file_type else ''  # 添加 suffix
]

方法2：直接修改数据库字段（推荐）

为数据库中的 suffix 字段设置默认值：

ALTER TABLE document MODIFY COLUMN suffix VARCHAR(50) DEFAULT '';

或者如果不需要这个字段，可以删除它：

ALTER TABLE document DROP COLUMN suffix;

供参考：https://zread.ai/zstar1003/ragflow-plus

[macaulishxcoo]

好的，非常感谢，问题都解决了

[clk-mr]

大佬我的还是报错

2025-12-23 11:31:23,598 - INFO - werkzeug - 172.18.0.2 - - [23/Dec/2025 11:31:23] "GET /api/v1/files?currentPage=1&size=10&name=&sort_by=create_date&sort_order=desc HTTP/1.0" 200 -

Traceback (most recent call last):

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 755, in cmd_query

self._cmysql.query(

_mysql_connector.MySQLInterfaceError: Unknown column 'process_duation' in 'field list'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/app/services/knowledgebases/service.py", line 676, in add_documents_to_knowledgebase

cursor.execute(doc_query, doc_params)

File "/usr/local/lib/python3.10/site-packages/mysql/connector/cursor_cext.py", line 351, in execute

self._connection.cmd_query(

File "/usr/local/lib/python3.10/site-packages/mysql/connector/opentelemetry/context_propagation.py", line 97, in wrapper

return method(cnx, *args, **kwargs)

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 763, in cmd_query

raise get_mysql_exception(

mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'process_duation' in 'field list'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/app/routes/knowledgebases/routes.py", line 129, in add_documents_to_knowledgebase

result = KnowledgebaseService.add_documents_to_knowledgebase(kb_id=kb_id, file_ids=file_ids)

File "/app/services/knowledgebases/service.py", line 721, in add_documents_to_knowledgebase

raise Exception(f"添加文档到知识库失败: {str(e)}")

Exception: 添加文档到知识库失败: 1054 (42S22): Unknown column 'process_duation' in 'field list'

2025-12-23 11:31:26,665 - INFO - werkzeug - 172.18.0.2 - - [23/Dec/2025 11:31:26] "POST /api/v1/knowledgebases/431d76e9815d475fac30ab7b46788d0a/documents HTTP/1.0" 500 -