These are chat archives for getredash/redash

10th
Nov 2015
martin sarsale
@runa
Nov 10 2015 13:19
[2015-11-10 07:19:29,706][PID:15104][INFO][redash.tasks] Deleted 100 unused query results out of total of 161375.
:)
Arik Fraimovich
@arikfr
Nov 10 2015 14:00
@runa you might want to change the 100 query results at a time value to something higher like 1K
sunand chakradhar
@sunandchakradhar
Nov 10 2015 14:03
hi @arikfr . Celery wiki says we can configure different queues per data sources. Where can it be configured?
Arik Fraimovich
@arikfr
Nov 10 2015 14:15
@sunandchakradhar currently there is no UI for it, but each data source has a queue_name and scheduled_queue_name columns, that define which queue it uses for adhoc and scheduled queries.
@sunandchakradhar you also need to make sure that you have celery workers "listening" for these queues.
sunand chakradhar
@sunandchakradhar
Nov 10 2015 14:18
okay
thank you.
martin sarsale
@runa
Nov 10 2015 15:12
@arikfr just 2gb now :)
Arik Fraimovich
@arikfr
Nov 10 2015 18:47
@runa much better :)
martin sarsale
@runa
Nov 10 2015 20:58
@arikfr btw, make sure to change the redis config in the provision script. it should read "bind 127.0.0.1"
@arikfr btw, I dumped the redash and postgres tables; but when I try to restore the backup, I'm getting: ERROR: role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
REVOKE
ERROR:  role "redash" does not exist
ERROR:  role "redash" does not exist
ERROR:  role "redash_reader" does not exist
Arik Fraimovich
@arikfr
Nov 10 2015 21:20
@runa how did you create the new instnace?