在用pymysql时遇到报错:
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 419, in commit
self._execute_command(COMMAND.COM_QUERY, "COMMIT")
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 750, in _execute_command
raise err.InterfaceError("(0, '')")
pymysql.err.InterfaceError: (0, '')
网上查找资料后说是因为这个数据库的连接建立太久了,会自动断开,需要重新建立数据库的连接。
解决方法1:每隔1小时左右重新建立连接
解决方法2:每次cur.execute前先ping一下,如果没ping通,那么自动重连:
conn.ping(reconnect=True)