aio-libs / aiomysql

aiomysql is a library for accessing a MySQL database from the asyncio
https://aiomysql.rtfd.io
MIT License
1.76k stars 257 forks source link

The program is blocked for unknown reasons, causing other protocols to fail to run #909

Open AndrewGPU opened 1 year ago

AndrewGPU commented 1 year ago

Describe the bug

Perform write operations, block all coroutines, happen occasionally, it seems that adding a timeout should work, but no parameters related to read_timeout and write_timeout can be found

To Reproduce

can't reproduce in fixed mode

Expected behavior

Execution timeout or Exception, does not affect other normal operations

Logs/tracebacks

bolck ,Nothing at all

Python Version

Python 3.10.9

aiomysql Version

Name: aiomysql
Version: 0.1.1
Summary: MySQL driver for asyncio.
Home-page: https://github.com/aio-libs/aiomysql
Author: Nikolay Novik
Author-email: nickolainovik@gmail.com
License: MIT

PyMySQL Version

Name: PyMySQL
Version: 1.0.2
Summary: Pure Python MySQL Driver
Home-page: https://github.com/PyMySQL/PyMySQL/
Author: yutaka.matsubara
Author-email: yutaka.matsubara@gmail.com
License: "MIT"

SQLAlchemy Version

Name: SQLAlchemy
Version: 1.4.46
Summary: Database Abstraction Library
Home-page: https://www.sqlalchemy.org
Author: Mike Bayer
Author-email: mike_mp@zzzcomputing.com
License: MIT
Location: /usr/

OS

ubuntu

Database type and version

SELECT VERSION();

Additional context

No response

Code of Conduct

562218352 commented 9 months ago

this situation happens in my project too. how to fix , any suggestion is appreciated ?