bug：当存在相同表名时迁移失败

[Kaguya233qwq]

如题：

[mmmjie]

同样的问题,实际我在所有数据库中,都没找到这个表

09-29 03:43:11 [INFO] nonebot_plugin_morning | 每周晚安定时刷新任务已启动！
09-29 03:43:11 [INFO] nonebot_plugin_morning | 每周睡眠时间定时刷新任务已启动！
目标数据库未更新到最新迁移, 是否更新? [y/N]: y
09-29 03:43:13 [ERROR] uvicorn | Traceback (most recent call last):
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 545, in _prepare_and_execute
self._rows = deque(await prepared_stmt.fetch(*parameters))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/asyncpg/prepared_stmt.py", line 176, in fetch
data = await self.__bind_execute(args, 0, timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/asyncpg/prepared_stmt.py", line 267, in __bind_execute
data, status, _ = await self.__do_execute(
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/asyncpg/prepared_stmt.py", line 256, in __do_execute
return await executor(protocol)
^^^^^^^^^^^^^^^^^^^^^^^^
File "asyncpg/protocol/protocol.pyx", line 206, in bind_execute
asyncpg.exceptions.DuplicateTableError: relation "unique_session" already exists

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

Traceback (most recent call last):
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 580, in execute
self.adapt_connection.await(
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 558, in _prepare_and_execute
self._handle_exception(error)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 508, in _handle_exception
self._adapt_connection._handle_exception(error)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 792, in _handle_exception
raise translated_error from error
sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.ProgrammingError: <class 'asyncpg.exceptions.DuplicateTableError'>: relation "unique_session" already exists

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

Traceback (most recent call last):
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/starlette/routing.py", line 694, in lifespan
async with self.lifespan_context(app) as maybe_state:
File "/usr/local/lib/python3.11/contextlib.py", line 210, in aenter
return await anext(self.gen)
^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot/drivers/fastapi.py", line 154, in _lifespan_manager
await self._lifespan.startup()
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot/internal/driver/_lifespan.py", line 66, in startup
await self._run_lifespan_func(self._startup_funcs)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot/internal/driver/_lifespan.py", line 55, in _run_lifespan_func
await cast(ASYNC_LIFESPAN_FUNC, func)()
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot_plugin_orm/init.py", line 100, in init_orm
await greenlet_spawn(migrate.upgrade, alembic_config)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn
result = context.throw(*sys.exc_info())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot_plugin_orm/migrate.py", line 663, in upgrade
script.run_env()
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/script/base.py", line 549, in run_env
util.load_python_file(self.dir, "env.py")
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 116, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 136, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 940, in exec_module
File "", line 241, in _call_with_frames_removed
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot_plugin_orm/templates/generic/env.py", line 82, in
await_only(coro)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot_plugin_orm/templates/generic/env.py", line 71, in run_migrations_online
await connection.run_sync(do_run_migrations)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/engine.py", line 887, in run_sync
return await greenlet_spawn(
^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 203, in greenlet_spawn
result = context.switch(value)
^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/nonebot_plugin_orm/templates/generic/env.py", line 61, in do_run_migrations
context.run_migrations()
File "", line 8, in run_migrations
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/runtime/environment.py", line 946, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
step.migration_fn(**kw)
File "/tmp/tmpk938_fmb/nonebot_plugin_uninfo/14175fde8186_init_db.py", line 58, in upgrade
File "", line 8, in create_table
File "", line 3, in create_table
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/operations/ops.py", line 1332, in create_table
return operations.invoke(op)
^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/operations/base.py", line 441, in invoke
return fn(self, operation)
^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/operations/toimpl.py", line 135, in create_table
operations.impl.create_table(table, **kw)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/ddl/impl.py", line 423, in create_table
self._exec(schema.CreateTable(table, **kw))
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/alembic/ddl/impl.py", line 246, in _exec
return conn.execute(construct, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 187, in _execute_on_connection
return connection._execute_ddl(
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1530, in _execute_ddl
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 580, in execute
self.adapt_connection.await(
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 558, in _prepare_and_execute
self._handle_exception(error)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 508, in _handle_exception
self._adapt_connection._handle_exception(error)
File "/home/ubuntu/zhinai/zhinai/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 792, in _handle_exception
raise translated_error from error
sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.DuplicateTableError'>: relation "unique_session" already exists
[SQL:
CREATE TABLE nonebot_plugin_uninfo_sessionmodel (
id SERIAL NOT NULL,
bot_persist_id INTEGER NOT NULL,
scene_persist_id INTEGER NOT NULL,
user_persist_id INTEGER NOT NULL,
member_data JSON,
CONSTRAINT pk_nonebot_plugin_uninfo_sessionmodel PRIMARY KEY (id),
CONSTRAINT unique_session UNIQUE (bot_persist_id, scene_persist_id, user_persist_id)
)

]
(Background on this error at: https://sqlalche.me/e/20/f405)

09-29 03:43:13 [ERROR] uvicorn | Application startup failed. Exiting.
(zhinai) ubuntu@mjie:~/zhinai$

[JohnRichard4096]

你的数据库URL有配置嘛？