Unable to access Create Query Page. Encountered an error message is getting displayed

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

Welcome to the forum!

It looks like an issue with fetching the data sources for your instance. If you check the Data Sources tab in settings does everything look normal? Are you a member of a group that has Full Access to your data sources? Does this error happen for every visitor in Redash or just some of them?

Regarding the Data Source
The Data Sources tab is always on loading state and send 500 as response code in network tab.

Are you a member of a group that has Full Access to your data sources? - Yes I am the member and admin of the group that has full access to the data sources.

Does this error happen for every visitor in Redash or just some of them? - It’s happening for everyone.

That’s helpful. I wonder: did your secret key change? The error suggests that Redash isn’t able to decrypt the data source details that are saved to the database.