问题可能是由于使用 aiomysql 异步连接池时，没有正确关闭某些异步对象。解决方法如下：

1. 在使用完 asyncio 事件后，确保使用 close() 方法关闭连接池。
2. 使用 with 语句包装连接池，确保异步对象正确关闭：

async with aiomysql.create_pool(host=host, port=port, user=user, password=password, db=db, loop=loop) as pool: async with pool.acquire() as conn: async with conn.cursor() as cursor: await cursor.execute(sql) result = await cursor.fetchone() return result

参考示例：

import asyncio import aiomysql

async def select_mysql(): host = 'localhost' port = 3306 user = 'root' password = 'root' db = 'test_db'

try:
    pool = await aiomysql.create_pool(
        host=host,
        port=port,
        user=user,
        password=password,
        db=db,
        loop=loop)
    async with pool.acquire() as conn:
        async with conn.cursor() as cursor:
            await cursor.execute("SELECT * from test_table")
            result = await cursor.fetchone()
            return result
    pool.close()
    await pool.wait_closed()

except Exception as e:
    print(e)

if name == 'main': loop = asyncio.get_event_loop() result = loop.run_until_complete(select_mysql()) print(result)