查詢期間與MySQL服務(wù)器的連接丟失我有一個巨大的表，我需要處理其中的所有行。我總是得到這個丟失的連接消息，我無法重新連接并將光標恢復(fù)到它的最后位置。這基本上就是我在這里的代碼：#import MySQLdbclass DB:
conn = None
def connect(self):
self.conn = MySQLdb.connect('hostname', 'user', '*****', 'some_table', cursorclass=MySQLdb.cursors.SSCursor)
def query(self, sql):
try:
cursor = self.conn.cursor()
cursor.execute(sql)
except (AttributeError, MySQLdb.OperationalError):
self.connect()
cursor = self.conn.cursor()
cursor.execute(sql)
return cursor##db = DB()sql = "SELECT bla FROM foo"data = db.query(sql)for row in data:
do_something(row)#但我總是得到這個：#Traceback (most recent call last):
File "teste.py", line 124, in <module>
run()
File "teste.py", line 109, in run for row in data:
File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 417, in next
row = self.fetchone()
File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 388, in fetchone
r = self._fetch_row(1)
File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 285, in _fetch_row return self._result.fetch_row(size, self._fetch_type)
_mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')
Exception _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') in <bound method SSCursor.__del__ of <MySQLdb.cursors.SSCursor object at 0x7f7e3c8da410>> ignored#你有什么主意嗎？
3 回答
HUWWW
TA貢獻1874條經(jīng)驗 獲得超12個贊
擴展mysql服務(wù)器的max_allowed_packet有三種方法：
更改mysql服務(wù)器計算機上的
max_allowed_packet=64M文件/etc/mysql/my.cnf并重新啟動服務(wù)器在mysql服務(wù)器上執(zhí)行sql：
set global max_allowed_packet=67108864;Python連接到mysql后執(zhí)行sql：
connection.execute（'set max_allowed_packet = 67108864'）
添加回答
舉報
0/150
提交
取消