pymysql.err.InterfaceError after some hours of usage
Νίκος Βέργος
vergos.nikolas at gmail.com
Wed Oct 2 01:11:38 EDT 2019
Hello, i use 'module pymysql' for connectivity in my wsgi scripts. For some reason after some hours of i.e. 'http://superhost.gr/files' i get the following error when the script tries to run:
Do you know why this is happening?!
Error: 500 Internal Server Error
Sorry, the requested URL 'http://superhost.gr/files/' caused an error:
Internal Server Error
Exception:
InterfaceError("(0, '')",)
Traceback:
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/bottle.py", line 862, in _handle
return route.call(**args)
File "/usr/lib/python3.6/site-packages/bottle.py", line 1740, in wrapper
rv = callback(*a, **ka)
File "/home/nikos/wsgi/files.py", line 143, in displayall
convert()
File "/home/nikos/wsgi/files.py", line 93, in convert
cur.execute('''SELECT file FROM files''')
File "/usr/lib64/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/lib64/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/lib64/python3.6/site-packages/pymysql/connections.py", line 516, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/usr/lib64/python3.6/site-packages/pymysql/connections.py", line 750, in _execute_command
raise err.InterfaceError("(0, '')")
pymysql.err.InterfaceError: (0, '')
I only use this opening statement in the beginning of my scripts.
conn = pymysql.connect( host='localhost', user='user', password='pass', db='counters' )
cur = conn.cursor()
Then i execute insert and update sql statements but i never close the connection. I presume python closes the connection when the script ends. Doesn't it?
More information about the Python-list
mailing list