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

最新推荐文章于 2024-04-26 08:41:14 发布

千层猫

最新推荐文章于 2024-04-26 08:41:14 发布

阅读量994

点赞数

文章标签： mysql 报broken pipe

本文链接：https://blog.csdn.net/weixin_42513616/article/details/113935864

版权

使用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/

关注