I went to log onto my Redash Account today and I got a “Internal Server Error” showing the following screen. I am not sure what is causing this. Is it possible we ran out of queries and overloaded the server?

Just to chech your logs.

Hi Support,
I am also facing similar issue. While trying to login to redash for account creation, i am getting 500 error.
Can you please tell us what we are missing here?

Logs:

{“log”:“Traceback (most recent call last):\n”,“stream”:“stderr”,“time”:“2020-10-05T08:45:23.525993364Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1982, in wsgi_app\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.525996739Z”}
{“log”:" response = self.full_dispatch_request()\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.525999884Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1614, in full_dispatch_request\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526002845Z”}
{“log”:" rv = self.handle_user_exception(e)\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526005713Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask_restful/ init .py”, line 271, in error_router\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526008308Z”}
{“log”:" return original_handler(e)\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526021181Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1517, in handle_user_exception\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526023993Z”}
{“log”:" reraise(exc_type, exc_value, tb)\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.52602674Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1612, in full_dispatch_request\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526029559Z”}
{“log”:" rv = self.dispatch_request()\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526032407Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask/app.py”, line 1598, in dispatch_request\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526034996Z”}
{“log”:" return self.view_functionsrule.endpoint\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526037723Z”}
{“log”:" File “/app/redash/authentication/google_oauth.py”, line 77, in authorized\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526040367Z”}
{“log”:" resp = google_remote_app().authorized_response()\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526043209Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask_oauthlib/client.py”, line 707, in authorized_response\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526045956Z”}
{“log”:" data = self.handle_oauth2_response(args)\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526049122Z”}
{“log”:" File “/usr/local/lib/python2.7/site-packages/flask_oauthlib/client.py”, line 692, in handle_oauth2_response\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526051717Z”}
{“log”:" type=‘invalid_response’, data=data\n",“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526054563Z”}
{“log”:“OAuthException: Invalid response from google\n”,“stream”:“stderr”,“time”:“2020-10-05T08:45:23.526057177Z”}

Maybe you didn’t to add .env file.

We have 800+ redash users and authentication happening through Google OAuth setup.

This issue has occurred for one specific user where we see error message in log as “OAuthException: Invalid response from google”.

If this issue is related to env settings, then every redash users should encounter with this same error, but this is not the case here.

Later we figured out that the issue with user’s login was due to user’s google profile picture large in size which didn’t allow the user to login/create account in redash while accessing redash via Google OAuth.

Thanks Guyu for replying to this case

1 Like

Thanks for posting your solution. This will definitely help others!