[GitHub] [airflow] pingzh commented on issue #25144: Airflow db init fails on mysql 5.7

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

pingzh commented on issue #25144:
URL: https://github.com/apache/airflow/issues/25144#issuecomment-1189361302

   > This is the problem of your definition See the notes https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html#setting-up-a-mysql-database about collation used (you need to use utf8_mb3 collation).
   
   hi @potiuk thanks for the comments. In fact for mysql 5.7, the default charset is `utf8` (with collation is `utf8_general_ci` ,which is `utf8mb3` in mysql 5.7 , so using that wont solve the issue.
   
   
   my question is when setting the db columns an indexes, we might be extra careful about the length. for example, for the key of xcom, do we really need `512` that long?
   
   


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