dmeibusch commented on issue #16344: URL: https://github.com/apache/airflow/issues/16344#issuecomment-872634600
Looking into this, `alembic` is assuming that sqlite3 doesn't support the column rename and is attempting to recreate the `dag` table, hitting the key constraint. Newer versions of sqlite3 do support altering the column name, however I couldn't determine whether this was supported in newer `alembic` versions. My workaround was to apply the column name change manually: ``` $> airflow db shell alter table dag RENAME column 'last_scheduler_run' to 'last_parsed_time'; ``` Then just comment out the upgrade in `2e42bb497a22_rename_last_scheduler_run_column.py` in airflow, and then run the `airflow db upgrade`. Seems to have worked. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
