账号密码登录
微信安全登录
微信扫描二维码登录

登录后绑定QQ、微信即可实现信息互通

手机验证码登录
找回密码返回
邮箱找回 手机找回
注册账号返回
其他登录方式
分享
  • 收藏
    X
    superset数据初始化失败superset db upgrade
    • 2020-01-01 00:00
    • 10
    24
    0

    问题描述

    INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
    INFO  [alembic.runtime.migration] Will assume transactional DDL.
    INFO  [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents
    Traceback (most recent call last):
      File "/opt/venv/bin/superset", line 15, in <module>
        cli()
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 722, in __call__
        return self.main(*args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/flask/cli.py", line 380, in main
        return AppGroup.main(self, *args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 697, in main
        rv = self.invoke(ctx)
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
        return _process_result(sub_ctx.command.invoke(sub_ctx))
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
        return _process_result(sub_ctx.command.invoke(sub_ctx))
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 895, in invoke
        return ctx.invoke(self.callback, **ctx.params)
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 535, in invoke
        return callback(*args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/click/decorators.py", line 17, in new_func
        return f(get_current_context(), *args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/flask/cli.py", line 257, in decorator
        return __ctx.invoke(f, *args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/click/core.py", line 535, in invoke
        return callback(*args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade
        _upgrade(directory, revision, sql, tag, x_arg)
      File "/opt/venv/lib/python3.6/site-packages/flask_migrate/__init__.py", line 95, in wrapped
        f(*args, **kwargs)
      File "/opt/venv/lib/python3.6/site-packages/flask_migrate/__init__.py", line 280, in upgrade
        command.upgrade(config, revision, sql=sql, tag=tag)
      File "/opt/venv/lib/python3.6/site-packages/alembic/command.py", line 276, in upgrade
        script.run_env()
      File "/opt/venv/lib/python3.6/site-packages/alembic/script/base.py", line 475, in run_env
        util.load_python_file(self.dir, "env.py")
      File "/opt/venv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
        module = load_module_py(module_id, path)
      File "/opt/venv/lib/python3.6/site-packages/alembic/util/compat.py", line 156, in load_module_py
        spec.loader.exec_module(module)
      File "<frozen importlib._bootstrap_external>", line 678, in exec_module
      File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
      File "/opt/venv/lib/python3.6/site-packages/superset/migrations/env.py", line 100, in <module>
        run_migrations_online()
      File "/opt/venv/lib/python3.6/site-packages/superset/migrations/env.py", line 93, in run_migrations_online
        context.run_migrations()
      File "<string>", line 8, in run_migrations
      File "/opt/venv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 839, in run_migrations
        self.get_context().run_migrations(**kw)
      File "/opt/venv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 361, in run_migrations
        step.migration_fn(**kw)
      File "/opt/venv/lib/python3.6/site-packages/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 82, in upgrade
        replace('%%', '%')
      File "/opt/venv/lib/python3.6/site-packages/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 53, in replace
        .join(Table)
      File "/opt/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2235, in join
        from_joinpoint=from_joinpoint,
      File "<string>", line 2, in _join
      File "/opt/venv/lib/python3.6/site-packages/sqlalchemy/orm/base.py", line 220, in generate
        fn(self, *args[1:], **kw)
      File "/opt/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2414, in _join
        left, right, onclause, prop, create_aliases, outerjoin, full
      File "/opt/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2437, in _join_left_to_right
        ) = self._join_determine_implicit_left_side(left, right, onclause)
      File "/opt/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2568, in _join_determine_implicit_left_side
        "Can't determine which FROM clause to join "
    sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.

    这个怎么解决?希望大神指导一下。

    0
    打赏
    收藏
    点击回答
    您的回答被采纳后将获得:提问者悬赏的 10 元积分
        全部回答
    • 共 0 条
    • 捉鳖 普通会员 1楼
      502 Bad Gateway

      502 Bad Gateway


      nginx
    更多回答
    扫一扫访问手机版
    • 回到顶部
    • 回到顶部