[GitHub] wfowlks opened a new issue #3542: OperationalError no such table dashboards

[gi...@git.apache.org]

wfowlks opened a new issue #3542: OperationalError no such table dashboards
URL: https://github.com/apache/incubator-superset/issues/3542
 
 
   - [*] 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.19.1
   
   ### Expected results
   After Logging in shows dashboards
   
   ### Actual results
   The correct results show when running server in debug mode:
   ` superset runserver -d `
   However when running as a server: ` superset runserver ` I get the following:
   <img width="1359" alt="screen shot 2017-09-27 at 3 11 31 pm" src="https://user-images.githubusercontent.com/7023176/30932716-5547f57c-a396-11e7-98a2-f5c20907d1b7.png">
   
   ```
   Exception on /dashboardmodelviewasync/api/read [GET]
   Traceback (most recent call last):
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask/app.py", line 1982, in wsgi_app
       response = self.full_dispatch_request()
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask/app.py", line 1614, in full_dispatch_request
       rv = self.handle_user_exception(e)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask/app.py", line 1517, in handle_user_exception
       reraise(exc_type, exc_value, tb)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
       rv = self.dispatch_request()
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
       return self.view_functions[rule.endpoint](**req.view_args)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask_appbuilder/security/decorators.py", line 52, in wraps
       return f(self, *args, **kwargs)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask_appbuilder/views.py", line 218, in api_read
       count, lst = self.datamodel.query(joined_filters, order_column, order_direction, page=page, page_size=page_size)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/flask_appbuilder/models/sqla/interface.py", line 111, in query
       count = query_count.scalar()
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2843, in scalar
       ret = self.one()
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2814, in one
       ret = self.one_or_none()
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2784, in one_or_none
       ret = list(self)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
       return self._execute_and_instances(context)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
       result = conn.execute(querycontext.statement, self._params)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
       return meth(self, multiparams, params)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
       return connection._execute_clauseelement(self, multiparams, params)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
       compiled_sql, distilled_params
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
       context)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
       exc_info
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
       reraise(type(exception), exception, tb=exc_tb, cause=cause)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
       context)
     File "/home/centos/supersets/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
       cursor.execute(statement, parameters)
   OperationalError: (sqlite3.OperationalError) no such table: dashboards [SQL: u'SELECT count(?) AS count_1 \nFROM dashboards'] [parameters: ('*',)]
   ```
   
   ### Steps to reproduce
   Fresh install on Centos: `CentOS Linux release 7.4.1708`
   Python version 2.7.5
   Follow steps in: [](https://superset.incubator.apache.org/installation.html#superset-installation-and-initialization)
   (Including the Load some data step)
   Set the db connection to a local sqlite3 db.
   In superset_config.py `SQLALCHEMY_DATABASE_URI = 'sqlite:////home/centos/superset/superset_meta.db '`
   
   Additionally the upgrade steps after the Load some Data step do not change the error.
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services