Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
michabbb opened this issue Aug 3, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@michabbb
Copy link

michabbb commented Aug 3, 2024

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 michabbb added the bug Something isn't working label Aug 3, 2024
@wwwy3y3
Copy link
Member

wwwy3y3 commented Aug 4, 2024

@michabbb thanks for opening up this issue.

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

@onlyjackfrost
Copy link
Contributor

onlyjackfrost commented Aug 5, 2024

@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
Copy link
Author

michabbb commented Aug 5, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants