[AIRFLOW-5342] Can't run initdb using Microsoft SQL server

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.10.4
• Fix Version/s: 1.10.6
• Component/s: configuration, core, database
• Assignee: Morten Post
• Reporter: Adam Trump
• Created: 29/Aug/19 08:51
• Updated: 02/Oct/19 11:08
• Resolved: 26/Sep/19 18:28

Description

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.

Issue Links

• is duplicated by: AIRFLOW-5511 MSSQL resetdb /initdb for 1.10.5 fails to set ti_pool non nullable
• links to: GitHub Pull Request #6014