[ https://issues.apache.org/jira/browse/AIRFLOW-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ash Berlin-Taylor updated AIRFLOW-3138: --------------------------------------- Fix Version/s: 1.10.1 > Migration cc1e65623dc7 creates issues with postgres > --------------------------------------------------- > > Key: AIRFLOW-3138 > URL: https://issues.apache.org/jira/browse/AIRFLOW-3138 > Project: Apache Airflow > Issue Type: Bug > Components: db > Affects Versions: 1.10.0 > Reporter: M Noronha > Priority: Major > Fix For: 1.10.1 > > > When trying to upgrade from 1.8.0 to 1.10.0, migration > cc1e65623dc7_add_max_tries_column_to_task_instance.py results in error: > sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'task_instance' > expected to update 1 row(s); 0 were matched. > That's due to a datatype mismatch between the database (TIMESTAMP before > migration 0e2a74e0fc9f) and the UtcDateTime. > Changing > 55c54 > < execution_date = Column(UtcDateTime, primary_key=True) > --- > > execution_date = Column(sa.DateTime(), primary_key=True) > Seems to be enough to work in postgres. This also works in sqlite. -- This message was sent by Atlassian JIRA (v7.6.3#76005)