Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
A user got the following errors from mariadb-upgrade in MariaDB 10.11:
ERROR 1267 (HY000) at line 3127: Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '='
I cannot find the source of the error as I don't know the query. The line 3127 in
mysql_fix_privilege_tables_sql.c also does not give me any idea of what is wrong.
To make it easier to find errors like the above we should enhance mariadb_upgrade to provide the query when something goes wrong when running mariadb_upgrade and it fails in mysql_fix_privilege_tables.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.5 [ 23123 ] |
| Assignee | Michael Widenius [ monty ] |
| Description |
A user got the following errors from mariadb-upgrade in MariaDB 10.11:
ERROR 1267 (HY000) at line 3127: Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '=' I cannot find the source of the error as I don't know the query. The line 3127 in mysql_fix_privilege_tables_sql.c also does not give me any idea of what is wrong. To make it easier to find errors like the above we should enhance mariadb_upgrade to provide the query when something goes wrong when running fix mysql_fix_privilege_tables. |
A user got the following errors from mariadb-upgrade in MariaDB 10.11:
ERROR 1267 (HY000) at line 3127: Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '=' I cannot find the source of the error as I don't know the query. The line 3127 in mysql_fix_privilege_tables_sql.c also does not give me any idea of what is wrong. To make it easier to find errors like the above we should enhance mariadb_upgrade to provide the query when something goes wrong when running mariadb_upgrade and it fails in mysql_fix_privilege_tables. |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2024-06-25 13:35:46.0 | 2024-06-25 13:35:45.636 |
| Component/s | Upgrades [ 15807 ] | |
| Fix Version/s | 10.5.26 [ 29832 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |