These are chat archives for getredash/redash

11th
Sep 2016
kanfil
@kanfil
Sep 11 2016 12:34
hi, I would like to use the data parameters with mysql, I am getting zero results while using this where statement "( date(meetings.date_start) between {{start_date}} and {{end_date}} ) "
Arik Fraimovich
@arikfr
Sep 11 2016 12:40
you should properly quote the dates as you would do with "regular" values.
kanfil
@kanfil
Sep 11 2016 12:41
already did that, doesn't worked for me
Arik Fraimovich
@arikfr
Sep 11 2016 12:41
check the query that being sent to the database and make sure it's correct
kanfil
@kanfil
Sep 11 2016 12:42
i used the following '{{start_date}}' and '{{end_date}}', the query works without the condition
where do I find the "sql" which is sent to the server?
i tried to change the log to "DEBUG" level but didn't find the sql?
Arik Fraimovich
@arikfr
Sep 11 2016 12:46
what log file did you look at?
kanfil
@kanfil
Sep 11 2016 12:46
api_error?
Arik Fraimovich
@arikfr
Sep 11 2016 12:47
look at celery_error.log
kanfil
@kanfil
Sep 11 2016 12:49
noting is displayed [2016-09-11 15:28:52,179: WARNING/MainProcess] celery@new-planet ready.
[2016-09-11 15:28:52,181: WARNING/MainProcess] celery@new-planet ready.
Arik Fraimovich
@arikfr
Sep 11 2016 12:51
maybe increase the log level and restart celery
kanfil
@kanfil
Sep 11 2016 12:52
already did that using "sudo supervisorctl restart all"
Arik Fraimovich
@arikfr
Sep 11 2016 12:52
and when you run queries you don't see new output in celery_error.log?
make sure you don't have old celery processes running
kanfil
@kanfil
Sep 11 2016 12:53
yes, meaning to killall celery?
Arik Fraimovich
@arikfr
Sep 11 2016 12:53
?
kanfil
@kanfil
Sep 11 2016 12:56
I stopped all services "sudo supervisorctl stop all" and " sudo supervisorctl start all" and manage to solve it, thanks!
Arik Fraimovich
@arikfr
Sep 11 2016 12:57
:+1: