[
https://issues.apache.org/jira/browse/AIRFLOW-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16522411#comment-16522411
]
kunal gupta commented on AIRFLOW-2631:
--------------------------------------
[~ashb]
The worker node has the exact same airflow.cfg file as webserver,scheduler,
flower. Also the env variables AIRFLOW_* are the same for all the nodes.
Is there a way i can debug why worker is still looking for a local mysql
instead of the one given in the celery_result_backend?
> Worker fails to connect with MySQL DB
> -------------------------------------
>
> Key: AIRFLOW-2631
> URL: https://issues.apache.org/jira/browse/AIRFLOW-2631
> Project: Apache Airflow
> Issue Type: Bug
> Affects Versions: Airflow 2.0, 1.10
> Reporter: kunal gupta
> Priority: Critical
>
> I have containerized Airflow webserver, scheduler, flower and worker. I'm
> using MySQL for the backend and Redis for queuing. Everytime I spin up the
> worker node it throws the error below and all the Dags are stuck in running
> status.
> Logs from the Worker Node:
> File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 193,
> in __init__
> super(Connection, self).__init__(*args, **kwargs2)
> OperationalError: (_mysql_exceptions.OperationalError) (2002, "Can't connect
> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")
> [2018-06-15 10:21:56,005: ERROR/MainProcess] Pool callback raised exception:
> OperationalError('(_mysql_exceptions.OperationalError) (2002, "Can\'t connect
> to local MySQL server through socket \'/var/lib/mysql/mysql.sock\' (2)")',)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
