9/1/2023 0 Comments Airflow 2.0 requirementsMake a backup of your database so that you can restore it in case of a mistake.Ĭheck which of the tables of yours need fixing. Get familiar with the internal Database structure of Airflow which you might find atĮRD Schema of the Database and list of migrations that you might find in Reference for Database Migrations. (but you might also choose to do it your way if you know what you are doing). Here are the steps you can follow to fix it BEFORE you attempt to migrate This limits the size of indexes so that MySQL Set (which is equivalent to utf8mb3 in MySQL 8). Therefore in Airflow we force all the “ID” keys to use utf8 character Unfortunately, MySQL limits the index key size and with utf8mb4, Airflow index key sizes might be Was created with an old version of Airflow or MySQL, the encoding could have been wrong when the database MySQL and you could have custom created database with a different character set. However, this has been changing in different versions of Why you might get the error? The recommended character set/collation for MySQL 8 database is The next chapter describes how to fix the problem manually. Version of Airflow and your migration might fail with strange errors (“key size too big”, “missing indexes” etc). If you are using old Airflow 1.10 as a database created initially either manually or with previous version of MySQL,ĭepending on the original character set of your database, you might have problems with migrating to a newer Using 3rd-party images, charts, deployments.Upgrade preparation - make a backup of DB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |