search

infiniflow / ragflow

RAGFlow is an open-source RAG (Retrieval-Augmented Generation) engine based on deep document understanding.
https://ragflow.io
Apache License 2.0
22.89k stars 2.24k forks source link

[Bug]: Error on retrieval and answer of chat #3127

Open Melodyrose954 opened 2 weeks ago

Melodyrose954 commented 2 weeks ago

Is there an existing issue for the same bug?

Branch name

main

Commit ID

v0.12.0

Other environment information

OS type: windows 11，Docker version 26.1.1, build 4cf5afa

Actual behavior

智能助手检索及回答环节出现错误

在和这个智能助理对话的时候，返回的答案是没有实际内容的空表格，然后引用的还是没有挂载的一个知识库，并且挂载的知识库和引用的知识库都不是table解析，通过api调用同样出现

BUG截图

3d0f74f10d3b5867e39018cec1126bc

发生BUG时的显存占用状态

7cbdb8917152f91fdffb227b9d4f1c9

聊天助手配置

9555be4a72d31d9a7c01ca8c0eeb0aa a4cb952a648b0d2e2b31f4bd3e3c77a 5830d2be916ed8fc626aa1433adc9a6

聊天助手挂载的知识库设置及解析块内容

d7f28a57bd6efb5f506ba7f4e629a7a 400dc32e7cc8275efbac49a45a4aaba 2750390c4b5d52ac98f6fa4fa59a0a9 c7dcd12b69d2d3c9a8aaa034fa6e244 d72d06d00e72ea2d015ff2263a8d8b3

聊天助手引用未挂载的知识库设置及解析情况

0c621cd4bf7da40943bb2ee72f29228 3b6ca1968881ae8250f6b6ea17c7657 fba5460c559029dc68223adfd99c28a

BUG复现截图

微信图片_20241031150702

docker 各容器版本

image

Expected behavior

No response

Steps to reproduce

首先会随机出现，出现后重启docker后第一次会话后消失，连续对话二至三轮或再开启新会话后出现

Additional information

