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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
