[GitHub] [airflow] michaelosthege 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>]

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

   Upgrading from 2.2.5 to 2.3.3 I'm running into these issues too.
   Thanks to the posts above I'm slowly making progress, and I think I have something useful to add 👇
   
   First I'm trying to fix the the `CHARACTER SET` and `COLLATE` of all tables and columns as described by [this guide](https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-manually-744326173.html).
   * Using `CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci` as described by https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html#setting-up-a-mysql-database
   * ⚠ Except for `task_id` and `dag_id` columns [as described by the comment above](https://github.com/apache/airflow/issues/24526#issuecomment-1181627863)
   
   ❓ __Am I doing the right thing with the character set and collation?__
   
   ❓ __If anybody has a more convenient script/SQL command set to fix the collections that'd be awesome!__
   
   -------
   
   After that I'm trying to do the `airflow db upgrade` and now it looks like I'm running into something similar to #24247 (I'm using MySQL not MariaDB).
   
   ```
   INFO  [alembic.runtime.migration] Running upgrade 5e3ec427fdd3 -> 786e3737b18f, Add ``timetable_description`` column to DagModel for UI.
   ...
   sqlalchemy.exc.ProgrammingError: (MySQLdb.ProgrammingError) (1146, "Table 'airflow.dag' doesn't exist")
   [SQL: ALTER TABLE dag ADD COLUMN timetable_description VARCHAR(1000)]
   ```
   
   The [fix to that might be to run `airflow db init`](https://github.com/apache/airflow/issues/24247#issuecomment-1147509478) under 2.2.5 before upgrading. I'll try that and update this comment ⏳


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