[GitHub] [airflow] potiuk commented on issue #26176: Upgrade to 2.3.4 DB Upgrade issue

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

potiuk commented on issue #26176:
URL: https://github.com/apache/airflow/issues/26176#issuecomment-1238453168

   You might want to follow this guidelines for collation @a246530 -> it is not yet released so you will not find it in the official docs but it is supposed to be out in 2.4.0 https://github.com/apache/airflow/blob/main/docs/apache-airflow/installation/upgrading.rst#handling-migration-problems 
   
   It's not certain if it is the problem, but you will likely find out if you follow it. Unfortunately, there are a number of reasons for 1215 error, but collation might be one of them, but - unfortunately - MySQL has so many configurations options on the back-end (including which engine is used in the backend, what are the sizes of various fields etc. that there might be multiple reasons - specific to your deployment and there is no way we can help with solving all of them.
   
   Soem reasons are explained here: https://stackoverflow.com/questions/16969060/mysql-error-1215-cannot-add-foreign-key-constraint but this is just first result from a google query I run - you will likely find out more if you search more @a246530 . Follow them, you will likely find a solutiuon if "how to fix my collation" problem guideline does not fix it for you - then it is likely another problem.
   
   At this stage (you are not the first person for me to reach that stage) I have the usual advice. Drop MySQL. Switch to postgres. more than 80 % of our users use Postgres (see https://airflow.apache.org/blog/airflow-survey-2022/) and almost exclusively we have similar kind of problems only with MySQL - coming from some ways of collaction/encoding changes in MySQL but also deadlocks and plenty other things. 
   
   Converting it into dicussion. And I would love to hear what is the result of your investigations @a246530 
   


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