mysql 报broken pipe_关于sqlalchemy 一段时间就报 BrokenPipeError: [Errno 32] Broken pipe

使用sqlalchemy (mysql)能正常insert 和 query,在每次 commit之后都进行close。但是 一段时间后 就会报 BrokenPipeError: [Errno 32] Broken pipe的错误。

具体错误如下,求解决方案:

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py", line 741, in _rollback_impl

self._handle_dbapi_exception(e, None, None, None, None)

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py", line 1384, in _handle_dbapi_exception

exc_info,

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause

reraise(type(exception), exception, tb=exc_tb, cause=cause)

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise

raise value.with_traceback(tb)

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py", line 739, in _rollback_impl

self.engine.dialect.do_rollback(self.connection)

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/dialects/mysql/base.py", line 2253, in do_rollback

dbapi_connection.rollback()

File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 686, in rollback

self._execute_command(COM_QUERY, "ROLLBACK")

File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 872, in _execute_command

self._write_bytes(prelude + sql[:chunk_size-1])

File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 833, in _write_bytes

self.socket.sendall(data)

sqlalchemy.exc.DBAPIError: (builtins.BrokenPipeError) [Errno 32] Broken pipe

(Background on this error at: http://sqlalche.me/e/dbapi)

(, data: "{"uid":"guibo.li","user_type":"none","args":{},"order_by":{},"page":0,"limit":15}"

, )

handler.task_handler find

Traceback (most recent call last):

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py", line 761, in _commit_impl

self.engine.dialect.do_commit(self.connection)

File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/dialects/mysql/base.py", line 2241, in do_commit

dbapi_connection.commit()

File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 681, in commit

self._execute_command(COM_QUERY, "COMMIT")

File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 872, in _execute_command

self._write_bytes(prelude + sql[:chunk_size-1])

File "/usr/local/lib/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值