我正面临这个问题:清理气流元数据并修改代码

我面临这个问题:(2006, “Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0”) in composer-1.16.5-airflow-这是 1.10.14 版本的 Cloud Composer 上的间歇性问题。我们已经尝试清理气流元数据并修改代码(例如,将 variable.get() 替换为 jinja 模板)以减少 db 上的负载,但我们每天都面临这个问题。我们还重新启动了调度程序,但问题在 2 天后再次出现,并且在 composer 上监控气流数据库的 cpu 使用情况和内存使用情况图表是恒定的,但 sql 数据库进入不健康状态一段时间。

图片[1]-我正面临这个问题:清理气流元数据并修改代码-唐朝资源网

整个错误信息如下:

Traceback (most recent call last):  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect    return fn()  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect    return _ConnectionFairy._checkout(self)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout    fairy = _ConnectionRecord.checkout(pool)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout    rec = pool._do_get()  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 241, in _do_get    return self._create_connection()  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection    return _ConnectionRecord(self)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in __init__    self.__connect(first_connect_check=True)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in __connect    pool.logger.debug("Error on connect(): %s", e)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__    with_traceback=exc_tb,  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_    raise exception  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect    connection = pool._invoke_creator(self)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect    return dialect.connect(*cargs, **cparams)  File "/opt/python3.6/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect    return self.dbapi.connect(*cargs, **cparams)  File "/opt/python3.6/lib/python3.6/site-packages/MySQLdb/__init__.py", line 85, in Connect    return Connection(*args, **kwargs)  File "/opt/python3.6/lib/python3.6/site-packages/MySQLdb/connections.py", line 208, in __init__    super(Connection, self).__init__(*args, **kwargs2)_mysql_exceptions.OperationalError: (2006, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0") 

图片[2]-我正面临这个问题:清理气流元数据并修改代码-唐朝资源网

© 版权声明
THE END
喜欢就支持一下吧
点赞277赞赏 分享
评论 抢沙发
头像
欢迎您留下宝贵的见解!
提交
头像

昵称

取消
昵称表情代码图片

    暂无评论内容