Uploaded image for project: 'Apache Airflow'
  1. Apache Airflow
  2. AIRFLOW-2631

Worker fails to connect with MySQL DB

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 2.0.0
    • Fix Version/s: None
    • Component/s: database
    • Labels:

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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rushtokunal kunal gupta
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: