You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/05/03 14:41:23 UTC
[GitHub] [superset] vladimir-remar opened a new issue, #19937: Timeout in charts when `force refresh` is clicked.
vladimir-remar opened a new issue, #19937:
URL: https://github.com/apache/superset/issues/19937
#### How to reproduce the bug
After create a chart and get the first results when we try to `force refresh` we receive a `timout error`
### Expected results
We expect a re-run of the query and get data.
### Actual results
A timout response
#### Screenshots
First run
Force refresh run
### Environment
- browser type and version: Chrome (ChromeDriver 100.0.4896.60)
- superset version: 1.4.0
- python version: Python 3.8.10
- node.js version: N/A
- any feature flags active:
```python
{
"THUMBNAILS": True,
"LISTVIEWS_DEFAULT_CARD_VIEW": True,
"DASHBOARD_NATIVE_FILTERS": True,
"VERSIONED_EXPORT": True,
"ALERT_REPORTS": True,
"OMNIBAR": True,
"DASHBOARD_RBAC": True,
"THUMBNAILS_SQLA_LISTENERS": True,
"GLOBAL_ASYNC_QUERIES": True
}
```
- DB: BIgQuery
- Celery Config
```python
class CeleryConfig: # pylint: disable=too-few-public-methods
broker_url = "redis://localhost:6379/0"
imports = ("superset.sql_lab", "superset.tasks", "superset.tasks.thumbnails", "superset.charts", "superset.dashboards")
result_backend = "redis://localhost:6379/0"
worker_log_level = "DEBUG"
worker_prefetch_multiplier = 1
task_acks_late = True
task_annotations = {
"tasks.add": {
"rate_limit": "10/s"
},
"sql_lab.get_sql_results": {
"rate_limit": "100/s"
},
"email_reports.send": {
"rate_limit": "1/s",
"time_limit": 600,
"soft_time_limit": 600,
"ignore_result": True,
}
}
beat_schedule = {
"email_reports.schedule_hourly": {
"task": "email_reports.schedule_hourly",
"schedule": crontab(minute=1, hour="*")
},
"alerts.schedule_check": {
"task": "alerts.schedule_check",
"schedule": crontab(minute="*", hour="*")
},
"reports.scheduler": {
"task": "reports.scheduler",
"schedule": crontab(minute="*", hour="*")
},
"reports.prune_log": {
"task": "reports.prune_log",
"schedule": crontab(minute=0, hour=0)
},
"cache-warmup-hourly": {
"task": "cache-warmup",
"schedule": crontab(minute="*/30", hour="*"),
"kwargs": {
"strategy_name": "top_n_dashboards",
"top_n": 10,
"since": "7 days ago"
}
}
}
```
- Cache Config
```python
RESULTS_BACKEND = RedisCache(
host='localhost', port=6379, key_prefix='superset_results')
CACHE_CONFIG = {'CACHE_TYPE': 'redis', 'CACHE_DEFAULT_TIMEOUT': 86400, 'CACHE_KEY_PREFIX': 'superset_results', 'CACHE_REDIS_URL': 'redis://localhost:6379/0'}
DATA_CACHE_CONFIG = CACHE_CONFIG
```
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] 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.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
In order to run queries with BigQuery we had to enabled `Async query execution` otherwise the results were always a timouts.
--
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
[GitHub] [superset] Shazad-khan commented on issue #19937: Timeout in charts when `force refresh` is clicked.
Posted by "Shazad-khan (via GitHub)" <gi...@apache.org>.
Shazad-khan commented on issue #19937:
URL: https://github.com/apache/superset/issues/19937#issuecomment-1473644064
This issue has been fixed in the recent release please recheck the issue and close the bug
--
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
[GitHub] [superset] vladimir-remar closed issue #19937: Timeout in charts when `force refresh` is clicked.
Posted by "vladimir-remar (via GitHub)" <gi...@apache.org>.
vladimir-remar closed issue #19937: Timeout in charts when `force refresh` is clicked.
URL: https://github.com/apache/superset/issues/19937
--
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