superset-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maxime Beauchemin <maximebeauche...@gmail.com>
Subject Re: Can't restart after update
Date Tue, 11 Jul 2017 04:23:03 GMT
Did you follow the upgrade instructions and run the db migrations?
http://superset.apache.org/installation.html#upgrading

Max

On Mon, Jul 10, 2017 at 9:16 PM, Jerry Hall, PourSafe <Jerry@poursafe.com>
wrote:

> I did an update today from .17 to .18.5. I can login and see my dashboard
> options but, when trying to access anything I get broken pages. This is the
> message. Does this mean I have to declare my DB path? If so it's located at
> /ec2-user/.superset/superset.db but, if I try to use that in config.py it
> doesn't work.
>
> The message I'm getting is:
> OperationalError: (pysqlite2.dbapi2.OperationalError) no such column:
> tables.fetch_values_predicate [SQL: u'SELECT tables.created_on AS
> tables_created_on, tables.changed_on AS tables_changed_on, tables.id AS
> tables_id, tables.description AS tables_description,
> tables.default_endpoint AS tables_default_endpoint, tables.is_featured AS
> tables_is_featured, tables.filter_select_enabled AS
> tables_filter_select_enabled, tables."offset" AS tables_offset,
> tables.cache_timeout AS tables_cache_timeout, tables.params AS
> tables_params, tables.perm AS tables_perm, tables.table_name AS
> tables_table_name, tables.main_dttm_col AS tables_main_dttm_col,
> tables.database_id AS tables_database_id, tables.fetch_values_predicate AS
> tables_fetch_values_predicate, tables.user_id AS tables_user_id,
> tables.schema AS tables_schema, tables.sql AS tables_sql,
> tables.changed_by_fk AS tables_changed_by_fk, tables.created_by_fk AS
> tables_created_by_fk \nFROM tables \nWHERE tables.id = ?\n LIMIT ? OFFSET
> ?'] [parameters: (9, 1, 0)]
>
> ​I'm also unclear as when I run 'pkill gunicorn' to stop any processes and
> then 'superset runserver'​ my console appears to stay active which I'm not
> sure is normal behavior? If I CTL+Z it breaks back to the user prompt.
>
> ​Thanks for any help!​
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message