sqlchemy: ‘Lost connection to MySQL server during query

最新推荐文章于 2024-04-30 11:11:45 发布
最新推荐文章于 2024-04-30 11:11:45 发布
阅读量601 收藏
点赞数
分类专栏： python 文章标签： python 数据库开发
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/book_1992/article/details/126618984
版权

具体报错：

​
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 598, in _read_bytes
data = await self._reader.readexactly(num_bytes)
File "/usr/local/lib/python3.8/asyncio/streams.py", line 721, in readexactly
raise exceptions.IncompleteReadError(incomplete, n)
asyncio.exceptions.IncompleteReadError: 0 bytes read on a total of 4 expected bytes

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 503, in _connect
await self._request_authentication()
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 785, in _request_authentication
auth_packet = await self._read_packet()
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 561, in _read_packet
packet_header = await self._read_bytes(4)
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 601, in _read_bytes
raise OperationalError(2013, msg) from e
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
self._dec_overflow()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 666, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 597, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/aiomysql.py", line 265, in connect
await_only(self.aiomysql.connect(*arg, **kw)),
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only
return current.driver.switch(awaitable)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn
value = await result
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 75, in _connect
await conn._connect()
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 521, in _connect
raise OperationalError(2003,
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '10.50.8.39'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/src/app/common/controller/base_controller.py", line 116, in execute
raise e
File "/usr/src/app/common/controller/base_controller.py", line 103, in execute
result = await async_session.execute(stmt, values)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/ext/asyncio/session.py", line 212, in execute
result = await greenlet_spawn(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 126, in greenlet_spawn
result = context.throw(*sys.exc_info())
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1711, in execute
conn = self._connection_for_bind(bind)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1552, in _connection_for_bind
return self._transaction._connection_for_bind(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 747, in _connection_for_bind
conn = bind.connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/future/engine.py", line 406, in connect
return super(Engine, self).connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3234, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3313, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3283, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2117, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
self._dec_overflow()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 666, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 597, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/aiomysql.py", line 265, in connect
await_only(self.aiomysql.connect(*arg, **kw)),
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only
return current.driver.switch(awaitable)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn
value = await result
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 75, in _connect
await conn._connect()
File "/usr/local/lib/python3.8/site-packages/aiomysql/connection.py", line 521, in _connect
raise OperationalError(2003,
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '10.50.8.39'")
(Background on this error at: https://sqlalche.me/e/14/e3q8)

​

原因；

多协程并发执行sql，因代码内有关闭db 连接的代码，最终导致部分协程执行成功，而部分协程又执行失败了。

JoXu
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MySQL远程连接丢失问题解决方法（Lost connection to MySQL server）
12-15
代码如下:Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0 很明显这是连接初始化阶段就丢失了连接的错误。 google半天大多是说的注释掉配置文件中 bind-address = ...
MySQL出现SQL Error (2013)连接错误的解决方法
12-15
等待约一两分钟后出现错误提示：SQL Error (2013): Lost connection to MySQL server at 'waiting for initial communication packet', system error: 0，如下图所示： 开始以为是远程TCP/IP root只能通过...
asyncio异步IO——Streams详解
weixin_33755554的博客
11-30 446
前言 本文翻译自python3.7官方文档——asyncio-stream,译者马鸣谦,邮箱 1612557569@qq.com。转载请注明出处。 数据流（Streams） 数据流（Streams）是用于处理网络连接的高阶异步/等待就绪(async/await-ready)原语,可以在不使用回调和底层传输协议的情况下发送和接收数据。 以下是一个用asyncio实现的TCP回显客户端： impor...
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, ‘Lost connection to MySQL ser
NQS__的博客
03-11 510
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
python asyncio_Python 异步 IO系列：认识asyncio
weixin_39717029的博客
11-23 291
Python的asyncio是使用 async/await 语法编写并发代码的标准库。通过上一篇文章，我们了解了它不断变化的发展历史。到了Python最新稳定版 3.7 这个版本，asyncio又做了比较大的调整，把这个库的API分为了 高层级API和低层级API，并引入asyncio.run()这样的高级方法，让编写异步程序更加简洁。本文希望提纲挈领地介绍最新 3.7 版的asnycio，先从全...
Python3开发过程常见的异常（最近更新：2019-04-26）
逸鹏说道
10-10 26
持续更新中... 常见异常解决方案 1.Base 1.1.IndentationError: unexpected indent 1.2.TypeError: str returned non-string (type NoneType) 1.3.TypeError: 'list' object is not callable 1.4.xxx() missing 1 required po...
Python 异步 IO 、协程、asyncio、async/await、aiohttp
freeking101的博客
03-02 3129
协程又称微线程，纤程，英文名 Coroutine。 子程序(即函数)的调用是通过栈实现的，子程序调用总是一个入口，一次返回，调用顺序是明确的。 协程看上去也是子程序，但执行过程中，在子程序内部可中断，然后转而执行别的子程序，在适当的时候再返回来接着执行。 注意，在一个 子程序中中断，去执行其他子程序，不是函数调用，有点类似CPU的中断。
asyncio 系列四、asyncio 的异常
duxin_csdn的博客
05-24 8446
异常 官网连接：https://docs.python.org/zh-cn/3.7/library/asyncio-exceptions.html exceptionasyncio.TimeoutError 该操作已超过规定的截止日期。 重要：这个异常与内置TimeoutError异常不同。 exceptionasyncio.CancelledError 该操...
flask使用sqlalchemy报错(pymysql.err.OperationalError 2013)
study_in的博客
10-19 7411
文章目录1. 错误内容:2. 报错原因:3. flask_sqlalchemy的变量:4. 解决办法:5. 更多参数配置: 1. 错误内容: 在使用flask_sqlalchemy的时候，每当长时间未请求，当再一次使用连接的时候，就会报 pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') 2. 报错原因: 我们一般使用数据库连接池来获取连接，连接池里的连接可能会较长时间不关闭，等待被使用，这
【SQLAlchemy】第二篇——连接失效及连接池
芳樽里的歌的博客
03-04 3912
SQLAlchemy中的连接池及如何处理连接失效的问题
pymysql.err.OperationalError: (2013, ‘Lost connection to MySQL server during query‘）
weixin_44463766的博客
11-17 6679
@ pymysql.err.OperationalError: (2013, ‘Lost connection to MySQL server during query’） python 使用sqlalchemy链接MySQL断链问题(2013, ‘Lost connection to MySQL server during query’） 解决方案 create_engine中添加参数： pool_recycle=3600, pool_pre_ping=True SQLAlchemy 1.4 Docu
聊聊 SQLAlchemy 连接池中的连接失效问题
Gordennizaicunzai的博客
02-08 3389
最近项目中事情比较多，也遇到了一些问题，其中有一个是关于连接池的，比较有意思，这里分享下。 一天早上，进入业务系统，点击了一个功能按钮，页面上突然弹出个 MySQL gone away 的错误，我擦，数据库挂了吗，上服务器一看正常的。又点击了一下，又报事务未正常关闭的错误，有点懵。当然，是在测试环境上 :)。仔细想了想，发现是连接池的问题，下面我重现下这个错误并说下自己的一些解决办法。 注意：文中代码测试环境 Python 3.6.0 PyMySQL 0.9.2 SQLAlchemy 1.2.
MySQL ERROR 2013 (HY000)错误解决方法
12-15
当通过 TCP/IP 连接 MySQL 远程主机时，出现 ERROR 2013 (HY000): Lost connection to MySQL server at ... 命令时就随机出现 ERROR 2013 (HY000): Lost connection to MySQL server during query 问题。而如果把
php的慢速日志引起的Mysql错误问题分析
01-21
问题：执行程序时，会报 2013(Lost connection to MySQL server during query) 分析： 1）在我们的后台程序中，会执行一个循环（>300次），循环中会重复执行一条SQL语句； 2）Nginx的访问日志，程式每次执行时间，...
Day25-Java基础之常用类1
m0_46053885的博客
04-27 909
同时我们发现Math类中的方法都是静态的，因此在使用的时候我们可以直接通过类名去调用。对于计算机而言，其实是没有数据类型的概念的，都是0101010101，数据类型是编程语言自己规定的，所以在实际存储的时候，先把具体的数字变成二进制，每32个bit为一组，存储在数组中。比较内存地址值一般情况下是没有意义的，我们希望比较的是对象的属性，如果两个对象的属性相同，我们认为就是同一个对象；如果我们的数据是一个浮点类型的数据，有的时候计算机并不会将这个数据完全转换成一个二进制数据，而是将这个将其转换成一个无限的。
Lambda表达式特点
weixin_57763462的博客
04-24 845
**API 设计**：Lambda 表达式鼓励使用函数式接口的设计模式，这改变了 Java 库的设计，例如 `java.util.function` 包下的一系列函数式接口。- **函数式编程**：Lambda 表达式引入了函数式编程的理念，使得 Java 更接近于函数式编程语言，如 Scala 和 Clojure。- **并发编程**：Lambda 表达式与 Java 8 新增的 Stream API 结合使用，可以简化并发编程，特别是与集合的操作相关。
AttributeError: module ‘numpy‘ has no attribute ‘float‘.的解决方法
最新发布
chen_znn的博客
04-30 331
本文记录了AttributeError: module 'numpy' has no attribute 'float'.的解决方法
Python 二叉树的创建与遍历
youyouxiong的博客
04-24 442
在Python中创建二叉树并进行遍历，我们首先需要定义一个二叉树节点类，然后创建二叉树，最后实现几种基本的遍历方法：前序、中序、后序和层序遍历。以下是具体的实现步骤： 2. 创建二叉树 创建二叉树通常是由用户根据需要输入节点值来构建，或者通过特定的算法生成。这里我们手动创建一个简单的二叉树： 3. 实现二叉树的遍历 前序遍历 (Preorder Traversal) 访问根节点，然后递归地遍历左子树，最后递归地遍历右子树。 中序遍历 (Inorder Traversal) 递归地遍历左子
Error 2013: Lost connection to MySQL server during query
10-24
Error 2013: Lost connection to MySQL server during query是指在执行MySQL查询时，与MySQL服务器的连接意外中断。这个错误可能由多种原因引起，比如网络问题、MySQL服务器负载过高、MySQL服务器配置不当等等。其中，网络问题是最常见的原因之一。如果你遇到了这个错误，可以尝试重新连接MySQL服务器，或者检查网络连接是否正常。如果问题仍然存在，建议联系运维人员进行排查。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值