[GitHub] [airflow] SamWheating commented on issue #18939: Upgrading from version 2.1.4 to 2.2.0 fails during mysql db upgrade with error Can't DROP 'dag_id'

[GitBox <gi...@apache.org>]

SamWheating commented on issue #18939:
URL: https://github.com/apache/airflow/issues/18939#issuecomment-1013463456


   If anyone else is having this issue - we got into this state despite using the correct collation and encoding, here's what we found. 
   
   In our case, the  `taskinstance_keyed_to_dagrun` migration was stopped midway through (due to some misconfigured kubernetes probes), which left it in a partially completed state. Successive runs of the same migration then failed due to trying to creating constraints which already exist.
   
   As a solution, we manually edited the migration to omit any already-completed steps. After this we were able to successfully finish the migration with `airflow db upgrade`. 
   
   
   
   


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org