[ https://issues.apache.org/jira/browse/AIRFLOW-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15979437#comment-15979437 ]
Marc Weil commented on AIRFLOW-1026: ------------------------------------ I'm having the same issue as well, and sadly this will prevent me from upgrading to 1.8.0 until it's resolved. > 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 > Fix For: Airflow 1.8 > > > 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)