search

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

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

Open hootie-hoo opened 3 months ago

hootie-hoo commented 3 months ago

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

xiaoxinw commented 1 month ago

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