cscainiao commented on issue #7401: Sometimes the following error occurs 
(sqlalchemy.exc.NoSuchColumnError)
URL: 
https://github.com/apache/incubator-superset/issues/7401#issuecomment-487439578
 
 
   Sorry, something went wrong
   500 - Internal Server Error
   Stacktrace
            Traceback (most recent call last):
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/app.py", line 
2292, in wsgi_app
       response = self.full_dispatch_request()
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/app.py", line 
1815, in full_dispatch_request
       rv = self.handle_user_exception(e)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/app.py", line 
1718, in handle_user_exception
       reraise(exc_type, exc_value, tb)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/_compat.py", 
line 35, in reraise
       raise value
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/app.py", line 
1813, in full_dispatch_request
       rv = self.dispatch_request()
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask/app.py", line 
1799, in dispatch_request
       return self.view_functions[rule.endpoint](**req.view_args)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask_appbuilder/security/decorators.py",
 line 25, in wraps
       if self.appbuilder.sm.has_access(permission_str, 
self.__class__.__name__):
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/flask_appbuilder/security/manager.py",
 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/manager.py",
 line 878, in _has_view_access
       roles = user.roles
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/werkzeug/local.py", 
line 347, in __getattr__
       return getattr(self._get_current_object(), name)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py",
 line 276, in __get__
       return self.impl.get(instance_state(instance), dict_)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py",
 line 682, in get
       value = self.callable_(state, passive)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/strategies.py",
 line 723, in _load_for_state
       session, state, primary_key_identity, passive
     File "<string>", line 1, in <lambda>
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/strategies.py",
 line 865, in _emit_lazyload
       .with_post_criteria(set_default_params)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/ext/baked.py",
 line 531, in all
       return list(self)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/loading.py",
 line 105, in instances
       util.raise_from_cause(err)
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/util/compat.py",
 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/compat.py",
 line 129, in reraise
       raise value
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/loading.py",
 line 85, in instances
       rows = [proc(row) for row in fetch]
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/loading.py",
 line 85, in <listcomp>
       rows = [proc(row) for row in fetch]
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/loading.py",
 line 508, in _instance
       tuple([row[column] for column in pk_cols]),
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/orm/loading.py",
 line 508, in <listcomp>
       tuple([row[column] for column in pk_cols]),
     File 
"/root/superset/superset_env/lib/python3.7/site-packages/sqlalchemy/engine/result.py",
 line 629, in _key_fallback
       % expression._string_or_unprintable(key)
   sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 
'ab_role.id'"

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to