sqlite3.OperationalError: no such table: tables

最新推荐文章于 2024-06-11 19:46:40 发布

m0_37759590

最新推荐文章于 2024-06-11 19:46:40 发布

阅读量849

点赞数

文章标签： sqlite flask python

本文链接：https://blog.csdn.net/m0_37759590/article/details/129627675

版权

superset init 時superset安裝失敗，報錯如下

Traceback (most recent call last):
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: tables

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

Traceback (most recent call last):
  File "/opt/module/miniconda3/envs/superset/bin/superset", line 8, in <module>
    sys.exit(superset())
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 1130, in __call__
    return self.main(*args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/flask/cli.py", line 601, in main
    return super().main(*args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 1055, in main
    rv = self.invoke(ctx)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/flask/cli.py", line 445, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/flask/cli.py", line 445, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/superset/cli/main.py", line 62, in init
    security_manager.sync_role_definitions()
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/superset/security/manager.py", line 731, in sync_role_definitions
    self.create_missing_perms()
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/superset/security/manager.py", line 677, in create_missing_perms
    datasources = ConnectorRegistry.get_all_datasources(self.get_session)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/superset/connectors/connector_registry.py", line 74, in get_all_datasources
    datasources.extend(qry.all())
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3373, in all
    return list(self)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/opt/module/miniconda3/envs/superset/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: tables