These are chat archives for getredash/redash

9th
Sep 2016
HenroRitchie
@HenroRitchie
Sep 09 2016 07:03
@arikfr Where is the celery config file stored?
HenroRitchie
@HenroRitchie
Sep 09 2016 11:34
@arikfr Hi. How do I enable the auto update in 0.11.1+b2095
Arik Fraimovich
@arikfr
Sep 09 2016 14:43
@HenroRitchie what do you mean by "auto update"?
@HenroRitchie check in redash/worker.py the line that begins with celery.conf.update.
HenroRitchie
@HenroRitchie
Sep 09 2016 14:47
@arikfr Thank you. What should it be to enable auto refresh?
Arik Fraimovich
@arikfr
Sep 09 2016 14:50
I'm still not sure what you mean by auto refresh? of the dashboard?
HenroRitchie
@HenroRitchie
Sep 09 2016 14:50
Apologies, half a question will only get half an answer.
In one of our earlier discussions I mentioned that my queries are not refreshing even when the refresh schedule is set to 1min
I would like to enable this functionality
Arik Fraimovich
@arikfr
Sep 09 2016 14:52
the query itself, or when you enable auto refresh in a dashboard?
HenroRitchie
@HenroRitchie
Sep 09 2016 14:52
When I enable auto refresh in the dashboard
Well, actually I am not sure. The refresh schedule is sitting on 'every 1 min' but the last update time is '31 min'. If the auto refresh works correctly should the last update time not be less than 1 min always?
both in the query and in the dashboard?
Arik Fraimovich
@arikfr
Sep 09 2016 14:57

Dashboard: there is a bug with auto refresh, which I fixed in 0.12.

Query: you're right, it should be ~1 minute ago at most. Try running it manually, does it run?

HenroRitchie
@HenroRitchie
Sep 09 2016 14:58
Yes it does run everytime I press the refresh button
Arik Fraimovich
@arikfr
Sep 09 2016 14:58
Maybe there is something (a query) that is currently blocking the scheduled queries workers?
HenroRitchie
@HenroRitchie
Sep 09 2016 15:02
so fix #1264 is only related to the dashboard auto refresh and not to the query auto refresh?
How would I check if the scheduled queries are being blocked?
Arik Fraimovich
@arikfr
Sep 09 2016 15:07
yes, it's only about the dashboards.
you can follow the workers' logs. if you used the bootstrap script, you can check when the workers were last restarted -- they supposed to be restarted after running 10 queries. so if you see one that wasn't restarted in a long time, it might indicate being stuck. then by process id you can try to see what query it was running
HenroRitchie
@HenroRitchie
Sep 09 2016 15:22
is each celery_error log for that specific worker?
Arik Fraimovich
@arikfr
Sep 09 2016 15:23
No, it's for all of them. But iirc it mentions the process id.