search

Canner / WrenAI

🚀 Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! 🙌
https://www.getwren.ai/oss
GNU Affero General Public License v3.0
1.69k stars 151 forks source link

all tables have foreign keys, but not a single relation gets shown on the model page #578

Open michabbb opened 1 month ago

michabbb commented 1 month ago

Describe the bug as you can see in the screenshot, it says that relations are generated based on foreign keys (and all my mysal tables have foreign keys). but it does not play a role if I click on "skip" or "finish" - when going to the models page where you see all tables, there is not a single relation - what am I missing here ???

To Reproduce Steps to reproduce the behavior:

  1. add a mysql/mariadb database
  2. see screenshot: I don´t know what to press, but doesn´t play a role here
  3. go to models page
  4. not a single relation is shown

Expected behavior I should see auto-generated relations on the map of tables

Screenshots image

Desktop (please complete the following information):

Wren AI Information

Additional context I added a mariadb database with over 100 tables this should not play a role, but I am using a read-only MySQL user

wwwy3y3 commented 1 month ago

@michabbb thanks for opening up this issue.

I'll discuss this with our member @onlyjackfrost and get back to you on this thread.

onlyjackfrost commented 1 month ago

@michabbb The latest Mariadb works fine in my local environment with the TPC-H dataset. Could you please provide the Docker logs for the wren-ui-service and wren-ibis-server? We may need to review them.

docker logs wrenai-wren-ui-1 >& wrenai-wren-ui.log && \
docker logs wrenai-ibis-server-1 >& wrenai-ibis-server.log
michabbb commented 1 month ago

i have to setup everything again, will let you know when done. i am using an older version of mariadb, maybe it has something to do with that. you can try this docker image mariadb:10.3.10 if you like.