[jira] [Resolved] (AIRFLOW-5342) Can't run initdb using Microsoft SQL server

["Jarek Potiuk (Jira)" <ji...@apache.org>]

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

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

> Can't run initdb using Microsoft SQL server
> -------------------------------------------
>
>                 Key: AIRFLOW-5342
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-5342
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: configuration, core, database
>    Affects Versions: 1.10.4
>            Reporter: Adam Trump
>            Assignee: Morten Post
>            Priority: Critical
>             Fix For: 2.0.0
>
>
> I'm using Microsoft SQL server 2016 as metadata db (for the sql_alchemy_conn), and pymssql as the Python driver.
> When running airflow initdb, airflow creates a table named `TaskInstance` with column `pool` that is initially Nullable (when the table is created).
> Later, an index named `ti_pool` on a few columns, including `pool` column in table `TaskInstance`.
> Then, airflow will try to alter table `TaskInstance` and change the column `pool` to `NOT NULL`.
> This does not work on Microsoft SQL Server since a column with an index defined on it cannot be changed, unless the index is deleted before.



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