MySQL Forums
Forum List  »  Connector/Python

Cannot commit a read statement
Posted by: Xiang Zhang
Date: July 26, 2022 11:00AM

>>> import mysql.connector
>>> cnx = mysql.connector.connect(user="root")
>>> cur = cnx.cursor()
>>> cur.execute('select count(*) from test.test')
>>> cnx.commit()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/opt/homebrew/lib/python3.9/site-packages/mysql/connector/", line 1229, in commit
File "/opt/homebrew/lib/python3.9/site-packages/mysql/connector/", line 1247, in _execute_query
File "/opt/homebrew/lib/python3.9/site-packages/mysql/connector/", line 1455, in handle_unread_result
raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

commit a select statement always return a "Unread result found" error. Is this expected? Same code works well with mysqlclient and PyMySQL.

Options: ReplyQuote

Written By
Cannot commit a read statement
July 26, 2022 11:00AM

Sorry, you can't reply to this topic. It has been closed.

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.