Aiomysql query returns data from another query

[Vinc135]

Describe the bug

Hello. I have the same error as this guy from 2016:
#88

When two connections are creating at the same time and selecting a data from the database, the results are switching. Exactly like this guy from the other issue. I had the error at version 0.1.0 and then downgraded the version to 0.0.22 and now this error is already gone but sometimes it happens again. Pls help me

To Reproduce

Creating a pool and then creating two cursor in different files at the same time like with an event and selecting two datas from two different tables. Then fetch the results.

Expected behavior

I expect that I get the result I selected from the table.

Logs/tracebacks

I get the result from the other connection, which selected an other data from an other table.

Python Version

$ python --version
3.10.2

aiomysql Version

$ python -m pip show aiomysql
First 0.1.0 and after downgrading 0.0.22

PyMySQL Version

$ python -m pip show PyMySQL
0.9.3

SQLAlchemy Version

$ python -m pip show sqlalchemy

OS

I dont know on which OS my server runs.

Database type and version

SELECT VERSION();
('10.6.7-MariaDB-1:10.6.7+maria~bionic',)

Additional context

No response

Code of Conduct

• I agree to follow the aio-libs Code of Conduct

[Vinc135]

The error is back, but I am using 0.0.22

[Nothing4You]

Hi,

sorry for the late response.

If you're still experiencing this, can you provide a reproducible example?

Are you using multiple cursors from the same connection or are you using different connections?
Multiple cursors from the same connection are just pointing to the same data, see also #24.

[Vinc135]

Hello. No my friend helped me and the error is gone now

[rsking01]

Hello. No my friend helped me and the error is gone now

Hello, I faced the same problem. What helped you solve it?

[yujiacheng12138]

你好。不，我的朋友帮助了我，错误现在消失了

Hello. No my friend helped me and the error is gone now

Hello, I faced the same problem，How was it resolved?

[yujiacheng12138]

@Vinc135 help!!!