我正在将Apache超级集从0.36.0升级到1.0.0，升级之后我遇到了错误，我使用的是外部数据库

Question

我正在将Apache从0.36.0升级到1.0.0，在k3s Kubernetes集群上，升级后将面临下面指定的错误。我使用外部postgresql数据库连接到超级集。有人能告诉我什么是问题吗?如何将旧的仪表板和所有的东西迁移到新的升级版本.

我在docker文件中使用这些规范。

psycopg2-binary==2.8.6
redis==3.5.3
flower==0.9.7
pybigquery==0.5.0
pymysql==1.0.2
mysqlclient==2.0.3
apache-superset==1.0.1
gunicorn[gevent]==20.0.4
Werkzeug==0.16.0
Pillow==2.2.2

斯塔克迹

    Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column dashboards.uuid does not exist
LINE 1: SELECT dashboards.uuid AS dashboards_uuid, dashboards.create...
               ^
HINT:  Perhaps you meant to reference the column "dashboards.id".


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/superset/utils/log.py", line 162, in wrapper
    value = f(*args, add_extra_log_payload=log, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/superset/views/core.py", line 1803, in dashboard
    dash = qry.one_or_none()
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none
    ret = list(self)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column dashboards.uuid does not exist
LINE 1: SELECT dashboards.uuid AS dashboards_uuid, dashboards.create...
               ^
HINT:  Perhaps you meant to reference the column "dashboards.id".

[SQL: SELECT dashboards.uuid AS dashboards_uuid, dashboards.created_on AS dashboards_created_on, dashboards.changed_on AS dashboards_changed_on, dashboards.id AS dashboards_id, dashboards.dashboard_title AS dashboards_dashboard_title, dashboards.position_json AS dashboards_position_json, dashboards.description AS dashboards_description, dashboards.css AS dashboards_css, dashboards.json_metadata AS dashboards_json_metadata, dashboards.slug AS dashboards_slug, dashboards.published AS dashboards_published, dashboards.created_by_fk AS dashboards_created_by_fk, dashboards.changed_by_fk AS dashboards_changed_by_fk 
FROM dashboards 
WHERE dashboards.id = %(id_1)s]
[parameters: {'id_1': 1}]
(Background on this error at: http://sqlalche.me/e/13/f405)

Answer 1

谢谢，伙计们，superset db downgrade and superset db upgrade干得不错

Answer 2

看起来，您可能还没有运行数据库迁移作为升级的一部分。

superset db upgrade是命令，这里有更多信息：https://superset.apache.org/docs/installation/upgrading-superset

Answer 3

你能试着跑：

superset db downgrade 18532d70ab98
superset db upgrade b56500de1855

这应该会重新运行UUID数据库迁移。检查dashboards.uuid是否存在，然后运行：

superset db upgrade