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)
