[jira] [Commented] (AIRFLOW-1877) airflow initdb fails on SQLServer

["Brad Holmes (JIRA)" <ji...@apache.org>]

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

Brad Holmes commented on AIRFLOW-1877:
--------------------------------------

This ticket should now be resolved, as it was addressed by AIRFLOW-3079.

> airflow initdb fails on SQLServer
> ---------------------------------
>
>                 Key: AIRFLOW-1877
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-1877
>             Project: Apache Airflow
>          Issue Type: Bug
>            Reporter: Dylan Rajguru
>            Priority: Major
>
> file "/opt/incubator-airflow/airflow/migrations/versions/0e2a74e0fc9f_add_time_zone_awareness.py", line 85, in upgrade
>     op.alter_column(table_name='chart', column_name='last_modified', type_=sa.TIMESTAMP(timezone=True))
> INFO  [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 0e2a74e0fc9f, Add time zone awareness
> Traceback (most recent call last):
>   File "pymssql.pyx", line 447, in pymssql.Cursor.execute (pymssql.c:7119)
>   File "_mssql.pyx", line 1011, in _mssql.MSSQLConnection.execute_query (_mssql.c:11586)
>   File "_mssql.pyx", line 1042, in _mssql.MSSQLConnection.execute_query (_mssql.c:11466)
>   File "_mssql.pyx", line 1175, in _mssql.MSSQLConnection.format_and_run_query (_mssql.c:12746)
>   File "_mssql.pyx", line 1586, in _mssql.check_cancel_and_raise (_mssql.c:16880)
>   File "_mssql.pyx", line 1630, in _mssql.maybe_raise_MSSQLDatabaseException (_mssql.c:17524)
> _mssql.MSSQLDatabaseException: (4927, b"Cannot alter column 'last_modified' to be data type timestamp.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)