Internal Server Error has occured when i try to log in re:dash14.04

363 views
Skip to first unread message

공명

unread,
Jul 25, 2016, 2:05:12 AM7/25/16
to re:dash users
Dear All,

Firstly Thanks the good Product

I have some isuue when i try to login the re:dash.
i make a Instance by AMI which re:dash supported.
after that,  i can open the login page.

but i try to login admin/ admin
the Issue was occured like that

Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.


i don't know the reason and how to solve that.

Thanks.

=========================Error LOG===============================================
42 Traceback (most recent call last):
    43  File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
    44    cursor.execute(sql, params or ())
    45 ProgrammingError: relation "organizations" does not exist
    46 LINE 1: ...", "t1"."name", "t1"."slug", "t1"."settings" FROM "organizat...
    47                                                             ^
    48
    49 [2016-07-25 05:51:53,880][PID:1278][ERROR][redash] Exception on /login [POST]
    50 Traceback (most recent call last):
    51  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1817, in wsgi_app
    52    response = self.full_dispatch_request()
    53  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1477, in full_dispatch_request
    54    rv = self.handle_user_exception(e)
    55  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router
    56    return original_handler(e)
    57  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1381, in handle_user_exception
    58    reraise(exc_type, exc_value, tb)
    59  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1475, in full_dispatch_request
    60    rv = self.dispatch_request()
    61  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1461, in dispatch_request
    62    return self.view_functions[rule.endpoint](**req.view_args)
    63  File "/opt/redash/redash.0.10.1.b1834/redash/handlers/authentication.py", line 101, in login
    64    user = models.User.get_by_email_and_org(request.form['email'], current_org.id)
    65  File "/usr/local/lib/python2.7/dist-packages/werkzeug/local.py", line 343, in __getattr__
    66    return getattr(self._get_current_object(), name)
    67  File "/usr/local/lib/python2.7/dist-packages/werkzeug/local.py", line 302, in _get_current_object
    68    return self.__local()
    69  File "/opt/redash/redash.0.10.1.b1834/redash/authentication/org_resolving.py", line 18, in _get_current_org
    70    org = Organization.get_by_slug(slug)
    71  File "/opt/redash/redash.0.10.1.b1834/redash/models.py", line 190, in get_by_slug
    72    return cls.get(cls.slug == slug)
    73  File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 4012, in get
    74    return sq.get()
    75  File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2641, in get
    76    return clone.execute().next()
    77  File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2682, in execute
    78    self._qr = ResultWrapper(model_class, self._execute(), query_meta)
    79  File "/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py", line 50, in metered_execute
    80    result = real_execute(self, *args, **kwargs)
    81  File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2371, in _execute
    82    return self.database.execute_sql(sql, params, self.require_commit)
    83  File "/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py", line 22, in execute_sql
    84    result = super(MeteredPostgresqlExtDatabase, self).execute_sql(*args, **kwargs)
    85  File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 369, in execute_sql
    86    self.commit()
    87  File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2922, in __exit__
    88    reraise(new_type, new_type(*exc_value.args), traceback)
    89  File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
    90    cursor.execute(sql, params or ())
    91 ProgrammingError: relation "organizations" does not exist
    92 LINE 1: ...", "t1"."name", "t1"."slug", "t1"."settings" FROM "organizat...
    93                                                             ^
    94
    95 [2016-07-25 05:51:53,888][PID:1278][INFO][metrics] method=POST path=/login endpoint=redash.login status=500 content_type=? content_length=-1 duration=12.30 query_count=1 query_duration=0.70
    96 [2016-07-25 05:51:54,716][PID:1279][INFO][metrics] method=GET path=/favicon.ico endpoint=redash.send_static status=200 content_type=image/vnd.microsoft.icon content_length=1150 duration=2.59 query_count=0 query_duration=0.00
    97 [2016-07-25 05:51:54,716][PID:1279][INFO][metrics] method=GET path=/favicon.ico endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=2.91 query_count=0 query_duration=0.00
    98 [2016-07-25 05:52:29,248][PID:1279][INFO][metrics] method=GET path=/ endpoint=redash.index status=302 content_type=text/html; charset=utf-8 content_length=359 duration=2.79 query_count=0 query_duration=0.00
    99 [2016-07-25 05:52:29,249][PID:1279][INFO][metrics] method=GET path=/ endpoint=redash.index status=500 content_type=? content_length=-1 duration=3.34 query_count=0 query_duration=0.00
   100 [2016-07-25 05:52:29,868][PID:1279][INFO][metrics] method=GET path=/login endpoint=redash.login status=200 content_type=text/html; charset=utf-8 content_length=2048 duration=3.23 query_count=0 query_duration=0.00
   101 [2016-07-25 05:52:29,869][PID:1279][INFO][metrics] method=GET path=/login endpoint=redash.login status=500 content_type=? content_length=-1 duration=3.53 query_count=0 query_duration=0.00
   102 [2016-07-25 05:52:58,450][PID:1279][ERROR][peewee] SELECT "t1"."id", "t1"."updated_at", "t1"."created_at", "t1"."name", "t1"."slug", "t1"."settings" FROM "organizations" AS t1 WHERE ("t1"."slug" = %s) LIMIT 1 [u'default']
   103 Traceback (most recent call last):
   104  File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
   105    cursor.execute(sql, params or ())
   106 ProgrammingError: relation "organizations" does not exist
   107 LINE 1: ...", "t1"."name", "t1"."slug", "t1"."settings" FROM "organizat...
   108                                                             ^
   109

Grappler Grappler

unread,
Jul 26, 2016, 7:12:37 AM7/26/16
to re:dash users
I have exactly the  same problem, here the content of my api_error.log file (i don't copy the entire file it's too long but at the end i have this) :

TypeError: __init__() got an unexpected keyword argument 'socket_connect_timeout'
[2016-07-26 11:43:16,276][PID:2423][INFO][metrics] method=POST path=/login endpoint=login status=500 content_type=? content_length=-1 duration=492.46 query_count=3 query_duration=364.90


Reply all
Reply to author
Forward
0 new messages