[
https://issues.apache.org/jira/browse/AIRFLOW-4567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16872616#comment-16872616
]
HARISH GAGGAR commented on AIRFLOW-4567:
----------------------------------------
On Airflow 1.10.3 with Google Cloud SQL (Second Generation), we are facing same
issue.
{color:#FF0000}*{sqlalchemy.py:81} WARNING - DB connection invalidated.
Reconnecting...*{color}
Because of this, our scheduled task does not kick off at all. Everytime,
manually we need to restart scheduler and keep task moving but issue appears
again on the next schedule.
Request you please reopen this Jira.
> 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.17 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)