复现bug时的ragflow-server 容器日志 2024-10-31 14:35:13 “有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑” get SQL(refined): select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where nai_huo_deng_ji_tks in ('多层建筑', '高层建筑') 2024-10-31 14:35:13 2024-10-31 14:35:13 表名：ragflow_16c496c43a8a11efbc850242ac140006； 2024-10-31 14:35:13 数据库表字段说明如下： 2024-10-31 14:35:13 gou_jian_ming_cheng_tks: 构件名称 2024-10-31 14:35:13 nai_huo_deng_ji_tks: 耐火等级 2024-10-31 14:35:13 2024-10-31 14:35:13 问题如下： 2024-10-31 14:35:13 有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑 2024-10-31 14:35:13 2024-10-31 14:35:13 你上一次给出的错误SQL如下： 2024-10-31 14:35:13 select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where nai_huo_deng_ji_tks in ('多层建筑', '高层建筑') 2024-10-31 14:35:13 2024-10-31 14:35:13 后台报错如下： 2024-10-31 14:35:13 BadRequestError(400, 'verification_exception', 'Found 1 problem\nline 1:123: [IN] cannot operate on field of data type [text]: No keyword/multi-field defined exact matches for [nai_huo_deng_ji_tks]; define one or use MATCH/QUERY instead') 2024-10-31 14:35:13 2024-10-31 14:35:13 请纠正SQL中的错误再写一遍，且只要SQL，不要有其他说明及文字。 2024-10-31 14:35:13 sql 2024-10-31 14:35:13 select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where MATCH(nai_huo_deng_ji_tks) AGAINST('多层建筑 高层建筑') 2024-10-31 14:35:13 2024-10-31 14:35:13 “有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑” get SQL(refined): select doc_id,docnm_kwd, doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where match(nai_huo_deng_ji_tks) against('多层建筑 高层建筑') 2024-10-31 14:35:13 {'error': 'BadRequestError(400, \'parsing_exception\', "line 1:166: mismatched input \')\' expecting \',\'")'} 2024-10-31 14:35:13 2024-10-31 14:35:13 表名：ragflow_16c496c43a8a11efbc850242ac140006； 2024-10-31 14:35:13 数据库表字段说明如下： 2024-10-31 14:35:13 gou_jian_ming_cheng_tks: 构件名称 2024-10-31 14:35:13 nai_huo_deng_ji_tks: 耐火等级 2024-10-31 14:35:13 2024-10-31 14:35:13 问题如下： 2024-10-31 14:35:13 这个条款的具体内容是什么 2024-10-31 14:35:13 请写出SQL, 且只要SQL，不要有其他说明及文字。 2024-10-31 14:35:13 sql 2024-10-31 14:35:13 SELECT gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks 2024-10-31 14:35:13 FROM ragflow_16c496c43a8a11efbc850242ac140006; 2024-10-31 14:35:13 2024-10-31 14:35:13 “这个条款的具体内容是什么” get SQL(refined): select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 2024-10-31 14:37:11 {'columns': [{'name': 'doc_id', 'type': 'keyword'}, {'name': 'docnm_kwd', 'type': 'keyword'}, {'name': 'gou_jian_ming_cheng_tks', 'type': 'text'}, {'name': 'nai_huo_deng_ji_tks', 'type': 'text'}], 'rows': [['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50b8cb4c3f5411efae440242ac140006', 'JGJ 57-2016 剧场建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['511154383f5411efae440242ac140006', 'JGJ_T 235-2011 建筑外墙防水工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50aff54e3f5411efae440242ac140006', 'JGJ 48-2014 商店建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50f4a2fc3f5411efae440242ac140006', 'JGJ 155-2013 种植屋面工程技术规程.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['50ff504e3f5411efae440242ac140006', 'JGJ 475-2019 温和地区居住建筑节能设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None], ['5108c8f43f5411efae440242ac140006', 'JGJ_T 67-2019 办公建筑设计标准.pdf', None, None], ['50a77cde3f5411efae440242ac140006', 'JGJ 38-2015 图书馆建筑设计规范.pdf', None, None]], 'cursor': 'gcSHBERGTACEUsuOmzAUxRS16my66KK/wWNG6q4iAyRlakcQA4M3CDBgHg5tQgbIqh/cf5iaTDujSq16Fr5H1+fYVzoXEAkwSQbSgkeBdxcmSd8BAFdlXXQ0OfaHQUlonz8+yRYA5ZUky6JerJ8Eky5ElOUVoLwW+qSmkvxWkD1P2lHwD1V/Spo63Se83ldJzgpxDu1Rkt/v0zphpz6hS6upn7rgh1zlu83K/Nzn3NkTPj1Q7eOEOFS3mDTIQmy7ticYhTzm8Bphc0aWy+KzrULLHBEjuFg7M1KHNtDQHWynU4bDEVtOmQbuylyRh6D1vdRyD7vQnjNc3fj61/t802kQE998xi1yhC7u0AnpLg/Xk+Vb+TmsNUScQEWb3LzbuIzo5JgZtBReMVurx2fvHGPGIHY6wt1mawUjbLw5juCExHzQiqPAYCxv6BfiILxrXJhxVcvtcbrXu1vPs6NMc+1gXc2p2vmQq9fbgH4LjdUNxbYeeC8TNowInYuzhtak84+e6hlQiwcc+SGyfMM07f/8ZZrS1e8lUED5K0Dwpi3msT9QkWz5kuUf7X/FCpShmIbF+Ld4n2/Fyv0EAAD//wMA'} 2024-10-31 14:37:11 2024-10-31 14:37:11 表名：ragflow_16c496c43a8a11efbc850242ac140006； 2024-10-31 14:37:11 数据库表字段说明如下： 2024-10-31 14:37:11 gou_jian_ming_cheng_tks: 构件名称 2024-10-31 14:37:11 nai_huo_deng_ji_tks: 耐火等级 2024-10-31 14:37:11 2024-10-31 14:37:11 问题如下： 2024-10-31 14:37:11 有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑 2024-10-31 14:37:11 请写出SQL, 且只要SQL，不要有其他说明及文字。 2024-10-31 14:37:11 sql 2024-10-31 14:37:11 SELECT gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks 2024-10-31 14:37:11 FROM ragflow_16c496c43a8a11efbc850242ac140006 2024-10-31 14:37:11 WHERE nai_huo_deng_ji_tks IN ('多层建筑', '高层建筑'); 2024-10-31 14:37:11 2024-10-31 14:37:11 2024-10-31 14:37:11 请注意，上述SQL语句假设nai_huo_deng_ji_tks字段中包含“多层建筑”或“高层建筑”的分类信息。但是，根据问题描述，可能需要额外的条件来判断28米高度对应的防火分类，而当前提供的表结构和字段不足以直接得出这个结论。如果实际数据库中有更多相关信息，请提供详细说明以便更准确地构建SQL查询。 2024-10-31 14:37:11 “有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑” get SQL(refined): select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where nai_huo_deng_ji_tks in ('多层建筑', '高层建筑') 2024-10-31 14:37:11 2024-10-31 14:37:11 表名：ragflow_16c496c43a8a11efbc850242ac140006； 2024-10-31 14:37:11 数据库表字段说明如下： 2024-10-31 14:37:11 gou_jian_ming_cheng_tks: 构件名称 2024-10-31 14:37:11 nai_huo_deng_ji_tks: 耐火等级 2024-10-31 14:37:11 2024-10-31 14:37:11 问题如下： 2024-10-31 14:37:11 有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑 2024-10-31 14:37:11 2024-10-31 14:37:11 你上一次给出的错误SQL如下： 2024-10-31 14:37:11 select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where nai_huo_deng_ji_tks in ('多层建筑', '高层建筑') 2024-10-31 14:37:11 2024-10-31 14:37:11 后台报错如下： 2024-10-31 14:37:11 BadRequestError(400, 'verification_exception', 'Found 1 problem\nline 1:123: [IN] cannot operate on field of data type [text]: No keyword/multi-field defined exact matches for [nai_huo_deng_ji_tks]; define one or use MATCH/QUERY instead') 2024-10-31 14:37:11 2024-10-31 14:37:11 请纠正SQL中的错误再写一遍，且只要SQL，不要有其他说明及文字。 2024-10-31 14:37:11 sql 2024-10-31 14:37:11 select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where MATCH(nai_huo_deng_ji_tks) AGAINST('多层建筑 高层建筑') 2024-10-31 14:37:11 2024-10-31 14:37:11 “有一个28m的建筑，在防火分类上属于多层建筑还是高层建筑” get SQL(refined): select doc_id,docnm_kwd, doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 where match(nai_huo_deng_ji_tks) against('多层建筑 高层建筑') 2024-10-31 14:37:11 {'error': 'BadRequestError(400, \'parsing_exception\', "line 1:166: mismatched input \')\' expecting \',\'")'} 2024-10-31 14:37:11 2024-10-31 14:37:11 表名：ragflow_16c496c43a8a11efbc850242ac140006； 2024-10-31 14:37:11 数据库表字段说明如下： 2024-10-31 14:37:11 gou_jian_ming_cheng_tks: 构件名称 2024-10-31 14:37:11 nai_huo_deng_ji_tks: 耐火等级 2024-10-31 14:37:11 2024-10-31 14:37:11 问题如下： 2024-10-31 14:37:11 这个条款具体内容是什么 2024-10-31 14:37:11 请写出SQL, 且只要SQL，不要有其他说明及文字。 2024-10-31 14:37:11 sql 2024-10-31 14:37:11 SELECT gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks 2024-10-31 14:37:11 FROM ragflow_16c496c43a8a11efbc850242ac140006; 2024-10-31 14:37:11 2024-10-31 14:37:11 “这个条款具体内容是什么” get SQL(refined): select doc_id,docnm_kwd, gou_jian_ming_cheng_tks, nai_huo_deng_ji_tks from ragflow_16c496c43a8a11efbc850242ac140006 2024-10-31 14:35:13 [INFO] [2024-10-31 06:35:13,019] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:13] "POST /v1/api/completion HTTP/1.1" 200 - 2024-10-31 14:35:39 [INFO] [2024-10-31 06:35:39,583] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:39] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:35:39 [INFO] [2024-10-31 06:35:39,585] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:39] "GET /v1/kb/list HTTP/1.1" 200 - 2024-10-31 14:35:40 [INFO] [2024-10-31 06:35:40,549] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:40] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:35:40 [INFO] [2024-10-31 06:35:40,551] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:40] "GET /v1/kb/list HTTP/1.1" 200 - 2024-10-31 14:35:41 [INFO] [2024-10-31 06:35:41,981] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:41] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:35:41 [INFO] [2024-10-31 06:35:41,984] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:41] "GET /v1/dialog/list HTTP/1.1" 200 - 2024-10-31 14:35:42 [INFO] [2024-10-31 06:35:42,010] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:42] "GET /v1/dialog/get?dialog_id=2d0aaed84d7611ef94690242ac140006 HTTP/1.1" 200 - 2024-10-31 14:35:42 [INFO] [2024-10-31 06:35:42,023] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:42] "GET /v1/conversation/list?dialog_id=2d0aaed84d7611ef94690242ac140006 HTTP/1.1" 200 - 2024-10-31 14:35:42 [INFO] [2024-10-31 06:35:42,085] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:35:42] "GET /v1/conversation/get?conversation_id=88521e62f740483e946b4c4f93ab80f5 HTTP/1.1" 200 - 2024-10-31 14:36:05 [INFO] [2024-10-31 06:36:05,500] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:05] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:36:11 [INFO] [2024-10-31 06:36:11,600] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:11] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:36:13 [INFO] [2024-10-31 06:36:13,312] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:13] "POST /v1/conversation/set HTTP/1.1" 200 - 2024-10-31 14:36:13 [INFO] [2024-10-31 06:36:13,336] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:13] "GET /v1/conversation/list?dialog_id=2d0aaed84d7611ef94690242ac140006 HTTP/1.1" 200 - 2024-10-31 14:36:30 [INFO] [2024-10-31 06:36:30,779] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:30] "POST /v1/conversation/completion HTTP/1.1" 200 - 2024-10-31 14:36:58 [INFO] [2024-10-31 06:36:58,449] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:36:58] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 14:37:11 [INFO] [2024-10-31 06:37:11,001] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 06:37:11] "POST /v1/conversation/completion HTTP/1.1" 200 - 2024-10-31 15:06:26 [INFO] [2024-10-31 07:06:26,036] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:26] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:06:26 [INFO] [2024-10-31 07:06:26,113] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:26] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:06:26 [INFO] [2024-10-31 07:06:26,115] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:26] "GET /v1/kb/list HTTP/1.1" 200 - 2024-10-31 15:06:27 [INFO] [2024-10-31 07:06:27,995] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:27] "GET /v1/user/tenant_info HTTP/1.1" 200 - 2024-10-31 15:06:28 [INFO] [2024-10-31 07:06:27,999] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:27] "GET /v1/kb/detail?kb_id=f8dc53a8758111ef94eb0242ac140006 HTTP/1.1" 200 - 2024-10-31 15:06:28 [INFO] [2024-10-31 07:06:28,002] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:28] "GET /v1/document/list?kb_id=f8dc53a8758111ef94eb0242ac140006&page=1&page_size=10 HTTP/1.1" 200 - 2024-10-31 15:06:28 [INFO] [2024-10-31 07:06:28,008] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:28] "GET /v1/document/list?kb_id=f8dc53a8758111ef94eb0242ac140006&page=1&page_size=10 HTTP/1.1" 200 - 2024-10-31 15:06:28 [INFO] [2024-10-31 07:06:28,013] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:28] "GET /v1/document/list?kb_id=f8dc53a8758111ef94eb0242ac140006&page=1&page_size=10 HTTP/1.1" 200 - 2024-10-31 15:06:29 [INFO] [2024-10-31 07:06:29,984] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:29] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:06:29 [INFO] [2024-10-31 07:06:29,986] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:29] "GET /v1/dialog/list HTTP/1.1" 200 - 2024-10-31 15:06:30 [INFO] [2024-10-31 07:06:30,012] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:30] "GET /v1/dialog/get?dialog_id=2d0aaed84d7611ef94690242ac140006 HTTP/1.1" 200 - 2024-10-31 15:06:30 [INFO] [2024-10-31 07:06:30,026] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:30] "GET /v1/conversation/list?dialog_id=2d0aaed84d7611ef94690242ac140006 HTTP/1.1" 200 - 2024-10-31 15:06:30 [INFO] [2024-10-31 07:06:30,089] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:06:30] "GET /v1/conversation/get?conversation_id=84ec60e5ef2c4022a987beb5dedc1cc4 HTTP/1.1" 200 - 2024-10-31 15:07:13 [INFO] [2024-10-31 07:07:13,885] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:07:13] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:12:00 [INFO] [2024-10-31 07:12:00,375] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:12:00] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:14:52 [INFO] [2024-10-31 07:14:52,752] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:14:52] "GET /v1/user/info HTTP/1.1" 200 - 2024-10-31 15:14:54 [INFO] [2024-10-31 07:14:54,097] [_internal._log] [line:96]: 172.20.0.6 - - [31/Oct/2024 07:14:54] "GET /v1/user/info HTTP/1.1" 200 -

KevinHuSh commented 2 weeks ago

What about creating a new knowledge base? I doubt that this KBs are used to use 'Table' to parse.

Melodyrose954 commented 1 week ago

What about creating a new knowledge base? I doubt that this KBs are used to use 'Table' to parse.

These knowledge bases use 'law' or 'paper' for parsing. The bugs still exist after creating a new knowledge base.

wangyw6716 commented 3 days ago

I'm having the same problem.