You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Jason Kendall (Jira)" <ji...@apache.org> on 2021/06/04 02:20:00 UTC

[jira] [Commented] (AIRFLOW-3544) MySQL warnings about aborted connections

    [ https://issues.apache.org/jira/browse/AIRFLOW-3544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17357020#comment-17357020 ] 

Jason Kendall commented on AIRFLOW-3544:
----------------------------------------

Tracking down similar issue - Are you using Celery Executor? 

> MySQL warnings about aborted connections
> ----------------------------------------
>
>                 Key: AIRFLOW-3544
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3544
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: worker
>    Affects Versions: 1.10.1
>            Reporter: Rami Darwish
>            Priority: Minor
>
> We're still seeing some warnings about aborted connections in our mysql log.
> 2018-12-19T01:37:18.584535Z 3489268 [Note] Aborted connection 3489268 to db: 'airflow' user: 'airflow' host: 'x.x.x.x' (Got an error reading communication packets)
> Looks like engine disposal is not being performed on the worker/task process. I was able to reproduce by executing a BashOperator command with "sleep 120". Once the task finished execution, the warning is generated and it is coming from the worker host. I'm still not sure if it is coming from the worker or from the task instance itself. 
>  
> We're using airflow 1.10.1, mysql 5.7, python 2.7.13 and SQLAlchemy 1.1.18



--
This message was sent by Atlassian Jira
(v8.3.4#803005)