pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 2

[hootie-hoo]

Describe the bug

Traceback:
site-packages/aiomysql/connection.py", line 75, in _connect\n await conn._connect()\n File "/python3.11/site-packages/aiomysql/connection.py", line 540, in _connect\n await self._request_authentication()\n File "/python3.11/site-packages/aiomysql/connection.py", line 844, in _request_authentication\n auth_packet = await self._read_packet()\n ^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/python3.11/site-packages/aiomysql/connection.py", line 629, in _read_packet\n raise InternalError(\npymysql.err.InternalError: Packet sequence number wrong - got 1 expected 2"}

I get this error a couple times a day and not sure why. Using this library in my api with pretty heavy traffic. Each requests opens a new connection to db like so:

async def connect_to_db():
      return await aiomysql.connect(host=host, user=user, password=password,
                                                db=database,
                                                port=port, autocommit=True)

Any ideas?

To Reproduce

Using python 3.11 and aiomysql 0.2.0

Expected behavior

Should not raise exception

Logs/tracebacks

Traceback:
site-packages/aiomysql/connection.py\", line 75, in _connect\n    await conn._connect()\n  File \"/python3.11/site-packages/aiomysql/connection.py\", line 540, in _connect\n    await self._request_authentication()\n  File \"/python3.11/site-packages/aiomysql/connection.py\", line 844, in _request_authentication\n    auth_packet = await self._read_packet()\n                  ^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/python3.11/site-packages/aiomysql/connection.py\", line 629, in _read_packet\n    raise InternalError(\npymysql.err.InternalError: Packet sequence number wrong - got 1 expected 2"}

Python Version

$ python --version
3.11

aiomysql Version

$ python -m pip show aiomysql
0.2.0

PyMySQL Version

$ python -m pip show PyMySQL
1.1.0

SQLAlchemy Version

$ python -m pip show sqlalchemy

OS

ubuntu

Database type and version

SELECT VERSION();
Aurora MySQL 8.0.32

Additional context

No response

Code of Conduct

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

[xiaoxinw]

please check the issue #971 , it seems the same, and I have made a pr to show the exact error.