search

Canner / WrenAI

Open-source Text-to-SQL solution, Wren AI makes your database RAG-ready.
https://getwren.ai
GNU Affero General Public License v3.0
1.49k stars 122 forks source link

No relevant SQL found for the given query. Please check your query and try again. #446

Open suiquantong opened 1 month ago

suiquantong commented 1 month ago

Describe the bug No relevant SQL No relevant SQL found for the given query. Please check your query and try again. To Reproduce Steps to reproduce the behavior:

  1. 连接数据库，设置数据库的注释
  2. 点击发送问题
  4. See error

Expected behavior 我请求了接口，看到数据也有返回，但是最后页面并没有显示数据

Screenshots If applicable, add screenshots to help explain your problem.

Container Logs 

docker logs wrenai-wren-ui-1 >& wren-ui.log && \
docker logs wrenai-wren-ai-service-1 >& wren-ai-service.log && \
docker logs wrenai-wren-engine-1 >& wren-engine.log
docker logs wrenai-ibis-server-1 >& wrenai-ibis-server-1.log

Desktop (please complete the following information):

Wren AI Information

Additional context Add any other context about the problem here.

cyyeh commented 1 month ago

@suiquantong sorry, content of the logs is empty, it seems that you are not using launcher to start WrenAI, right? So, the container names are wrong.

suiquantong commented 1 month ago

我想知道 我如何在启动前更改我的 openai 的地址  

〆落花ァ笑彷徨ㄟ @.***

 

cyyeh commented 1 month ago

@suiquantong it's good timing haha. we'll release this next week. I'll provide documentation here.

suiquantong commented 1 month ago

还有个问题，我再重启后容器后 会重新加载/root/.wrenai/.env 里面的配置参数嘛 夏笙 @. ---- Replied Message ---- FromChih-Yu @.>Date6/27/2024 @.>@.>, @.>SubjectRe: [Canner/WrenAI] No relevant SQL found for the given query. Please check your query and try again. (Issue #446) @suiquantong it's good timing haha. we'll release this next week. I'll provide documentation here. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: @.>

wwwy3y3 commented 1 month ago

还有个问题，我再重启后容器后 会重新加载/root/.wrenai/.env 里面的配置参数嘛

I don't think restarting container will reload env.

You'll have to re-run the launcher again. The launcher will do a docker-compose up again, which should recreate the containers with the new environment variables.

suiquantong commented 1 month ago

每次 执行./wren-launcher-linux 都会执行如下操作 会覆盖我的修改 Downloading docker-compose file to /root/.wrenai/docker-compose.yaml Downloading env file to /root/.wrenai/.env.example 我不想让他覆盖的我配置 夏笙 @. ---- Replied Message ---- Fromwilliam @.>Date6/27/2024 @.>@.>, @.>SubjectRe: [Canner/WrenAI] No relevant SQL found for the given query. Please check your query and try again. (Issue #446) 还有个问题，我再重启后容器后 会重新加载/root/.wrenai/.env 里面的配置参数嘛 I don't think restarting container will reload env. You'll have to re-run the launcher again. The launcher will do a docker-compose up again, which should recreate the containers with the new environment variables. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: @.>

suiquantong commented 1 month ago

wrenai-ibis-server-1.log wren-ui.log wren-engine.log wren-ai-service.log

wwwy3y3 commented 4 weeks ago

@suiquantong I see. May I know what adjustments you made to the env file ?

Maybe you could start Wren AI without launcher. Just cd to ~/.wrenai and run docker-compose up. This way you could control the env file content yourself and reload env by running docker-compose up again.

Check StackOverflow here for reference: https://stackoverflow.com/a/42150882/1191953