[
https://issues.apache.org/jira/browse/AIRFLOW-809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bolke de Bruin updated AIRFLOW-809:
-----------------------------------
Fix Version/s: 1.8.2
> SqlAlchemy is_ ColumnOperator Causing Errors in MSSQL
> -----------------------------------------------------
>
> Key: AIRFLOW-809
> URL: https://issues.apache.org/jira/browse/AIRFLOW-809
> Project: Apache Airflow
> Issue Type: Bug
> Components: models, scheduler
> Environment: Distributor ID: Ubuntu
> Description: Ubuntu 14.04.5 LTS
> Release: 14.04
> Codename: trusty
> Backend: MSSQL
> Executor: LocalExecutor
> Reporter: Chad T Henderson
> Assignee: Chad T Henderson
> Fix For: 1.9.0, 1.8.2
>
>
> Starting the scheduler produces the following error, which I believe is
> caused by the use of the _is ColumnOperator when checking the value of the
> external_trigger field on the DagRun object.
> Error Text:
> sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000]
> [FreeTDS][SQL Server]Incorrect syntax near '0'. (102) (SQLExecDirectW)")
> [SQL: 'SELECT TOP 1 dag_run.state AS dag_run_state, dag_run.id AS dag_run_id,
> dag_run.dag_id AS dag_run_dag_id, dag_run.execution_date AS
> dag_run_execution_date, dag_run.start_date AS dag_run_start_date,
> dag_run.end_date AS dag_run_end_date, dag_run.run_id AS dag_run_run_id,
> dag_run.external_trigger AS dag_run_external_trigger, dag_run.conf AS
> dag_run_conf \nFROM dag_run \nWHERE dag_run.dag_id = ? AND
> dag_run.external_trigger IS 0 ORDER BY dag_run.execution_date DESC']
> [parameters: ('append_to_history',)]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
