onbjerg / emel

:full_moon_with_face:
0 stars 0 forks source link

mySQL download fails #4

Open Deleetdk opened 9 years ago

Deleetdk commented 9 years ago

This bug didn't happen before.

Getting table stuff1cache_menu
Getting table rows for stuff1cache_menu
Got 641451 rows.
Getting table stuff1cache_page
Traceback (most recent call last):
  File "backup.py", line 101, in <module>
    cur.execute('SHOW CREATE TABLE `' + str(table) + '`;')
  File "C:\Anaconda\lib\site-packages\pymysql\cursors.py", line 146, in execute
    result = self._query(query)
  File "C:\Anaconda\lib\site-packages\pymysql\cursors.py", line 296, in _query
    conn.query(q)
  File "C:\Anaconda\lib\site-packages\pymysql\connections.py", line 781, in quer
y
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "C:\Anaconda\lib\site-packages\pymysql\connections.py", line 942, in _rea
d_query_result
    result.read()
  File "C:\Anaconda\lib\site-packages\pymysql\connections.py", line 1138, in rea
d
    first_packet = self.connection._read_packet()
  File "C:\Anaconda\lib\site-packages\pymysql\connections.py", line 895, in _rea
d_packet
    packet_header = self._read_bytes(4)
  File "C:\Anaconda\lib\site-packages\pymysql\connections.py", line 919, in _rea
d_bytes
    "Lost connection to MySQL server during query (%s)" % (e,))
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during que
ry ([Errno 10060] A connection attempt failed because the connected party did no
t properly respond after a period of time, or established connection failed beca
use connected host has failed to respond)')
Deleetdk commented 9 years ago

I tried running the script for openpsych.net. It did not hang on mySQL there.

onbjerg commented 9 years ago

Is this persistent or only sometimes? Looks like UE does a timeout for no reason

Deleetdk commented 9 years ago

It is persistent and stops at the same table every time I tried. I tried 3 times with a few hours in between. I checked UnoEuro server status at the same times. There were no recorded problems.

I will try again now.