These are chat archives for getredash/redash

14th
Aug 2017
galgoogle
@galgoogle
Aug 14 2017 07:59
@arikfr I can't see the database explorer when using BigQuery. Can you help me with this issue?
galgoogle
@galgoogle
Aug 14 2017 08:07
@arikfr I see in the logs it's reading the tables and then stops at "[2017-08-14 07:59:24 +0000] [6064] [CRITICAL] WORKER TIMEOUT (pid:20384)"
Arik Fraimovich
@arikfr
Aug 14 2017 08:11
Maybe the schema is too large?
galgoogle
@galgoogle
Aug 14 2017 08:35
there are a few hundreds of tables
galgoogle
@galgoogle
Aug 14 2017 08:40
In BigQuery there's a Project--> Dataset --> Table. And the Schema is just the table structure (yes, very weird). Is there a way I can increase the timeout? I
The timeout is on Redash side or BigQuery side?
Arik Fraimovich
@arikfr
Aug 14 2017 08:42
This is the Gunicorn timeout.
galgoogle
@galgoogle
Aug 14 2017 08:57
In order to change the settings, I need the APP_MODULE. Do you know what is it?
galgoogle
@galgoogle
Aug 14 2017 09:04
Or you have another solution.
galgoogle
@galgoogle
Aug 14 2017 10:45
Ok, just went into /usr/local/lib/python2.7/dist-packages/gunicorn/config.py and changed the timeout parameter from 30 to 120. Restarted supervisor- and it worked.
Arik Fraimovich
@arikfr
Aug 14 2017 12:29
@galgoogle I believe you can pass the timeout as a command line parameter to the gunicorn command.
galgoogle
@galgoogle
Aug 14 2017 15:53
yes, you're right
Chip Oglesby
@chipoglesby
Aug 14 2017 17:40
@rahul-pande @arikfr I'm running into the same Issues. I believe it has something to do with how your Google Compute Engine VM and permissions are set up.
@arikfr the error I'm running into with BigQueryGCE is Error running query: global name 'gce' is not defined