[GitHub] annusri commented on issue #3709: Intall Superset same instance in different server

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

annusri commented on issue #3709: Intall Superset same instance in different server
URL: https://github.com/apache/incubator-superset/issues/3709#issuecomment-338825230
 
 
   @xrmx  - ok. so everything is in the superset.db.
   
   I'm getting the below error after following this steps.
   
   Here is what I did on the new server -
   
   # Install superset
   pip install superset
   
   # Create an admin user (you will be prompted to set username, first and last name before setting a password)
   fabmanager create-admin --app superset
   
   # Initialize the database
   superset db upgrade
   
   # Load some data to play with
   superset load_examples
   
   # Create default roles and permissions
   superset init
   
   ##########
   Here I copied the superset.db  and superset_config.py from Server A to Server B and started the superset server as below
   
   # Start the web server on port 8088, use -p to bind to another port
   superset runserver
   
   when I try to access the bashboard, got the below error
   OperationalError: (sqlite3.OperationalError) no such column: sql_metrics.warning_text [SQL: u'SELECT sql_metrics.created_on AS sql_metrics_created_on, sql_metrics.changed_on AS sql_metrics_changed_on, sql_metrics.id AS sql_metrics_id, sql_metrics.metric_name AS sql_metrics_metric_name, sql_metrics.verbose_name AS sql_metrics_verbose_name, sql_metrics.metric_type AS sql_metrics_metric_type, sql_metrics.description AS sql_metrics_description, sql_metrics.is_restricted AS sql_metrics_is_restricted, sql_metrics.d3format AS sql_metrics_d3format, sql_metrics.warning_text AS sql_metrics_warning_text, sql_metrics.table_id AS sql_metrics_table_id, sql_metrics.expression AS sql_metrics_expression, sql_metrics.changed_by_fk AS sql_metrics_changed_by_fk, sql_metrics.created_by_fk AS sql_metrics_created_by_fk \nFROM sql_metrics \nWHERE ? = sql_metrics.table_id'] [parameters: (3,)]
   
    
   
   

----------------------------------------------------------------
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