Failed to upgrade from 10.4 to 10.6

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