These are chat archives for getredash/redash

14th
Feb 2018
Arik Fraimovich
@arikfr
Feb 14 2018 10:17
@GiorgosTseres_twitter it uses the system's user authentication so you can just run sudo -u postgres psql redash.
@GiorgosTseres_twitter actually sudo -u redash psql.
@jeyb it will be possible in v4 (beta will be released soon).
@odedelharar worker logs.
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:29
@arikfr thanks for the help. Another question that has come up is if there is a recommended process of bulk importing multiple queries from another source.
I have used the following tool to bulk import queries, while setting the schedule to 3600: https://github.com/kirikiriyamama/redash-query-importer
Half day later, I can see that none of the queries has been executed (if I look at the queries table, I can see that latest_query_data_id is empty)
Arik Fraimovich
@arikfr
Feb 14 2018 12:30
@GiorgosTseres_twitter what version of Redash are you using?
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:30
@arikfr 3.0.0+b3134
Arik Fraimovich
@arikfr
Feb 14 2018 12:32
in the past the scheduler wouldn't run queries that were not run before. but I think we fixes that already.
make sure the scheduler and workers are working proeprly.
and that the query execute manually...
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:33
@arikfr will do. Are there any logs that I could look into for troubleshooting?
Arik Fraimovich
@arikfr
Feb 14 2018 12:34
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:37
Thanks!
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:43
What version onward is supervisord used? I cannot find it under /opt/redash/current/
Arik Fraimovich
@arikfr
Feb 14 2018 12:44
if you're using a recent AMI then supervisor is installed with a system package. this is why I linked this pull request, it has updated info about file locations.
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:45
Yeap, just saw that. Thanks for the help Arik!
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 12:55
Unfortunately I cannot see any logs being generated in the logfiles that have been specified in /etc/supervisor/conf.d/redash.conf
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 13:01
Could you please share the PR where you fixed the issue where the scheduler did not run queries that have not been run before?
Arik Fraimovich
@arikfr
Feb 14 2018 13:20
no, but just trying running one manually and see if it refreshes later on with a schedule
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 13:25
Sure, just done that. Will wait to see if it's run again. Is it possible to invoke query execution from the API?
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 14:19
@arikfr update on the query scheduling issue: For queries that have been run once, scheduler executes them again. So the issue seems to be with the ones that have been never run
Arik Fraimovich
@arikfr
Feb 14 2018 14:28
you can trigger execution with the /refresh api.
George Tseres
@GiorgosTseres_twitter
Feb 14 2018 14:29
Great, thanks! Except for looking into the code itself, is there any place where the API endpoints are documented?