[GitHub] [incubator-superset] pjk5 commented on issue #7143: Error intializing superset after installation

[GitBox <gi...@apache.org>]

pjk5 commented on issue #7143: Error intializing superset after installation
URL: https://github.com/apache/incubator-superset/issues/7143#issuecomment-535056747
 
 
   I got the same `no such table: user_attribute` error after proceeding to the admin after running `superset db upgrade`.
   
   For me the problem wasn't about the incompatible sqlalchemy version but a missing `SUPERSET_CONFIG_PATH` environment variable.
   
   I did not got an error while running the `superset db upgrade` command but only the response below:
   ```
   2019-09-25 11:19:11,722:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
   INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
   INFO  [alembic.runtime.migration] Will assume transactional DDL.
   ```
   
   It took me quite some time to notice the INFO message above that it was trying to insert the data to a SQLite database (which didn't ever exist nor was created by this command)  instead of my PostgreSQL database which remained empty. I would expect an error message to presented in such case.
   
   My Superset config file was in the project root where i run the commands. I was able to successfully run `superset init` and `superset run` commands even though the environment variable was not set. As such, I thought superset commands were able to run as long as there is the config file present. However it seems that this is not the case for `superset db upgrade` command.
   
   I'm running the 0.34.0 version of Superset.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org