python, RuntimeError, asyncio, Falsk, aiomysql

main.py

from flask import Flask, render_template, request, jsonify
import asyncio, db

app = Flask(__name__)
app.config['SECRET_KEY'] = 'https://youtu.be/dQw4w9WgXcQ'

@app.route('/')
async def index():
    await db.cur.execute("SELECT 42;");
    r = await db.cur.fetchone()[-1]
    return r


if __name__ == '__main__':
    app.run( port = 8900)

db.py

import asyncio
import aiomysql

loop = asyncio.get_event_loop()

async def main():
    global conn, cur
    conn = await aiomysql.connect(host= "127.0.0.1",
                                  port=3306,
                                  user='root',
                                  password='root',
                                  db='g',
                                  loop=loop)
    cur = await conn.cursor()
#    await cur.close()
#    conn.close()

loop.run_until_complete(main())

3дpacтвyйте. Сервер запускается нормально, но если я перейду на http://localhost:8900/ то выходит это:

RuntimeError: Task <Task pending name='Task-2' coro=<AsyncToSync.main_wrap() running at /python3.10/site-packages/asgiref/sync.py:284> cb=[_run_until_complete_cb() at /python3.10/asyncio/base_events.py:184]> got Future <Future pending> attached to a different loop

Ответы (0 шт):