airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Singh (JIRA)" <j...@apache.org>
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
                 URL: https://issues.apache.org/jira/browse/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/configure.py

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

The connection string that my script "configure.py" would return is something like this:
mysql+mysqldb://username:**@mysqlhostname:3306/airflowdbname
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/configure.py 
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
(v6.3.15#6346)

Mime
View raw message