[
https://issues.apache.org/jira/browse/AIRFLOW-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16714687#comment-16714687
]
jack commented on AIRFLOW-1026:
-------------------------------
SQLite can not be used with LocalExecutor
> 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: 1.8.0
> Reporter: Harish Singh
> Priority: Critical
> Fix For: 1.8.0
>
>
> 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
(v7.6.3#76005)
