[Bug] [ChatData] parse_view_response error!Can not find sql in response

[MilkWangStudio]

Search before asking

• I had searched in the issues and found no similar issues.

Operating system information

Linux

Python version information

=3.11

DB-GPT version

main

Related scenes

• Chat Data
• Chat Excel
• Chat DB
• Chat Knowledge
• Model Management
• Dashboard
• Plugins

Installation Information

• Installation From Source

• Docker Installation

• Docker Compose Installation

• Cluster Installation

• AutoDL Image

• Other

Device information

镜像: eosphoros-ai/DB-GPT/dbgpt:v0.5.10
GPU: RTX 4090D(24GB) * 1
CPU: 16 vCPU Intel(R) Xeon(R) Platinum 8481C
内存: 80GB
硬盘: 30 GB

Models information

LLM: qwen2-0.5b-instruct

What happened

When using ChatData, the returned JSON is not in a qualified format, Causing inability to parse SQL.

What you expected to happen

Return the correct JSON format

How to reproduce

1. Create container with AutoDL Images, version is: eosphoros-ai/DB-GPT/dbgpt:v0.5.10
2. Import my MySQL datasource.
3. Use chatdata module.
4. Return incorrect JSON format

Additional context

2024-09-18 10:10:47 autodl-container-a1364fba4b-1ef9d419 dbgpt.app.scene.chat_db.auto_execute.out_parser[1278] ERROR json load failed:{      "thoughts ":  "There are several validation rules to be included in this system.           "sql ":  "SELECT COUNT(*) AS total_rules FROM audit_rules WHERE status='active'      "}

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[ygbingo]

我也遇到了这个问题，用的0.6.0的镜像，也是大模型回复的内容解析json失败，导致无法提取sql字段