You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "vivian-rook (via GitHub)" <gi...@apache.org> on 2023/04/27 17:55:03 UTC
[GitHub] [superset] vivian-rook opened a new issue, #23855: Superset silently does not run queries with many databases
vivian-rook opened a new issue, #23855:
URL: https://github.com/apache/superset/issues/23855
After adding 930 databases as data sources I'm finding that many of them will fail to have a query run against them. Seemingly doing nothing when the submit button is pressed. This seems to occur on databases added after 90. So the 90th database works, the 91st does not. Spot checking databases earlier in the series also seem to work, later do not appear to.
#### How to reproduce the bug
Add a lot of databases, at least 100. Do a query against the last database added.
### Expected results
Query to run, results to show.
### Actual results
A blue outline appears around the Run button indicating a click has happened then nothing happens, there is no loading icon, logs do not seem to change. Nothing on the screen appears to change.
### Environment
Superset is deployed to k8s with helm:
`helm install superset superset/superset -f values.yaml -f dbs.yaml`
values.yaml contains oauth information, dbs.yaml contains a long list of dbs:
```
extraConfigs:
import_datasources.yaml: |
databases:
- database_name: aawiki
password: <password>
sqlalchemy_uri: mysql+mysqldb://<user>@aawiki.analytics.db.svc.eqiad.wmflabs:3306/aawiki_p?ssl=1
- database_name: aawikibooks
password: <password>
sqlalchemy_uri: mysql+mysqldb://<user>@aawikibooks.analytics.db.svc.eqiad.wmflabs:3306/aawikibooks_p?ssl=1
- database_name: aawiktionary
...
```
Firefox 112.0.2
Superset 2.0.1
Python 3.8.12
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Superset silently does not run queries with many databases [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23855:
URL: https://github.com/apache/superset/issues/23855#issuecomment-1965472210
We haven't heard other reports of this, but hopefully this is resolved by now. Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. Thanks!
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Superset silently does not run queries with many databases [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #23855: Superset silently does not run queries with many databases
URL: https://github.com/apache/superset/issues/23855
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org