pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 2
- Vorherrschende Sprache
- Python
- Sterne
- 1.9k
- Forks
- 272
- PR-Merge-Kennzahlen
- Keine gemergten PRs in 30 T.
Beschreibung
### 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
```python-traceback
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
```console
$ python --version
3.11
```
### aiomysql Version
```console
$ python -m pip show aiomysql
0.2.0
```
### PyMySQL Version
```console
$ python -m pip show PyMySQL
1.1.0
```
### SQLAlchemy Version
```console
$ python -m pip show sqlalchemy
```
### OS
ubuntu
### Database type and version
```console
SELECT VERSION();
Aurora MySQL 8.0.32
```
### Additional context
_No response_
### Code of Conduct
- [X] I agree to follow the aio-libs Code of Conduct
Beitragsleitfaden
Bewertung
Dieses Issue wurde noch nicht bewertet.