msshroff opened a new issue, #34130: URL: https://github.com/apache/superset/issues/34130
### Bug description Reproduction steps: 1. Run Superset with "docker compose" on macbook 2. Login to Settings -> Database connections and add mysql database named MySQL 3. Go to "SQL Lab" , select postgres database "examples" , select schema "public", select any table and run test query on that, it is SUCCESS. 4. Go to "SQL Lab" , select newly added mysql database "MySQL" , ERROR appears 5. "SQL Lab" , select postgres database "examples" , select schema "public" (which was success in step 3) ERROR 6. Once the ERROR appears none of the Databases work, the only options is to Logout and Login again. I tried the same steps with Clickhouse DB as well with same results. So behaviour is not mysql specific. ### Screenshots/recordings Error on Step 4 <img width="1379" height="898" alt="Image" src="https://github.com/user-attachments/assets/10b304fe-3f20-4564-a3cb-e0769f9c0df8"; /> Error on Step 5 <img width="1338" height="821" alt="Image" src="https://github.com/user-attachments/assets/4f2cd191-d50e-4f6a-980f-a5d89033f384"; /> ### Superset version 5.0.0 ### Python version 3.9 ### Node version 16 ### Browser Safari ### Additional context **Post Step 4** Logs from container "superset_app" Main errors: "GET /api/v1/database/mysql-MySQL-5/function_names/ HTTP/1.1" 404 - "PUT /tabstateview/3 HTTP/1.1" 400 - `2025-07-11 10:24:02 2025-07-11 04:54:02,908:WARNING:superset.views.error_handling:HTTPException 2025-07-11 10:24:02 Traceback (most recent call last): 2025-07-11 10:24:02 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1484, in full_dispatch_request 2025-07-11 10:24:02 rv = self.dispatch_request() 2025-07-11 10:24:02 ^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:24:02 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1458, in dispatch_request 2025-07-11 10:24:02 self.raise_routing_exception(req) 2025-07-11 10:24:02 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1440, in raise_routing_exception 2025-07-11 10:24:02 raise request.routing_exception # type: ignore 2025-07-11 10:24:02 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:24:02 File "/app/.venv/lib/python3.11/site-packages/flask/ctx.py", line 353, in match_request 2025-07-11 10:24:02 result = self.url_adapter.match(return_rule=True) # type: ignore 2025-07-11 10:24:02 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:24:02 File "/app/.venv/lib/python3.11/site-packages/werkzeug/routing/map.py", line 629, in match 2025-07-11 10:24:02 raise NotFound() from None 2025-07-11 10:24:02 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. 2025-07-11 10:24:02 2025-07-11 04:54:02,910:INFO:werkzeug:192.168.65.1 - - [11/Jul/2025 04:54:02] "GET /api/v1/database/mysql-MySQL-5/function_names/ HTTP/1.1" 404 - 2025-07-11 10:24:07 2025-07-11 04:54:07,914:INFO:werkzeug:192.168.65.1 - - [11/Jul/2025 04:54:07] "PUT /tabstateview/3 HTTP/1.1" 400 - 2025-07-11 10:24:20 2025-07-11 04:54:20,476:INFO:werkzeug:192.168.65.1 - - [11/Jul/2025 04:54:20] "GET /api/v1/me/ HTTP/1.1" 200 -` Logs from superset_nginx `2025-07-11 10:24:02 192.168.65.1 - - [11/Jul/2025:04:54:02 +0000] "GET /api/v1/database/mysql-MySQL-5/function_names/ HTTP/1.1" 404 264 [1] "http://localhost/sqllab/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Safari/605.1.15" "-" 2025-07-11 10:24:07 192.168.65.1 - - [11/Jul/2025:04:54:07 +0000] "PUT /tabstateview/3 HTTP/1.1" 400 983 [2] "http://localhost/sqllab/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Safari/605.1.15" "-"` **Post Step 5** Logs from container "superset_app" post Step 5 Main Errors "GET /api/v1/database/postgresql-examples-1/function_names/ HTTP/1.1" 404 - "PUT /tabstateview/3 HTTP/1.1" 400 - `2025-07-11 10:25:52 2025-07-11 04:55:52,069:WARNING:superset.views.error_handling:HTTPException 2025-07-11 10:25:52 Traceback (most recent call last): 2025-07-11 10:25:52 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1484, in full_dispatch_request 2025-07-11 10:25:52 rv = self.dispatch_request() 2025-07-11 10:25:52 ^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:25:52 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1458, in dispatch_request 2025-07-11 10:25:52 self.raise_routing_exception(req) 2025-07-11 10:25:52 File "/app/.venv/lib/python3.11/site-packages/flask/app.py", line 1440, in raise_routing_exception 2025-07-11 10:25:52 raise request.routing_exception # type: ignore 2025-07-11 10:25:52 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:25:52 File "/app/.venv/lib/python3.11/site-packages/flask/ctx.py", line 353, in match_request 2025-07-11 10:25:52 result = self.url_adapter.match(return_rule=True) # type: ignore 2025-07-11 10:25:52 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-07-11 10:25:52 File "/app/.venv/lib/python3.11/site-packages/werkzeug/routing/map.py", line 629, in match 2025-07-11 10:25:52 raise NotFound() from None 2025-07-11 10:25:52 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. 2025-07-11 10:25:52 2025-07-11 04:55:52,074:INFO:werkzeug:192.168.65.1 - - [11/Jul/2025 04:55:52] "GET /api/v1/database/postgresql-examples-1/function_names/ HTTP/1.1" 404 - 2025-07-11 10:25:57 2025-07-11 04:55:57,067:INFO:werkzeug:192.168.65.1 - - [11/Jul/2025 04:55:57] "PUT /tabstateview/3 HTTP/1.1" 400 - 2025-07-11 10:26:21 2025-07-11 04:56:21,655:INFO:werkzeug:127.0.0.1 - - [11/Jul/2025 04:56:21] "GET /health HTTP/1.1" 200 -` Logs from superset_nginx `2025-07-11 10:25:52 192.168.65.1 - - [11/Jul/2025:04:55:52 +0000] "GET /api/v1/database/postgresql-examples-1/function_names/ HTTP/1.1" 404 264 [2] "http://localhost/sqllab/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Safari/605.1.15" "-" 2025-07-11 10:25:57 192.168.65.1 - - [11/Jul/2025:04:55:57 +0000] "PUT /tabstateview/3 HTTP/1.1" 400 999 [1] "http://localhost/sqllab/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Safari/605.1.15" "-"` ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
