[jira] [Commented] (AIRFLOW-6931) One migration failed during "airflow initdb" in mssql server 2017

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-6931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17049219#comment-17049219 ] 

ASF GitHub Bot commented on AIRFLOW-6931:
-----------------------------------------

BaoshanGu commented on pull request #7574: [AIRFLOW-6931] Fixed migrations to find all dependencies for mssql
URL: https://github.com/apache/airflow/pull/7574
 
 
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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)