postgresql - 在 ubuntu 20.04 在 web 模式下运行 pgadmin 时出错
问题描述
在 ubuntu 20.04 中以 Web 模式运行 pgadmin 时出错
当我在 ubuntu 终端上运行以在 web 模式下运行 pg admin 时,
sudo /usr/pgadmin4/bin/setup-web.sh
这个命令。
我收到错误此错误见下文。这个错误的解决方案是什么?
Creating configuration database...
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: there is already another table or index with this name: user_old
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/pgadmin4/web/setup.py", line 506, in <module>
setup_db()
File "/usr/pgadmin4/web/setup.py", line 378, in setup_db
app = create_app()
File "/usr/pgadmin4/web/pgadmin/__init__.py", line 365, in create_app
db_upgrade(app)
File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask_migrate/__init__.py", line 96, in wrapped
f(*args, **kwargs)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/flask_migrate/__init__.py", line 271, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/command.py", line 294, in upgrade
script.run_env()
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/script/base.py", line 490, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file
module = load_module_py(module_id, path)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/util/compat.py", line 182, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 783, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 93, in <module>
run_migrations_online()
File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 86, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/runtime/environment.py", line 813, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/alembic/runtime/migration.py", line 560, in run_migrations
step.migration_fn(**kw)
File "/usr/pgadmin4/web/migrations/versions/7fedf8531802_.py", line 22, in upgrade
db.engine.execute("ALTER TABLE user RENAME TO user_old")
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2235, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1003, in execute
return self._execute_text(object_, multiparams, params)
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1172, in _execute_text
ret = self._execute_context(
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/pgadmin4/venv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) there is already another table or index with this name: user_old
[SQL: ALTER TABLE user RENAME TO user_old]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Error setting up server mode. Please examine the output above.
但我可以在桌面模式下运行运行 pgadmin。我也从桌面模式注销。
解决方案
推荐阅读
- node.js - Vue显示空白页面
- javascript - 错误:找不到绑定文件 better-sqlite3.node
- php - 查找数组中的重复元素
- python - 将 timedelta hh:mm 转换为秒
- scikit-learn - Sci-kit Learn Clustering 模型是否具有隐藏的全局状态?
- elm - init 函数的“Cmd Msg”是在什么时候传递的?
- html - 无法将下拉菜单与 angular2+ 中的下一行对齐
- java - 为什么java中的'char'原语是必要的?
- angular - 延迟加载(loadChild)返回空白页
- python - 说,send_message 和发送,在@bot 事件中不起作用怎么办?不和谐.py