airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Singh (JIRA)" <>
Subject [jira] [Created] (AIRFLOW-1026) connection string using _cmd tin airflow.cfg is broken
Date Wed, 22 Mar 2017 04:47:41 GMT
Harish Singh created AIRFLOW-1026:

             Summary: connection string using _cmd tin airflow.cfg is broken
                 Key: AIRFLOW-1026
             Project: Apache Airflow
          Issue Type: Bug
          Components: configuration
    Affects Versions: Airflow 1.8
            Reporter: Harish Singh
            Priority: Critical

sql_alchemy_conn_cmd = python ./pipeline/dags/

I am expectiing to be invoked.
But it just throws:
             "cannot use sqlite with the LocalExecutor"

The connection string that my script "" would return is something like this:
But after debugging, I found that, my script is not getting invoked at all.

This is my airflow.cfg:
executor = LocalExecutor
sql_alchemy_conn_cmd = python ./pipeline/dags/ 
sql_alchemy_pool_size = 5
sql_alchemy_pool_recycle = 3600

I tried not using the script and directly hardcoding the conn_url
sql_alchemy_conn = mysql+mysqldb://username:**@mysqlhostname:3306/airflowdbname
It works.
But  there is a regression bug if somebody wants to use "sql_alchemy_conn_cmd"

This message was sent by Atlassian JIRA

View raw message