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

Thomas Hillyer edited comment on AIRFLOW-4567 at 5/27/19 5:52 PM:
------------------------------------------------------------------

Same issue here.

Airflow 1.10.3, Postgres 9.6.1, SQLAlchemy 1.2.17

Using CeleryExecutor

Celery 4.1.1, Kombu 4.2.2

 

Using pdb I can see that it will successfully run through `sqlalchemy.py:81` a 
couple times before hitting the "DB connection invalidated" error that fills up 
the logs


was (Author: trker):
Same issue here.

Airflow 1.10.3, Postgres 9.6.1, SQLAlchemy 1.2.17

Using CeleryExecutor

Celery 4.1.1, Kombu 4.2.2

> sqlalchemy DB connection invalidated. Reconnecting
> --------------------------------------------------
>
>                 Key: AIRFLOW-4567
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-4567
>             Project: Apache Airflow
>          Issue Type: Bug
>    Affects Versions: 1.10.3
>            Reporter: raphael auv
>            Priority: Major
>
> With airflow  1.10.3 , postgres 9.5 and SQLAlchemy 1.2.19
>  
> I'm getting a lot of :
> {code:java}
> [2019-05-24 08:50:18,644] {{__init__.py:305}} INFO - Filling up the DagBag 
> from /usr/local/airflow/dags 
> [2019-05-24 08:50:25,771] {{sqlalchemy.py:81}} WARNING - DB connection 
> invalidated. Reconnecting... 
> [2019-05-24 08:50:36,785] {{sqlalchemy.py:81}} WARNING - DB connection 
> invalidated. Reconnecting... 
> [2019-05-24 08:50:47,801] {{sqlalchemy.py:81}} WARNING - DB connection 
> invalidated. Reconnecting... 
> [2019-05-24 08:50:58,803] {{sqlalchemy.py:81}} WARNING - DB connection 
> invalidated. Reconnecting... 
> [2019-05-24 08:51:02,069] {{__init__.py:51}} INFO - Using executor 
> LocalExecutor
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to