Pain point · Reliability & bugs · Causes churn
Failing scheduled query retried endlessly, loading the database
5 source threads · first seen 2015-10 · last seen 2023-09
Summary
A query raising an error is retried repeatedly, sustaining high database load, and the failure was only discoverable in a supervisor log.
- Affects
- teams with scheduled queries
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“The second issue eventually consumes the entire query pool and prevents any query from running”
“We have an issue where it seems like the Scheduler is not picking up the queries that we've put a refresh_schedule on”
“My redash never refresh all my queries”
“I have a series of queries stucked in my queries queue and it seems impossible to cancel them”
“It appears that this exception causes celery to retry the same query again and again”