These are chat archives for getredash/redash

9th
Jun 2015
eschultze
@eschultze
Jun 09 2015 13:48
hello everyone! Is anyone using redash with CloudFlare? I'm having issues with their cache. Every time a user hits /dashboard/mydashboard if the page is not previously cached in CloudFlare, the user has to refresh the page.
DBY
@Dnile
Jun 09 2015 14:19
hey, i’m having trouble with accessing through mobile
i get just the headline and the top bar
no data :\
eschultze
@eschultze
Jun 09 2015 14:23
what happens if you refresh?
DBY
@Dnile
Jun 09 2015 14:23
same thing
guess not just mobile
safari doesnt work now too
i usually access from chrome
Arik Fraimovich
@arikfr
Jun 09 2015 14:40
@eschultze the demo instance is using cloudflare but didn't notice anything like that. Are you sure it's a problem with cloudflare? What version of redash are you using?
@dnile what version are you using? Anything in the developer console?
DBY
@Dnile
Jun 09 2015 14:49
the latest
redash.0.6.1.b840
cheome works fine, so nothing there
checking safari
Cory
@clevinson
Jun 09 2015 14:54
hey @arikfr is this upgrade documentation up to date? I remmeber something weird with the fabfile last time I upgraded (specifically related to the migration for adding the ability to archive queries)
DBY
@Dnile
Jun 09 2015 15:19
well. that happens only on chrome on ios, and on safari on osx
android chrome show it well
not sure how i can get data form iOS-chrome
but when i know i’ll post that stuff
Arik Fraimovich
@arikfr
Jun 09 2015 16:52
@Dnile what about from Safari/OSX?
@clevinson it is and I did some updates since last time you used it (following your feedback, I think). But recently I was thinking of stopping all services before running the migrations as a precaution. I suggest that if you haven't updated in a while, to stop everything (supervisorctl stop all) before running the upgrade, just in case.
Cory
@clevinson
Jun 09 2015 17:11
k thanks
@arikfr how do i get to view the schema browser on a redshift connection? (postgres)
Arik Fraimovich
@arikfr
Jun 09 2015 17:34
@clevinson you mean the one next to the query? if you have a supporting version, it should just appear once it gets the schema. you don't see it?
Cory
@clevinson
Jun 09 2015 17:35
nope. and i just updated
Arik Fraimovich
@arikfr
Jun 09 2015 17:40
strange. do you see the new logo instead of the "re:dash" text in the upper left corner?
Cory
@clevinson
Jun 09 2015 17:41
yep
Arik Fraimovich
@arikfr
Jun 09 2015 17:42
ok, let's try to hit the API manually and see what it returns: if you go to /api/data_sources, you will get a list of your data sources. find the id of the Redshift one, and then open /api/data_sources/{id}/schema to see if it returns the schema
also, is it possible the query to get the schema is in Redshift's queue or something?
Cory
@clevinson
Jun 09 2015 17:43
works!
i just had to clear my cache ;)
Arik Fraimovich
@arikfr
Jun 09 2015 17:43
great :)
that what I thought at first, but I thought that if you see the new logo, then it should be ok...
btw, some time ago Bruno was asking about an issue you had with stuck queries -- did you guys got it resolved?
Cory
@clevinson
Jun 09 2015 17:47
@arikfr yes i believe we did
Arik Fraimovich
@arikfr
Jun 09 2015 17:47
@clevinson do you remember what it was?
Cory
@clevinson
Jun 09 2015 17:48
@arikfr i can ask him tomorrow
@arikfr also, we have quite a huge schema (lotssss of tables w/ lots of columns) and the search functionality is causing some performance issues on the frontent
Arik Fraimovich
@arikfr
Jun 09 2015 17:49
@clevinson I will appreciate that. Always happy to hear about "debug" stories, to be able to help others.
Cory
@clevinson
Jun 09 2015 17:49
(ie. slow scrolling, hard to load, etc)
Arik Fraimovich
@arikfr
Jun 09 2015 17:49
@clevinson can you send me numbers? (# of tables/columns) so I can try to reproduce and imrpove
I think there might be an easy fix for this, but prefer to test it
If you can send me an "annonymized" schema, where you replace table/columns names w/ random string/numebr it will be even better.
Cory
@clevinson
Jun 09 2015 17:58
yep
Arik Fraimovich
@arikfr
Jun 09 2015 18:01
@clevinson great. you can send here or via email (arik@arikfr.com). thanks
Cory
@clevinson
Jun 09 2015 18:02
@arikfr just emailed you
770 tables with an average of 16 columns each
hows that for stress testing ;)
Arik Fraimovich
@arikfr
Jun 09 2015 18:10
@clevinson and I thought we have too many tables (probably no more than 100)
:-)