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.
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