superset: werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server

A clear and concise description of what the bug is.

How to reproduce the bug

Go to ‘.Data …’
Click on ‘.Databases…’
Scroll down to ‘…’ Trying to list database
See error perset_app | 81.220.237.14 - - [08/Jun/2022:20:04:52 +0000] “GET /static/assets/images/filter-results.svg HTTP/1.1” 404 0 “https://superset.kdinh.fr/databaseview/list/?pageIndex=0&sortColumn=expose_in_sqllab&sortOrder=desc” “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0” superset_app | 81.220.237.14 - - [08/Jun/2022:20:04:54 +0000] “GET /api/v1/database/?q=(order_column:expose_in_sqllab,order_direction:asc,page:0,page_size:25) HTTP/1.1” 200 529 “https://superset.kdinh.fr/databaseview/list/?pageIndex=0&sortColumn=expose_in_sqllab&sortOrder=asc” “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0” superset_app | HTTPException superset_app | Traceback (most recent call last): superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1516, in full_dispatch_request superset_app | rv = self.dispatch_request() superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1502, in dispatch_request superset_app | return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 515, in <lambda> superset_app | view_func=lambda **kw: self_ref().send_static_file(**kw), # type: ignore # noqa: B950 superset_app | File “/usr/local/lib/python3.8/site-packages/flask/scaffold.py”, line 332, in send_static_file superset_app | return send_from_directory( superset_app | File “/usr/local/lib/python3.8/site-packages/flask/helpers.py”, line 700, in send_from_directory superset_app | return werkzeug.utils.send_from_directory( # type: ignore superset_app | File “/usr/local/lib/python3.8/site-packages/werkzeug/utils.py”, line 847, in send_from_directory superset_app | raise NotFound() superset_app | 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. superset_app | 2022-06-08 20:04:54,173:WARNING:superset.views.base:HTTPException superset_app | Traceback (most recent call last): superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1516, in full_dispatch_request superset_app | rv = self.dispatch_request() superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1502, in dispatch_request superset_app | return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) superset_app | File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 515, in <lambda> superset_app | view_func=lambda **kw: self_ref().send_static_file(**kw), # type: ignore # noqa: B950 superset_app | File “/usr/local/lib/python3.8/site-packages/flask/scaffold.py”, line 332, in send_static_file superset_app | return send_from_directory( superset_app | File “/usr/local/lib/python3.8/site-packages/flask/helpers.py”, line 700, in send_from_directory superset_app | return werkzeug.utils.send_from_directory( # type: ignore superset_app | File “/usr/local/lib/python3.8/site-packages/werkzeug/utils.py”, line 847, in send_from_directory superset_app | raise NotFound() superset_app | 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.

Expected results

what you expected to happen. It should list database defined

Actual results

no databases listed what actually happens.

Screenshots

If applicable, add screenshots to help explain your problem.

Environment

(please complete the following information):

browser type and version:
superset version: superset version
python version: python --version
node.js version: node -v
any feature flags active:

Checklist

Make sure to follow these steps before submitting your issue - thank you!

I have checked the superset logs for python stacktraces and included it here as text if there are any.
I have reproduced the issue with at least the latest released version of superset.
I have checked the issue tracker for the same issue and I haven’t found one similar.

Additional context

Add any other context about the problem here.

About this issue

Original URL
State: open
Created 2 years ago
Reactions: 11
Comments: 30 (2 by maintainers)

Most upvoted comments

apache/superset:2.1.0 This version of the image is fine. Latest image has some problem that causes this issue intermittently.

ramrajneogrowth on Aug 3, 2023

Solved. This problem occurs due to static files not getting loaded while loading the dashboard. Missed due to cluttered documentation

cd ~/superset/superset-frontend/ npm install npm run build

sherlock30 on Jul 14, 2023

I encountered the same issue. I deployed Superset on a server using Docker Compose. Accessing localhost on the server interface works fine, but when I try to access it via the IP address, it keeps showing the login page and the browser continuously redirects. The server console shows a 404 error and the same errors as before. I haven’t found a solution yet. Later, I tried it on my Mac, and the result was the same. If I try to access it via the IP address on another computer, it stays on the login page indefinitely.

xddpool on Jul 6, 2023

on mac m1:

faced the same exception which was giving me a bad rendering:

2023-09-29 11:26:34,361:WARNING:superset.views.base:HTTPException
superset_app           | Traceback (most recent call last):
superset_app           |   File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1823, in full_dispatch_request
superset_app           |     rv = self.dispatch_request()
superset_app           |   File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1788, in dispatch_request
superset_app           |     self.raise_routing_exception(req)
superset_app           |   File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1770, in raise_routing_exception
superset_app           |     raise request.routing_exception  # type: ignore
superset_app           |   File "/usr/local/lib/python3.9/site-packages/flask/ctx.py", line 351, in match_request
superset_app           |     result = self.url_adapter.match(return_rule=True)  # type: ignore
superset_app           |   File "/usr/local/lib/python3.9/site-packages/werkzeug/routing/map.py", line 652, in match
superset_app           |     raise NotFound() from None
superset_app           | 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.

I did the following and it worked for me:

git clone https://github.com/apache/superset
#installed node npm with versions v18.16.0/ 9.5.1 respectively.
cd superset/superset-frontend
npm install cross-env
npm install -f --no-optional --global webpack webpack-cli; 
npm run build
cd -
#create virtual env of 3.9 and activate
mamba create -n superset python=3.9 ; mamba activate superset; 
pip install -r requirements/testing.txt;
pip install -e .;
superset db upgrade;
superset fab create-admin;
superset init;
superset load-examples;
export SUPERSET_SECRET_KEY=D1acauGDSStiNuu2O1ZmK9E59QUPkRfB_some_key
export TALISMAN_ENABLED="False"
FLASK_ENV=development superset run -p 8088 --with-threads --reload --debugger

hope this helps.

jaihind213 on Nov 11, 2023

i tried to change features SESSION_COOKIE_SAMESITE to Lax,but not work,it still cause error not found. GET /ws HTTP/1.1[/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/werkzeug/routing.py>>>path_info:[/ws],>>>[None]]>>>[True]>>>[None]>>>[None] [/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/werkzeug/routing.py>>>path:[|/ws]] 2022-07-22 09:28:35,152:WARNING:superset.views.base:HTTPException Traceback (most recent call last): File “/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/flask/app.py”, line 1516, in full_dispatch_request rv = self.dispatch_request() File “/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/flask/app.py”, line 1492, in dispatch_request self.raise_routing_exception(req) File “/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/flask/app.py”, line 1474, in raise_routing_exception raise request.routing_exception # type: ignore File “/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/flask/ctx.py”, line 376, in match_request result = self.url_adapter.match(return_rule=True) # type: ignore File “/home/ryan/anaconda3/envs/superset/lib/python3.8/site-packages/werkzeug/routing.py”, line 2048, in match raise NotFound()

JunTech on Jul 22, 2022

Hi,

Thank a lot I change the parameter SESSION_COOKIE_SAMESITE and it is OK now

khanh78180 on Jul 18, 2022

This is my superset_config.py

apole on Mar 13, 2023

SESSION_COOKIE_SAMESITE was set to “Lax” for me, setting it to None worked for me.

akzarma on Oct 5, 2022