Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.6
-
None
Description
How to fix upgrade errors?
mysql_upgrade -p
|
Enter password:
|
Phase 1/7: Checking and upgrading mysql database |
Processing databases
|
mysql
|
mysql.column_stats OK
|
mysql.columns_priv OK
|
mysql.db OK
|
mysql.event OK
|
mysql.func OK
|
mysql.global_priv OK
|
mysql.gtid_slave_pos OK
|
mysql.help_category OK
|
mysql.help_keyword OK
|
mysql.help_relation OK
|
mysql.help_topic OK
|
mysql.index_stats OK
|
mysql.innodb_index_stats OK
|
mysql.innodb_table_stats OK
|
mysql.plugin OK
|
mysql.proc OK
|
mysql.procs_priv OK
|
mysql.proxies_priv OK
|
mysql.roles_mapping OK
|
mysql.servers OK
|
mysql.table_stats OK
|
mysql.tables_priv OK
|
mysql.time_zone OK
|
mysql.time_zone_leap_second OK
|
mysql.time_zone_name OK
|
mysql.time_zone_transition OK
|
mysql.time_zone_transition_type OK
|
mysql.transaction_registry OK
|
Phase 2/7: Installing used storage engines... Skipped |
Phase 3/7: Fixing views |
mysql.user OK
|
Phase 4/7: Running 'mysql_fix_privilege_tables' |
ERROR 1273 (HY000) at line 6: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 9: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 13: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 27: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 35: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 43: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 46: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 55: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 58: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 61: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 74: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 81: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 91: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 115: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 120: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 133: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 135: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 168: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 174: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 175: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 176: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 177: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 178: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 179: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 180: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 181: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 185: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 186: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 187: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 188: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 189: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 190: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 191: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 192: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 193: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 194: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 201: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 202: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 206: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 209: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 212: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 215: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 220: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 268: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 272: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 275: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 292: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 295: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 304: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 307: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 322: Unknown collation: 'utf8_bin' |
ERROR 1115 (42000) at line 328: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 329: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 331: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 332: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 372: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 378: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 381: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 383: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 386: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 388: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 391: Unknown collation: 'utf8_bin' |
ERROR 1408 (HY000) at line 396: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. |
ERROR 1273 (HY000) at line 399: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 400: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 401: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 402: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 406: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 407: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 409: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 410: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 413: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 414: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 415: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 416: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 421: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 424: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 425: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 428: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 463: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 464: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 465: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 466: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 467: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 469: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 470: Unknown collation: 'utf8_bin' |
ERROR 1115 (42000) at line 499: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 561: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 563: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 622: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 623: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 624: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 625: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 626: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 631: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 632: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 633: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 634: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 635: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 636: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 637: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 638: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 639: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 640: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 641: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 642: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 645: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 646: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 647: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 649: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 650: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 651: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 652: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 690: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 691: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 692: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 694: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 695: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 696: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 698: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 699: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 700: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 753: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 759: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 760: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 761: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 797: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 798: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 799: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
FATAL ERROR: Upgrade failed
|
tail /var/log/mariadb/mariadb.log
|
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'db_name' at position 0 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'table_name' at position 1 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'db_name' at position 0 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'table_name' at position 1 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'db_name' at position 0 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'table_name' at position 1 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'db_name' at position 0 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'table_name' at position 1 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'db_name' at position 0 to have character set 'utf8' but found character set 'utf8mb4'. |
2021-07-16 18:42:00 322 [ERROR] Incorrect definition of table mysql.table_stats: expected the type of column 'table_name' at position 1 to have character set 'utf8' but found character set 'utf8mb4'. |
Attachments
Issue Links
- duplicates
-
MDEV-25924 Client shows `utf8mb3` csname replace warning message while logging into server
- Closed
- is caused by
-
MDEV-8334 Rename utf8 to utf8mb3
- Closed