-
Notifications
You must be signed in to change notification settings - Fork 404
Description
SQLBot 1.2.0
Run Mode
在docker容器部署
Describe the bug
配置好ollama模型后,使用问数报错,但sql是已经出来的,具体报错日志为:
2025-10-16 11:41:39,582 - apps.chat.task.llm - INFO:1365 - content='' additional_kwargs={} response_metadata={'finish_reason': 'stop', 'model_name': 'qwen3:4b', 'system_fingerprint': 'fp_ollama'} id='run--150d5103-253c-45d7-9e78-725c28226b14'
2025-10-16 11:41:39,583 - apps.chat.task.llm - INFO:1365 - content='' additional_kwargs={} response_metadata={} id='run--150d5103-253c-45d7-9e78-725c28226b14' usage_metadata={'input_tokens': 4096, 'output_tokens': 4673, 'total_tokens': 8769, 'input_token_details': {}, 'output_token_details': {}}
2025-10-16 11:41:39,613 - apps.chat.task.llm - INFO:988 - {
"query": "SELECT \n u.user_name AS 用户名,\n u.user_id AS 用户ID,\n GROUP_CONCAT(r.role_name SEPARATOR ',') AS 角色\nFROM \n sys_user u\nLEFT JOIN sys_user_role ur ON u.user_id = ur.user_id\nLEFT JOIN sys_role r ON ur.role_id = r.role_id\nGROUP BY u.user_id\nUNION\nSELECT \n r.role_name AS 角色,\n COUNT(ur.user_id) AS 用户数\nFROM \n sys_role r\nLEFT JOIN sys_user_role ur ON r.role_id = ur.role_id\nGROUP BY r.role_name\nUNION\nSELECT \n p.post_name AS 岗位,\n COUNT(up.user_id) AS 用户数\nFROM \n sys_post p\nLEFT JOIN sys_user_post up ON p.post_id = up.post_id\nGROUP BY p.post_name"
}
Traceback (most recent call last):
File "/opt/sqlbot/app/apps/chat/task/llm.py", line 739, in check_sql
if data['success']:
~~~~^^^^^^^^^^^
KeyError: 'success'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/sqlbot/app/apps/chat/task/llm.py", line 1019, in run_task
sql = self.check_save_sql(res=full_sql_text)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/sqlbot/app/apps/chat/task/llm.py", line 775, in check_save_sql
sql, *_ = self.check_sql(res=res)
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/sqlbot/app/apps/chat/task/llm.py", line 747, in check_sql
raise SingleMessageError(orjson.dumps({'message': 'Cannot parse sql from answer',
common.error.SingleMessageError: {"message":"Cannot parse sql from answer","traceback":"Cannot parse sql from answer:\n{\n "query": "SELECT \n u.user_name AS 用户名,\n u.user_id AS 用户ID,\n GROUP_CONCAT(r.role_name SEPARATOR ',') AS 角色\nFROM \n sys_user u\nLEFT JOIN sys_user_role ur ON u.user_id = ur.user_id\nLEFT JOIN sys_role r ON ur.role_id = r.role_id\nGROUP BY u.user_id\nUNION\nSELECT \n r.role_name AS 角色,\n COUNT(ur.user_id) AS 用户数\nFROM \n sys_role r\nLEFT JOIN sys_user_role ur ON r.role_id = ur.role_id\nGROUP BY r.role_name\nUNION\nSELECT \n p.post_name AS 岗位,\n COUNT(up.user_id) AS 用户数\nFROM \n sys_post p\nLEFT JOIN sys_user_post up ON p.post_id = up.post_id\nGROUP BY p.post_name"\n}"}
INFO: 127.0.0.1:46278 - "GET / HTTP/1.1" 200 OK