[ https://issues.apache.org/jira/browse/AIRFLOW-6931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17049221#comment-17049221 ]
Baoshan Gu commented on AIRFLOW-6931: ------------------------------------- Changing SQL server collate to Latin1_General_CI_AI works without any code changes. I am closing the ticket. > One migration failed during "airflow initdb" in mssql server 2017 > ----------------------------------------------------------------- > > Key: AIRFLOW-6931 > URL: https://issues.apache.org/jira/browse/AIRFLOW-6931 > Project: Apache Airflow > Issue Type: Bug > Components: database > Affects Versions: 1.10.9 > Environment: microsoft sqlserver 2017 > Reporter: Baoshan Gu > Priority: Major > > Running "airflw initdb" got error: > {code:java} > _mssql.MSSQLDatabaseException: (5074, b"The object > 'UQ__dag_run__F78A9899295C1915' is dependent on column > 'execution_date'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server > error: Check messages from the SQL Server\nDB-Lib error message 20018, > severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n") > {code} > The issue is migration file > [74effc47d867_change_datetime_to_datetime2_6_on_mssql_.py|https://github.com/apache/airflow/blob/master/airflow/migrations/versions/74effc47d867_change_datetime_to_datetime2_6_on_mssql_.py#L235] > does not find all constraints. > Confirmed that changing it to case-insensitive selection works: > {code}(tc.CONSTRAINT_TYPE = 'PRIMARY KEY' or LOWER(tc.CONSTRAINT_TYPE) = > 'unique'){code} -- This message was sent by Atlassian Jira (v8.3.4#803005)