bs-101 comments

Results 3 comments of


                                            bs-101

当请求被取消的时候，任务被CancelledError，但是连接没有被正确回收

是的，我也遇到了这个问题，我是使用sanic框架，并且使用了tortoise-orm==0.19.1,它默认优先使用asyncmy包，导致当客户端取消请求时，连接紊乱，当前的请求sql，拿到的是上个接口的sql查询结果，然后tortoise拿到数据去做映射，结果报keyerror Traceback (most recent call last): File "handle_request", line 83, in handle_request class Sanic(BaseSanic, metaclass=TouchUpMeta): File "/app/handler/ad_operation.py", line 180, in get_ad_config ad_config = await AdConfigService.get_ad_content_by_pkg_and_group_and_lang(pkg, group, lang, is_new_user) File "/app/bll/ad_operation.py",...

The user actively cancels the request, the task is canceled by CancelledError(), and the connection object or cursor recovery fails, causing the new SQL query to get the SQL result of the previous request.

@long2ice

The user actively cancels the request, the task is canceled by CancelledError(), and the connection object or cursor recovery fails, causing the new SQL query to get the SQL result of the previous request.

Okay, let me now use the simplest example to reproduce the problem Initialize the mysql connection pool in the before_server_start method in the sanic framework ``` app.pool = await asyncmy.create_pool(...