Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26165

Failed to upgrade from 10.4 to 10.6

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              andrewponomarenko Andrey P.
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration