File size: 4,461 Bytes
ba98117
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
import asyncio
import logging
from contextlib import asynccontextmanager
from fastapi import FastAPI
from psycopg_pool import AsyncConnectionPool
from langgraph.checkpoint.postgres.aio import AsyncPostgresSaver

from app.core.config import settings
from app.core.nacos import nacos_manager
from app.core.database import engine, init_db
from app.core.mcp_initialization import setup_mcp_clients, connect_clients

logger = logging.getLogger(__name__)

# 定义一个全局集合,用来存放后台任务的引用,防止被 GC
background_tasks = set()


# 🔥 配置函数:禁用 Prepared Statements (解决 consuming input failed)
async def configure_conn(conn):
    conn.prepare_threshold = None


@asynccontextmanager
async def lifespan(app: FastAPI):
    # --- Startup Logic ---
    logger.info("Agent starting up...")

    # 1. 初始化业务数据库 (SQLAlchemy)
    try:
        logger.info("⚡ Initializing database tables...")
        await init_db()
        logger.info("✅ Database initialized successfully.")
    except Exception as e:
        logger.error(f"❌ Database initialization failed: {e}")
        # 建议抛出异常,数据库连不上服务启动也没意义
        raise e

    # 2. 🔥 初始化 LangGraph 专用连接池 (Psycopg)
    # 清洗 URI,确保它是标准的 postgresql:// 格式
    pg_uri = str(settings.DB_URI).replace("+asyncpg", "").replace("+psycopg", "")

    app.state.lg_pool = AsyncConnectionPool(
        conninfo=pg_uri,
        max_size=20,
        min_size=1,  # 保持最小连接数
        # ✅ 关键配置 A: 借出时检查连接健康度
        check=AsyncConnectionPool.check_connection,
        # ✅ 关键配置 B: 禁用预编译语句
        configure=configure_conn,
        # ✅ 关键配置 C: 强制连接 10分钟轮转
        max_lifetime=600,
        kwargs={
            "autocommit": True,
            "keepalives": 1,
            "keepalives_idle": 30,
            "keepalives_interval": 10,
            "keepalives_count": 5,
        },
    )
    await app.state.lg_pool.open()
    logger.info("✅ LangGraph Checkpoint Pool created.")

    # 3. 运行 Setup (确保表结构存在)
    try:
        async with app.state.lg_pool.connection() as conn:
            # 显式开启 autocommit (虽然 pool 已经设了,但保险起见)
            await conn.set_autocommit(True)
            logger.info("⚙️ Running LangGraph table setup...")
            checkpointer = AsyncPostgresSaver(conn)
            await checkpointer.setup()
            logger.info("✅ LangGraph tables setup complete.")
    except Exception as e:
        logger.warning(f"⚠️ LangGraph setup warning: {e}")

    # 4. 🔥 Nacos 连接与注册 (异步非阻塞重试)
    max_retries = 3
    for i in range(max_retries):
        try:
            # 注意:如果 nacos_manager.connect 是同步阻塞的,
            # 在高并发下建议放到 run_in_executor,但在启动阶段勉强可以接受
            nacos_manager.connect()
            nacos_manager.register_service()
            logger.info("✅ Nacos connected and service registered.")
            break
        except Exception as e:
            if i < max_retries - 1:
                logger.warning(
                    f"⚠️ Nacos connection failed, retrying in 2s ({i + 1}/{max_retries})..."
                )
                # ✅✅✅ 必须使用 await asyncio.sleep,不能用 time.sleep
                await asyncio.sleep(2)
            else:
                logger.error("❌ Nacos connection failed after retries.")
                # raise e # 根据需要决定是否终止启动

    # 5. Setup MCP Clients
    try:
        await setup_mcp_clients()
    except Exception as e:
        logger.error(f"❌ MCP Setup failed: {e}")

    # 6. 启动后台任务
    task = asyncio.create_task(connect_clients())
    background_tasks.add(task)
    task.add_done_callback(background_tasks.discard)

    yield

    # --- Shutdown Logic ---
    logger.info("Agent shutting down...")

    # 7. 资源清理
    try:
        nacos_manager.deregister_service()
    except Exception:
        pass

    # 关闭数据库
    await engine.dispose()  # 关闭 SQLAlchemy
    await app.state.lg_pool.close()  # 关闭 LangGraph Pool
    logger.info("✅ Database resources released.")