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

Sometimes the following error occurs (sqlalchemy.exc.NoSuchColumnError) #7401

cscainiao opened this issue Apr 29, 2019 · 3 comments


None yet
1 participant
Copy link

commented Apr 29, 2019

A clear and concise description of what the bug is.

Expected results

what you expected to happen.

Actual results

what actually happens.


If applicable, add screenshots to help explain your problem.

How to reproduce the bug

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error


(please complete the following information):

  • superset version: [e.g. v0.29, master, commit]
  • python version: python --version
  • node.js version: node -v
  • npm version: npm -v


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

Additional context

Add any other context about the problem here.

@issue-label-bot issue-label-bot bot added the #bug label Apr 29, 2019


This comment has been minimized.

Copy link

commented Apr 29, 2019

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.95. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.


This comment has been minimized.

Copy link
Contributor Author

commented Apr 29, 2019

in the master branch


This comment has been minimized.

Copy link
Contributor Author

commented Apr 29, 2019

Sorry, something went wrong
500 - Internal Server Error
Traceback (most recent call last):
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 35, in reraise
raise value
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/root/superset/superset_env/lib/python3.7/site-packages/flask/", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "/root/superset/superset_env/lib/python3.7/site-packages/flask_appbuilder/security/", line 25, in wraps
File "/root/superset/superset_env/lib/python3.7/site-packages/flask_appbuilder/security/", line 892, in has_access
return self._has_view_access(g.user, permission_name, view_name)
File "/root/superset/superset_env/lib/python3.7/site-packages/flask_appbuilder/security/", line 878, in has_view_access
roles = user.roles
File "/root/superset/superset_env/lib/python3.7/site-packages/werkzeug/", line 347, in getattr
return getattr(self.get_current_object(), name)
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 276, in get
return self.impl.get(instance_state(instance), dict
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 682, in get
value = self.callable
(state, passive)
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 723, in _load_for_state
session, state, primary_key_identity, passive
File "", line 1, in
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 865, in _emit_lazyload
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/ext/", line 531, in all
return list(self)
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 105, in instances
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/util/", line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/util/", line 129, in reraise
raise value
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 85, in instances
rows = [proc(row) for row in fetch]
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 85, in
rows = [proc(row) for row in fetch]
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 508, in _instance
tuple([row[column] for column in pk_cols]),
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/", line 508, in
tuple([row[column] for column in pk_cols]),
File "/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/engine/", line 629, in _key_fallback
% expression._string_or_unprintable(key)
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column ''"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.