数据库初始化失败:

[yuanxiaodong79]

2026-03-23 12:59:04.644 | ERROR | MindSpider.main:initialize_database:163 - 数据库初始化失败: Traceback (most recent call last):
File "/root/BettaFish/MindSpider/schema/init_database.py", line 118, in
asyncio.run(main())
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/runners.py", line 190, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 654, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/root/BettaFish/MindSpider/schema/init_database.py", line 106, in main
async with engine.begin() as conn:
File "/root/miniconda3/envs/bettafish/lib/python3.11/contextlib.py", line 210, in aenter
return await anext(self.gen)
^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/engine.py", line 1063, in begin
async with conn:
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/base.py", line 121, in aenter
return await self.start(is_ctxmanager=True)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/engine.py", line 273, in start
await greenlet_spawn(self.sync_engine.connect)
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn
result = context.throw(*sys.exc_info())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3278, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 146, in init
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3302, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 179, in _do_get
with util.safe_reraise():
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 674, in init
self.__connect()
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
with util.safe_reraise():
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 953, in connect
await_only(creator_fn(*arg, **kw)),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/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 "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connection.py", line 2329, in connect
return await connect_utils._connect(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 1017, in _connect
raise last_error or exceptions.TargetServerAttributeNotMatched(
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 991, in _connect
conn = await _connect_addr(
^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 828, in _connect_addr
return await __connect_addr(params, True, *args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 873, in __connect_addr
tr, pr = await connector
^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 744, in _create_ssl_connection
tr, pr = await loop.create_connection(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 1086, in create_connection
raise exceptions[0]
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 1070, in create_connection
sock = await self._connect_sock(
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 974, in _connect_sock
await self.sock_connect(sock, address)
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/selector_events.py", line 638, in sock_connect
return await fut
^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/selector_events.py", line 678, in _sock_connect_cb
raise OSError(err, f'Connect call failed {address}')
ConnectionRefusedError: [Errno 111] Connect call failed ('127.0.0.1', 3306)

2026-03-23 12:59:04.644 | ERROR | main:initialize_system_components:277 - 数据库初始化失败

[dosubot]

这个错误是由于数据库配置不匹配导致的。错误显示程序尝试连接 127.0.0.1:3306（MySQL 默认端口），但使用的是 PostgreSQL 驱动（asyncpg）。

问题原因：config.py 的默认配置中 DB_DIALECT 默认为 postgresql，但 DB_PORT 默认为 3306，端口不匹配。

解决方法：

1. 检查你的 .env 文件，确保配置正确（参考 .env.example）：

DB_HOST=127.0.0.1
DB_PORT=5432  # PostgreSQL 端口，不是 3306
DB_USER=your_db_user
DB_PASSWORD=your_db_password
DB_NAME=your_db_name
DB_DIALECT=postgresql

2. 确保 PostgreSQL 服务已启动并监听 5432 端口

3. 数据库需要提前手动创建：

psql -U postgres
CREATE DATABASE your_db_name;

如果你使用 Docker 部署，DB_HOST 需要改为 db（docker-compose.yml 中的服务名）。

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

  

[yuanxiaodong79]

File "/root/miniconda3/envs/bettafish/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 744, in _create_ssl_connection
tr, pr = await loop.create_connection(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 1086, in create_connection
raise exceptions[0]
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 1070, in create_connection
sock = await self._connect_sock(
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/base_events.py", line 974, in _connect_sock
await self.sock_connect(sock, address)
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/selector_events.py", line 638, in sock_connect
return await fut
^^^^^^^^^
File "/root/miniconda3/envs/bettafish/lib/python3.11/asyncio/selector_events.py", line 678, in _sock_connect_cb
raise OSError(err, f'Connect call failed {address}')
ConnectionRefusedError: [Errno 111] Connect call failed ('127.0.0.1', 5432)

[dosubot]

现在端口已经正确改为 5432 了，但 ConnectionRefusedError 错误表明 PostgreSQL 服务未在 127.0.0.1:5432 上运行或无法接受连接。

请检查以下几点：

1. 确认 PostgreSQL 服务已启动：

# Linux
sudo systemctl status postgresql
# 或
sudo service postgresql status

2. 如果使用 Docker 部署，需要将 DB_HOST 改为 db（docker-compose.yml 中的服务名），而不是 127.0.0.1：

DB_HOST=db

3. 如果是本地安装的 PostgreSQL，确保它监听正确的地址和端口：

# 检查 PostgreSQL 是否监听 5432 端口
sudo netstat -tlnp | grep 5432
# 或
ss -tlnp | grep 5432

4. 启动 PostgreSQL 服务（如果未运行）：

sudo systemctl start postgresql

你是本地部署还是 Docker 部署？

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

  

[yuanxiaodong79]

@dpsu ，租用Autodl云服务器