Issue Summary
When I visit Create Query Page, I see the following message in all self hosted redash application,
It seems like we encountered an error. Try refreshing this page or contact your administrator.
No manual update has been performed on those instances and they were running till 4 Dec, 2020.
Endpoint: https://{my-domain}/queries/new
Log
[2020-12-07 08:24:49,866] ERROR in app: Exception on /api/data_sources [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python2.7/site-packages/flask_restful/__init__.py", line 477, in wrapper
resp = resource(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask/views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "/app/redash/handlers/base.py", line 31, in dispatch_request
return super(BaseResource, self).dispatch_request(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask_restful/__init__.py", line 587, in dispatch_request
resp = meth(*args, **kwargs)
File "/app/redash/permissions.py", line 67, in decorated
return fn(*args, **kwargs)
File "/app/redash/handlers/data_sources.py", line 95, in get
for ds in data_sources:
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 98, in instances
util.raise_from_cause(err)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 79, in instances
rows = [proc(row) for row in fetch]
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 511, in _instance
loaded_instance, populate_existing, populators)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 611, in _populate_full
dict_[key] = getter(row)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py", line 1226, in process
return process_value(impl_processor(value), dialect)
File "/app/redash/models/types.py", line 28, in process_result_value
return ConfigurationContainer.from_json(super(EncryptedConfiguration, self).process_result_value(value, dialect))
File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 409, in process_result_value
decrypted_value = self.engine.decrypt(value)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 216, in decrypt
decrypted = self.fernet.decrypt(value)
File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 75, in decrypt
return self._decrypt_data(data, timestamp, ttl)
File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 119, in _decrypt_data
self._verify_signature(data)
File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 108, in _verify_signature
raise InvalidToken
InvalidToken
[2020-12-07 08:24:49,867][PID:29][INFO][metrics] method=GET path=/api/data_sources endpoint=data_sources status=500 content_type=application/json content_length=36 duration=13.16 query_count=5 query_duration=18.65
[2020-12-07 08:24:49,880][PID:44][INFO][metrics] method=GET path=/static/fonts/fontawesome-webfont.af7ae50.woff2 endpoint=static status=200 content_type=application/octet-stream content_length=77160 duration=0.51 query_count=2 query_duration=7.27
[2020-12-07 08:24:49,887][PID:34][INFO][metrics] method=GET path=/api/organization/status endpoint=redash_organization_status status=200 content_type=application/json content_length=98 duration=36.97 query_count=7 query_duration=17.98
[2020-12-07 08:24:50,086][PID:44][INFO][metrics] method=GET path=/static/fonts/Material-Design-Iconic-Font.a4d3112.woff2 endpoint=static status=200 content_type=application/octet-stream content_length=38384 duration=0.53 query_count=2 query_duration=4.70
[2020-12-07 08:24:50,092][PID:39][INFO][metrics] method=GET path=/static/images/redash_icon_small.png endpoint=static status=200 content_type=image/png content_length=6111 duration=0.56 query_count=2 query_duration=9.61
[2020-12-07 08:24:50,100][PID:34][INFO][metrics] method=GET path=/api/dashboards/favorites endpoint=dashboard_favorites status=200 content_type=application/json content_length=55 duration=29.01 query_count=4 query_duration=18.30
[2020-12-07 08:24:50,108][PID:29][INFO][metrics] method=GET path=/api/queries/favorites endpoint=query_favorites status=200 content_type=application/json content_length=55 duration=26.62 query_count=4 query_duration=22.50
Technical details:
- Redash Version: 8.0.0.b32245
- Browser/OS: Firefox/Ubuntu
- How did you install Redash:
docker containers in AWS EC2 instance
