MySQL已经走了与pymysql
问题描述:
我在Python 3使用pymysql运行查询,像这样:MySQL已经走了与pymysql
conn = 'con info here'
cur = conn.cursor()
cu.execute('sql goes here')
查询去的线条之中:
load data
local infile 'file path'
ignore into table table_name
fields terminated by '/t'
optionally enclosed by '"'
lines terminated by '\r\n'
ignore 1 lines
(@col1,
@col2,
@col3)
set
(col1indb = @col1,
col2indb = @col2,
col3indb = @col3)
当我执行查询,我立即得到这个:
File "/opt/python3/lib/python3.4/site-packages/pymysql/cursors.py", line 296, in _query
conn.query(q)
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 781, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 942, in _read_query_result
result.read()
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 1143, in read
self._read_load_local_packet(first_packet)
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 1178, in _read_load_local_packet
sender.send_data()
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 1317, in send_data
self.connection._write_bytes(packet)
File "/opt/python3/lib/python3.4/site-packages/pymysql/connections.py", line 929, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
由于错误立即发生,我相信它不是超时。我运行的每一个其他查询都可以正常工作,即使是类似的加载查询。
我的问题是,什么在MySQL语法可以导致这个错误?
谢谢!
答
我有与pymysql,python3.5和远程MySQL服务器相同的问题。当我尝试插入带有巨大LONGTEXT字段的条目(例如man gcc 4次)时,它将回答相同的错误:MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))
。当我使用简短的文本行时,它很好用,比如“HELLO WORLD”。
我得到了一个我的情况的答案:我不得不修改'max_allowed_packet',所以现在它可以接受更大的SQL查询。 –