[Bug]macos上主程序使用launch\desktop运行时SQLAlchemy存在兼容性问题

[hibiki233i]

What happened / 发生了什么

在macos上当主程序使用launch\desktop启动时，新建知识库等需要SQLAlchemy情景下，会产生兼容性报错

Reproduce / 如何复现？

在macos上当主程序使用launch\desktop启动时，新建知识库或其他需要使用SQLAlchemy的插件时

AstrBot version, deployment method (e.g., Windows Docker Desktop deployment), provider used, and messaging platform used. / AstrBot 版本、部署方式（如 Windows Docker Desktop 部署）、使用的提供商、使用的消息平台适配器

astrbot v4.23.1 v4.23.2 部署方式：astrbot-launcher v0.3.1 astrbot-desktop v4.23.2

OS

macOS

Logs / 报错日志

[v4.23.2] [routes.knowledge_base:444]: 创建知识库失败: No such event 'connect' for target '<sqlalchemy.pool.impl.AsyncAdaptedQueuePool object at 0x1358ef350>'
[2026-04-21 10:22:18.499] [Core] [ERRO] [v4.23.2] [routes.knowledge_base:445]: Traceback (most recent call last):
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/dashboard/routes/knowledge_base.py", line 425, in create_kb
kb_helper = await kb_manager.create_kb(
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/knowledge_base/kb_mgr.py", line 127, in create_kb
await kb_helper.initialize()
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/knowledge_base/kb_helper.py", line 140, in initialize
await self._ensure_vec_db()
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/knowledge_base/kb_helper.py", line 188, in _ensure_vec_db
await vec_db.initialize()
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/db/vec_db/faiss_impl/vec_db.py", line 37, in initialize
await self.document_storage.initialize()
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/db/vec_db/faiss_impl/document_storage.py", line 61, in initialize
await self.connect()
File "/Applications/AstrBot.app/Contents/Resources/backend/app/astrbot/core/db/vec_db/faiss_impl/document_storage.py", line 140, in connect
self.engine = create_async_engine(
^^^^^^^^^^^^^^^^^^^^
File "/Users/username/.astrbot/data/site-packages/sqlalchemy/ext/asyncio/engine.py", line 120, in create_async_engine
sync_engine = _create_engine(url, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 2, in create_engine
File "/Users/username/.astrbot/data/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
return fn(*args, **kwargs) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^
File "/Users/username/.astrbot/data/site-packages/sqlalchemy/engine/create.py", line 747, in create_engine
event.listen(pool, "connect", on_connect)
File "/Users/username/.astrbot/data/site-packages/sqlalchemy/event/api.py", line 121, in listen
_event_key(target, identifier, fn).listen(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/username/.astrbot/data/site-packages/sqlalchemy/event/api.py", line 34, in _event_key
raise exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: No such event 'connect' for target '<sqlalchemy.pool.impl.AsyncAdaptedQueuePool object at 0x1358ef350>'

Are you willing to submit a PR? / 你愿意提交 PR 吗？

• Yes!

Code of Conduct

• I have read and agree to abide by the project's Code of Conduct。

[dosubot]

Hi @hibiki233i! I'm Dosu and I’m helping the AstrBot team.

这个错误很可能是 SQLAlchemy 版本冲突 导致的。AstrBot 要求 sqlalchemy[asyncio]>=2.0.41 [1]，但 macOS 上 launcher/desktop 启动时可能加载了系统或用户目录中的旧版本 SQLAlchemy，导致异步连接池事件系统不兼容。这在 launcher 部署中是已知的 PATH 冲突问题 [2]。

排查建议：

1. 确认实际加载的 SQLAlchemy 版本——在 AstrBot 的 Python 环境中运行：

   python -c "import sqlalchemy; print(sqlalchemy.__version__, sqlalchemy.__file__)"

   确认版本 ≥ 2.0.41，且路径指向 AstrBot 打包的版本而非系统安装。

2. 确认 aiosqlite 已正确安装（要求 ≥ 0.21.0）[3]：

   python -c "import aiosqlite; print(aiosqlite.__version__)"

3. 如果确认是版本冲突——清理 ~/.astrbot/data/site-packages/ 下的旧版 SQLAlchemy，或在 Launcher 设置中启用"忽略外部 PATH"选项（v0.2.6+ 支持）[4]。

另外值得注意的是，出错的 document_storage.py 中 create_async_engine 的配置相比其他模块过于简略 [5]，缺少 connect_args、pool_pre_ping 等参数，这也可能加剧某些边界情况下的问题。如果你计划提交 PR，可以考虑统一这些配置。

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.