Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[SQL Lab] - Can't run query from Postgres database, get stacktrace instead #3144

Closed
3 tasks done
kfk opened this issue Jul 16, 2017 · 4 comments
Closed
3 tasks done

Comments

@kfk
Copy link

kfk commented Jul 16, 2017

Make sure these boxes are checked before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if any
  • I have reproduced the issue with at least the latest released version of superset
  • I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.18.5

Expected results

Query Results

Actual results

<html> <body> <h1>Sorry, something went wrong</h1> <h3>500 - Internal Server Error</h3> <hr> <h2>Stacktrace</h2> <hr> <code> <pre> Traceback (most recent call last): File &#34;/root/env/local/lib/python2.7/site-packages/flask/app.py&#34;, line 1982, in wsgi_app response = self.full_dispatch_request() File &#34;/root/env/local/lib/python2.7/site-packages/flask/app.py&#34;, line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File &#34;/root/env/local/lib/python2.7/site-packages/flask/app.py&#34;, line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File &#34;/root/env/local/lib/python2.7/site-packages/flask/app.py&#34;, line 1612, in full_dispatch_request rv = self.dispatch_request() File &#34;/root/env/local/lib/python2.7/site-packages/flask/app.py&#34;, line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File &#34;/root/env/local/lib/python2.7/site-packages/flask_appbuilder/security/decorators.py&#34;, line 52, in wraps return f(self, *args, **kwargs) File &#34;/root/env/local/lib/python2.7/site-packages/superset/models/core.py&#34;, line 759, in wrapper value = f(*args, **kwargs) File &#34;/root/env/local/lib/python2.7/site-packages/superset/views/core.py&#34;, line 2055, in sql_json if data.get(&#39;status&#39;) == QueryStatus.FAILED: AttributeError: &#39;NoneType&#39; object has no attribute &#39;get&#39; </pre> </code> </body> </html>

Steps to reproduce

Connect to a Postgres database.
Create a query in SQL Lab.
Click "Run Query".

@mistercrunch
Copy link
Member

What does you SQLAlchemy URI look like?

@xrmx
Copy link
Contributor

xrmx commented Jul 17, 2017

I think i fixed this in #3111, but possibly the root issue is another one.

@kfk
Copy link
Author

kfk commented Jul 17, 2017

postgresql://postgres:XXXXXXXXXX@localhost/shopify_test

@mistercrunch
Copy link
Member

Notice: this issue has been closed because it has been inactive for 279 days. Feel free to comment and request for this issue to be reopened.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants