aio-libs / aio-libs/aiomysql

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

Offen
#988 1 Kommentar 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
bug
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

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.