[GitHub] [airflow] flrn77 commented on issue #24526: upgrading from 2.2.3 or 2.2.5 to 2.3.2 fails on migration-job

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

flrn77 commented on issue #24526:
URL: https://github.com/apache/airflow/issues/24526#issuecomment-1170817271

   Hi @miimsam,
   thx for the Issue description. That's a good hint ;)
   I have `CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci` in `task_instance.task_id`.
   
   yesterday I tested migration with changed  `CHARACTER SET utf8 COLLATE utf8_bin` like it is when I create DB from scratch.
   That step works. But caused by the first failed migration I have to do manuell steps to bring it back to work.
   
   ```sql
   -- 1.  change charset and collate
   ALTER TABLE task_instance MODIFY task_id VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin;
   
   -- 2. drop table session
   drop table session;
   
   -- 3. drop index
   drop index idx_job_dag_id on job;
   
   -- 4. drop column
   ALTER TABLE dag drop COLUMN timetable_description;
   
   -- 5. drop table log_template
   ALTER TABLE dag_run DROP FOREIGN KEY task_instance_log_template_id_fkey;
   DROP TABLE log_template;
   
   ...
   ```
   
   I also have an older Backup before the the failed migration Job, maybe I should try this if the list of manual steps growth.
   


-- 
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