Python - pymysql.err.Error: Already closed

Dobrý den,

po updatu verze Python se při práci s pymysql často objevuje chyba pymysql.err.InterfaceError: (0, '')

Použivám v celém skriptu volání jednoho připojení con takto:
con = mysql.connect(**config)
a pak už všude volám jen
with con:

Celá chyba:

Traceback (most recent call last):
File "/var/script45.py", line 387, in fillerLoop
cur.execute(sql)
File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 547, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 793, in _execute_command
raise err.InterfaceError(0, "")
pymysql.err.InterfaceError: (0, '')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/script45.py", line 391, in fillerLoop
print("-----------")
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 360, in __exit__
self.close()
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 404, in close
raise err.Error("Already closed")
pymysql.err.Error: Already closed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/script45.py", line 423, in
object.fillerLoop()
File "/var/script45.py", line 408, in fillerLoop
sys.exit("Program ukoncen!")
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 360, in __exit__
self.close()
File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 404, in close
raise err.Error("Already closed")

Díky

ODPOVĚĎ

Dobrý den,

tak je třeba všude volat před použítím with con i nové spojení pomocí con:

con = mysql.connect(**config)
with con:
xxxxxxxx

Show english version