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

always return with this error. ["There was an error loading the tables"] #21476

Closed
TrendTech opened this issue Sep 15, 2022 · 14 comments · Fixed by #21470
Closed

always return with this error. ["There was an error loading the tables"] #21476

TrendTech opened this issue Sep 15, 2022 · 14 comments · Fixed by #21470
Labels
#bug Bug report

Comments

@TrendTech
Copy link

TrendTech commented Sep 15, 2022

image
image

  1. i follow the install instruction
  2. i add a mysql database.
  3. when i try to visit the tables. it bring this error. i try old version. still the same
  4. what i miss in my install process?
@TrendTech TrendTech added the #bug Bug report label Sep 15, 2022
@novice-gamer
Copy link

I also encountered this problem

1 similar comment
@GeorgeSpring
Copy link

I also encountered this problem

@TrendTech
Copy link
Author

mysql version is 5.7
and even the example database is failed to fetch the table.
image

@TrendTech TrendTech changed the title always return with this error. always return with this error. ["There was an error loading the tables"] Sep 15, 2022
@mAd-DaWg
Copy link

mAd-DaWg commented Sep 15, 2022

Same issue here in the docker. It lists the tables fine, but when trying to select a table this error occurs. I noticed that its putting /undefined/false on the end of the request url. when removing it, it seems to load response json fine.

werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
[15/Sep/2022:10:40:18 +0000] "GET /superset/tables/4/exampletable/undefined/false/ HTTP/1.1" 404 334 "http://0.0.0.0:8088/tablemodelview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36"

Also saw a flask error on startup which may be relevant:
/usr/local/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py:68: SAWarning: relationship 'SqlaTable.slices' will copy column tables.id to column slices.datasource_id, which conflicts with relationship(s): 'Slice.table' (copies tables.id to slices.datasource_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="table"' to the 'SqlaTable.slices' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)

@bumasl
Copy link

bumasl commented Sep 15, 2022

same error marks me, someone could already solve the error?

image

@C-monC
Copy link

C-monC commented Sep 15, 2022

Same issue, huge block currently

@andrearoota
Copy link

Same issue

@garystafford
Copy link

garystafford commented Sep 16, 2022

Same issue with the latest tag (3ed6d3e979351616cd5474b2404e136604d74cf50e4eeaf2e5a74f6f8a32130a).

@C-monC
Copy link

C-monC commented Sep 16, 2022

If you use superset in production and want to track the fix #21470

@bumasl
Copy link

bumasl commented Sep 21, 2022

Can someone explain me the detailed steps to solve this problem?
I thank you for your kind attention

@C-monC
Copy link

C-monC commented Sep 21, 2022

Pulling the latest version should work.
Make sure to clear cache.

@bumasl
Copy link

bumasl commented Sep 21, 2022

Thank you very much for your prompt response, in this order it worked for me
1 - delete container
docker-compose -f docker-compose-non-dev.yml down -v
2- clearing images from previous container
sudo docker system prune --all
3- Start the container again
docker-compose -f docker-compose-non-dev.yml up

I hope it helps those who have the same problem

@C-monC
Copy link

C-monC commented Sep 22, 2022

Try with docker-compose.yml - it should work.

@sjmillius
Copy link

I'm still seeing this issue in our setup on Google cloud.
We're using Postgres proxy to Cloud SQL, Redis and depoly via helm using apache/superset:latest.

It still produces the error in sqllab: [There was an error loading the tables] as described here.
How can this be resolved?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
#bug Bug report
Projects
None yet
Development

Successfully merging a pull request may close this issue.

9 participants