You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Chad T Henderson (JIRA)" <ji...@apache.org> on 2017/01/25 22:09:26 UTC
[jira] [Created] (AIRFLOW-809) SqlAlchemy is_ ColumnOperator
Causing Errors in MSSQL
Chad T Henderson created AIRFLOW-809:
----------------------------------------
Summary: 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
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.3.4#6332)