[
https://issues.apache.org/jira/browse/AIRFLOW-6931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Baoshan Gu updated AIRFLOW-6931:
--------------------------------
Description:
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}
was:
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}} does not find all
constraints.
Specifically in line #234:
{code}74effc47d867_change_datetime_to_datetime2_6_on_mssql_.py{code}
Confirmed that changing it to case-insensitive selection works:
{code}(tc.CONSTRAINT_TYPE = 'PRIMARY KEY' or LOWER(tc.CONSTRAINT_TYPE) =
'unique'){code}
> 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)
