MySQL Forums
Forum List  »  Connector/Python

Python connector requires reconnecting if an unbuffered cursor is not read completely
Posted by: Rami Kanhouche
Date: August 10, 2021 09:24AM

When trying to close the cursor and reuse the connection, always getting error "Unread result found.".

As far I have found, there is no way on earth to keep the connection -or even reuse it in a connection pool- if it got an unbuffered cursor (created using MySQLConnection.cursor() Method with buffered = False argument) which has not been completely fetched.

If this was the case it is real miss-conception and serious performance issue using Python connector for MySQL.

Options: ReplyQuote


Subject
Written By
Posted
Python connector requires reconnecting if an unbuffered cursor is not read completely
August 10, 2021 09:24AM


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.