[AIRFLOW-2631] Worker fails to connect with MySQL DB

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.0.0
• Component/s: database
• Labels: mysql
• Assignee: Unassigned
• Reporter: kunal gupta
• Created: 15/Jun/18 16:29
• Updated: 29/May/19 03:34

Description

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)")',)