win10，python2.7，mysql-connector-python 报错 mysql.connector.errors.InternalError: Unread result found

Traceback (most recent call last):
  File "C:/Users/rHotD/Documents/Work/apollo_test_case_2/testcase/test_mysql.py", line 26, in <module>
    cur.close()
  File "C:\Program Files\Python2.7\lib\site-packages\mysql\connector\cursor.py", line 388, in close
    self._connection.handle_unread_result()
  File "C:\Program Files\Python2.7\lib\site-packages\mysql\connector\connection.py", line 1063, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

from mysql import connector

conn = connector.connect(
            host='xxx.xxx.xxx.xxx',
            port=3306,
            user='xxxxxxx',
            passwd='xxxxxxxxxx',
            db='xxxxxxxxxxxxxxxxx',
            charset='utf8'
            )

cur = conn.cursor()

message_sum = cur.execute("select * from xxxxxxxxxxx")

print(message_sum)

fiveD_upass_tuple = cur.fetchmany(message_sum)

# print(type(fiveD_upass_tuple))

# for fiveD_upass in fiveD_upass_tuple:
#     print(fiveD_upass)

cur.close()
conn.commit()
conn.close()

解决办法

cur = conn.cursor(buffered=True)

加上 buffered=True

即可

Python MySQL connector - unread result found when using fetchone