MySQL Forums
Forum List  »  Connector/Python

Not all records - EOF deprecation / protocol.py
Posted by: Mark Simon
Date: April 21, 2023 06:57AM

On larger queries - not all of the records are making it to my .fetchall() statement.

I've tracked it down to a potential issues within protocol.py, where a deprecated EOF is being detected, which stops reading in retrieved records.

I've had to comment out this section of code, and it seems to have solved my issue. Is this a bug, or a known incompatibility?

MySQL: /usr/sbin/mysqld (mysqld 5.7.41-0ubuntu0.18.04.1)
Python 3.9.5
MySQL Connector: mysql_connector-2.2.9-py3.9.egg-info

mysql/connector/protocol.py
Line 337-340
#elif eof57 and (packet[4] == 0 and packet[0] > 9):
# EOF deprecation: make sure we catch it whether flag is set or not
#eof = self.parse_ok(packet)
#rowdata = None

Options: ReplyQuote


Subject
Written By
Posted
Not all records - EOF deprecation / protocol.py
April 21, 2023 06:57AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.