[GitHub] [airflow] uranusjr commented on a diff in pull request #24926: Troubleshooting MySQL Exceptions at upgrade

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

uranusjr commented on code in PR #24926:
URL: https://github.com/apache/airflow/pull/24926#discussion_r922961764


##########
docs/apache-airflow/installation/upgrading.rst:
##########
@@ -118,3 +118,69 @@ Deleting a table:
 .. code-block:: sql
 
    DROP TABLE <table>;
+   
+Troubleshooting MySQL Exceptions at upgrade
+===========================================
+
+How to analyse exceptions during MySQL database migration steps. In general the `airflow db upgrade` handles the necessary migration steps but excceptions can happen (backups before migration recommended).
+This description is based on issue due different charactersets and collation. When the database was created the defaults on mysql were *utf8mb4* *utf8mb4_0900_ai_ci*. 
+Since the pull request [Automatically use utf8mb3_general_ci collation for mysql](https://github.com/apache/airflow/pull/17729) *utf8* *utf8mb3_bin* also called *utf8_bin* is used.
+
+At Figure out the sql-statement which caused the error. See exemplary Log below.
+
+ .. code-block:: python

Review Comment:
   This is not Python, don’t use the Python syntax highlighter.
   
   ```suggestion
    .. code-block::
   ```



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