Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
-
None
-
Centos 8 - Directadmin - Mariadb 10.4 - Cloudlinux
Description
Hi
We migrating from Mysql to mariadb a few months back accidentally due to settings set inside Directadmin's custombuild feature during an update.
Since this happened, all of our accounts inside directadmin dont show any databases and reports Internal error - failed to load database list
Phpmyadmin also just errors with failed to open.
When trying to perform mysql_upgrade, it gets to phase 4 and then a bunch of errors are displayed and then Fatal Error - Upgrade failed.
Any advice or help on how to resolve the mariadb not functioning correctly would be appreciated. The databases on the server are working and no issues for any of those, it just seems to be accessing the database lists and upgrades dont work.
Below is the errors from mysql_upgrade
 |
[root@server ~]# mysql_upgrade |
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 7: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 10: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 14: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 28: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 36: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 44: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 47: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 56: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 59: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 62: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 75: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 82: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 96: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 120: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 125: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 138: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 140: Unknown collation: 'utf8_general_ci' |
ERROR 29 (HY000) at line 171: File '/var/log/mysql-slow-queries.log' not found (Errcode: 13 "Permission denied") |
ERROR 1273 (HY000) at line 172: 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 182: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 183: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 184: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 185: 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 195: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 196: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 197: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 198: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 205: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 206: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 210: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 213: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 216: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 219: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 224: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 272: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 276: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 279: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 296: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 299: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 308: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 311: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 326: Unknown collation: 'utf8_bin' |
ERROR 1115 (42000) at line 334: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 335: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 337: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 338: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 378: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 384: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 387: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 389: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 392: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 394: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 397: Unknown collation: 'utf8_bin' |
ERROR 1408 (HY000) at line 402: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. |
ERROR 1273 (HY000) at line 405: 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 408: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 412: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 413: 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 419: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 420: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 421: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 422: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 427: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 430: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 431: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 434: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 469: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 470: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 471: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 472: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 473: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 475: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 476: Unknown collation: 'utf8_bin' |
ERROR 1115 (42000) at line 507: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 572: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 574: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 632: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 633: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 634: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 635: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 636: Unknown collation: 'utf8_general_ci' |
ERROR 1273 (HY000) at line 641: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 642: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 643: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 644: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 645: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 646: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 647: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 648: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 649: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 650: Unknown character set: 'utf8' |
ERROR 1273 (HY000) at line 651: Unknown collation: 'utf8_bin' |
ERROR 1273 (HY000) at line 652: Unknown collation: 'utf8_general_ci' |
ERROR 1115 (42000) at line 655: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 656: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 657: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 659: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 660: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 661: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 662: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 700: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 701: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 702: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 704: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 705: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 706: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 708: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 709: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 710: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
ERROR 1115 (42000) at line 763: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 770: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 771: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 772: Unknown character set: 'utf8' |
ERROR 1115 (42000) at line 808: Unknown character set: 'utf8' |
ERROR 1243 (HY000) at line 809: Unknown prepared statement handler (stmt) given to EXECUTE |
ERROR 1243 (HY000) at line 810: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE |
FATAL ERROR: Upgrade failed
|
|
Regards
Alec