These are chat archives for getredash/redash

15th
Jul 2016
zachvanduyn
@zachvanduyn
Jul 15 2016 13:30
@arikfr - What's the best way to backup all of my work that I've done in ReDash?
Antoine Augusti
@AntoineAugusti
Jul 15 2016 13:34
@zachvanduyn Sounds like you want to setup automatic DB dumps http://docs.redash.io/en/latest/usage/maintenance.html#backup-re-dash-s-db
zachvanduyn
@zachvanduyn
Jul 15 2016 14:21
@AntoineAugusti - Thank you! That's what I needed.
leoliu1994
@leoliu1994
Jul 15 2016 17:24
@arikfr I set up redash on an EC2 instance. It worked before today, but I got a 502 BadGate today. Any idea why that would happen?
Arik Fraimovich
@arikfr
Jul 15 2016 17:24
@leoliu1994 did you check the logs?
@torbjornvatn need to check their developer reference, to see what we need to pass in the API call to enable the Standard SQL syntax. Feel free to log an issue on GitHub, to look into this.
@torbjornvatn what kind of query? Redash doesn't "care" about the dataset size (and 24GB isn't that big). What's important is the result set size. A really large result set might cause some hangs.
@torbjornvatn re. upgrade process - yes.
leoliu1994
@leoliu1994
Jul 15 2016 17:29
Can't ssh into the instance right now
will try to check it later
leoliu1994
@leoliu1994
Jul 15 2016 18:27
I got this error: redash_celery_scheduled (terminated by SIGSEGV; not expected)
INFO spawnerr: unknown error: ENOMEM
@arikfr
leoliu1994
@leoliu1994
Jul 15 2016 18:36
and this INFO exited: redash_celery (terminated by SIGSEGV (core dumped); not expected)
leoliu1994
@leoliu1994
Jul 15 2016 20:45
in api_error.log, the err msg is:
[ERROR][redash] Exception on /favicon.ico [GET] Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router return original_handler(e) File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1473, in full_dispatch_request rv = self.preprocess_request() File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1666, in preprocess_request rv = func() File "/opt/redash/redash.0.10.1.b1834/redash/models.py", line 41, in connect_db self.database.connect() File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 3004, in connect self.initialize_connection(self.__local.conn) File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2922, in __exit__ reraise(new_type, new_type(*exc_value.args), traceback) File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 3002, in connect **self.connect_kwargs) File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 373, in _connect conn = super(PostgresqlExtDatabase, self)._connect(database, **kwargs) File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 3316, in _connect conn = psycopg2.connect(database=database, **kwargs) File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) OperationalError: FATAL: role "root" does not exist
Travis Theune
@ttheune
Jul 15 2016 21:21

@arikfr Trying to do an upgrade and see this error:

Fatal error: run() received nonzero return code 1 while executing!

Requested: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0016_add_alert_subscriber.py
Executed: /bin/bash -l -c "cd /opt/redash/redash.0.11.0.b2016 >/dev/null && sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0016_add_alert_subscriber.py"

Aborting.
Disconnecting from localhost... done.