You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "Jarek Potiuk (Jira)" <ji...@apache.org> on 2019/12/27 08:34:00 UTC

[jira] [Resolved] (AIRFLOW-6366) Fix migrations for MS SQL Server

     [ https://issues.apache.org/jira/browse/AIRFLOW-6366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jarek Potiuk resolved AIRFLOW-6366.
-----------------------------------
    Fix Version/s: 2.0.0
       Resolution: Fixed

> Fix migrations for MS SQL Server
> --------------------------------
>
>                 Key: AIRFLOW-6366
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6366
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: database
>    Affects Versions: 1.10.7
>            Reporter: Bjorn Olsen
>            Assignee: Bjorn Olsen
>            Priority: Minor
>             Fix For: 2.0.0
>
>
> Although MS SQL Server is not officially supported as a backend database, I am using it via PyODBC and found a minor issue with migration from 1.10.6 to 1.10.7.
>  
> Below is a log excerpt showing the issue:
> INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4 -> d38e04c12aa2, add serialized_dag table
> sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'JSON_VALID' is not a recognized built-in function name. (195) (SQLExecDirectW)")



--
This message was sent by Atlassian Jira
(v8.3.4#803005)