WrenAI icon indicating copy to clipboard operation
WrenAI copied to clipboard

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

Open michabbb opened this issue 1 year ago • 3 comments

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):

  • OS: linux (debian)
  • Browser vivaldi

Wren AI Information

  • Version: 0.7.5
  • LLM_PROVIDER= openai_llm
  • GENERATION_MODEL= gtp4o-mini

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

michabbb avatar Aug 03 '24 11:08 michabbb

@michabbb thanks for opening up this issue.

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

wwwy3y3 avatar Aug 04 '24 08:08 wwwy3y3

@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

onlyjackfrost avatar Aug 05 '24 02:08 onlyjackfrost

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.

michabbb avatar Aug 05 '24 15:08 michabbb