Redash intermittent 500error

Intermittently we get HTTP 500 due to below error.

{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py”, line 269, in _execute_on_connection\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850733333Z”}
{“log”:" return connection._execute_clauseelement(self, multiparams, params)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850739458Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1060, in _execute_clauseelement\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850745338Z”}
{“log”:" compiled_sql, distilled_params\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.85075148Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1200, in _execute_context\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850757416Z”}
{“log”:" context)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850763572Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1413, in _handle_dbapi_exception\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850769171Z”}
{“log”:" exc_info\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850775207Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py”, line 265, in raise_from_cause\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.85078089Z”}
{“log”:" reraise(type(exception), exception, tb=exc_tb, cause=cause)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850786984Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1193, in _execute_context\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.85079273Z”}
{“log”:" context)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.85079925Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py”, line 509, in do_execute\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850805317Z”}
{“log”:" cursor.execute(statement, parameters)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850811387Z”}
{“log”:“OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly\n”,“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850817177Z”}
{“log”:"\u0009This probably means the server terminated abnormally\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850828278Z”}
{“log”:"\u0009before or while processing the request.\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850834531Z”}
{“log”:" [SQL: ‘SELECT organizations.updated_at AS organizations_updated_at, organizations.created_at AS organizations_created_at, organizations.id AS organizations_id, organizations.name AS organizations_name, organizations.slug AS organizations_slug, organizations.settings AS organizations_settings \nFROM organizations \nWHERE organizations.slug = %(slug_1)s \n LIMIT %(param_1)s’] [parameters: {‘slug_1’: ‘default’, ‘param_1’: 1}] (Background on this error at: http://sqlalche.me/e/e3q8)\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850840924Z”}
{“log”:"[2020-02-06 10:10:10,850][PID:15][INFO][metrics] method=GET path=/login endpoint=redash_login status=500 content_type=? content_length=-1 duration=5.82 query_count=0 query_duration=0.00\n",“stream”:“stderr”,“time”:“2020-02-06T10:10:10.850851892Z”}

Technical details:

  • Redash Version: 8.0
  • Browser/OS: Chrome
  • How did you install Redash: docker-compose