Scheduled queries not refreshing #7169
Unanswered
galenspikes
asked this question in
Q&A
Replies: 2 comments
-
Maybe u should restart scheduler service every day. U can set a corntab only restart scheduler. Because the python rq is not stabled. |
Beta Was this translation helpful? Give feedback.
0 replies
-
And another reason is u use Date parameter, and Data parameter time zone is UTC. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We have about 550 scheduled queries. We noticed that some queries in a dashboard have not refreshed for a couple weeks, even though they are supposed to refresh at least daily. Looking at one query for example in the Redash application database in the queries table, it shows 0 for schedule_failures. Any ideas on how to handle this? I also don't see any errors in the log.
When I search the docker log in redash_scheduled_worker_1 for the query_id it also shows the schedule seems to be running every day. It isn't refreshing in the GUI though.
In these log entries from yesterday you can see it executes and finishes
[2024-09-18 12:31:14,206][PID:4536][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=11557841-20fa-4d86-b9d6-7b1df1f22e1f job=execute_query state=executing_query query_hash=38834c78782bbc1bb442e233ae03186e type=redshift ds_id=47 job_id=11557841-20fa-4d86-b9d6-7b1df1f22e1f queue=scheduled_queries query_id=5227 username=Scheduled
[2024-09-18 12:32:12,740][PID:4536][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=11557841-20fa-4d86-b9d6-7b1df1f22e1f job=execute_query state=checking_alerts query_hash=38834c78782bbc1bb442e233ae03186e type=redshift ds_id=47 job_id=11557841-20fa-4d86-b9d6-7b1df1f22e1f queue=scheduled_queries query_id=5227 username=Scheduled
[2024-09-18 12:32:12,741][PID:4536][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=11557841-20fa-4d86-b9d6-7b1df1f22e1f job=execute_query state=finished query_hash=38834c78782bbc1bb442e233ae03186e type=redshift ds_id=47 job_id=11557841-20fa-4d86-b9d6-7b1df1f22e1f queue=scheduled_queries query_id=5227 username=Scheduled
Beta Was this translation helpful? Give feedback.
All reactions