MySQL downgrade from 5.6.23 to 5.5.41 errors

O

overflower83

Verified User
Joined
Oct 22, 2006
Messages
16
Morning,

We had to downgrade MySQL. Now we have some errors which we cannot seem to fix.
We already tried the mysql_upgrade solution without any luck.

Code: 
Repairing tables
mysql.columns_priv
Error    : Incorrect information in file: './mysql/columns_priv.frm'
error    : Corrupt
mysql.event
Error    : Incorrect information in file: './mysql/event.frm'
error    : Corrupt
mysql.general_log
Error    : Incorrect information in file: './mysql/general_log.frm'
error    : Corrupt
mysql.innodb_index_stats
Error    : Incorrect information in file: './mysql/innodb_index_stats.frm'
error    : Corrupt
mysql.innodb_table_stats
Error    : Incorrect information in file: './mysql/innodb_table_stats.frm'
error    : Corrupt
mysql.proc
Error    : Incorrect information in file: './mysql/proc.frm'
error    : Corrupt
mysql.procs_priv
Error    : Incorrect information in file: './mysql/procs_priv.frm'
error    : Corrupt
mysql.slow_log
Error    : Incorrect information in file: './mysql/slow_log.frm'
error    : Corrupt
mysql.tables_priv
Error    : Incorrect information in file: './mysql/tables_priv.frm'
error    : Corrupt
Running 'mysql_fix_privilege_tables'...
ERROR 1033 (HY000) at line 46: Incorrect information in file: './mysql/tables_priv.frm'
ERROR 1033 (HY000) at line 48: Incorrect information in file: './mysql/columns_priv.frm'
ERROR 1033 (HY000) at line 78: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 80: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 86: Incorrect information in file: './mysql/general_log.frm'
ERROR 1243 (HY000) at line 87: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1033 (HY000) at line 94: Incorrect information in file: './mysql/slow_log.frm'
ERROR 1243 (HY000) at line 95: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1033 (HY000) at line 98: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 136: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 138: Incorrect information in file: './mysql/event.frm'
ERROR 1050 (42S01) at line 183: Table 'cond_instances' already exists
ERROR 1050 (42S01) at line 213: Table 'events_waits_current' already exists
ERROR 1050 (42S01) at line 227: Table 'events_waits_history' already exists
ERROR 1050 (42S01) at line 241: Table 'events_waits_history_long' already exists
ERROR 1050 (42S01) at line 262: Table 'events_waits_summary_by_instance' already exists
ERROR 1050 (42S01) at line 283: Table 'events_waits_summary_by_thread_by_event_name' already exists
ERROR 1050 (42S01) at line 303: Table 'events_waits_summary_global_by_event_name' already exists
ERROR 1050 (42S01) at line 320: Table 'file_instances' already exists
ERROR 1050 (42S01) at line 339: Table 'file_summary_by_event_name' already exists
ERROR 1050 (42S01) at line 359: Table 'file_summary_by_instance' already exists
ERROR 1050 (42S01) at line 376: Table 'mutex_instances' already exists
ERROR 1050 (42S01) at line 394: Table 'performance_timers' already exists
ERROR 1050 (42S01) at line 412: Table 'rwlock_instances' already exists
ERROR 1050 (42S01) at line 428: Table 'setup_consumers' already exists
ERROR 1050 (42S01) at line 445: Table 'setup_instruments' already exists
ERROR 1050 (42S01) at line 461: Table 'setup_timers' already exists
ERROR 1050 (42S01) at line 478: Table 'threads' already exists
ERROR 1033 (HY000) at line 539: Incorrect information in file: './mysql/tables_priv.frm'
ERROR 1033 (HY000) at line 542: Incorrect information in file: './mysql/tables_priv.frm'
ERROR 1033 (HY000) at line 551: Incorrect information in file: './mysql/tables_priv.frm'
ERROR 1033 (HY000) at line 566: Incorrect information in file: './mysql/columns_priv.frm'
ERROR 1033 (HY000) at line 570: Incorrect information in file: './mysql/columns_priv.frm'
ERROR 1033 (HY000) at line 580: Incorrect information in file: './mysql/columns_priv.frm'
ERROR 1033 (HY000) at line 719: Incorrect information in file: './mysql/general_log.frm'
ERROR 1033 (HY000) at line 730: Incorrect information in file: './mysql/slow_log.frm'
ERROR 1033 (HY000) at line 849: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 853: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 857: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 861: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 865: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 873: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 920: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 922: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 929: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 932: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 935: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 941: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 944: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 947: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 950: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 956: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 959: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 962: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 965: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 971: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 977: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 979: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 982: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1002: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1003: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1005: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1007: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1041: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1043: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1044: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1046: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1048: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1051: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1054: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1057: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1060: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1063: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1066: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1069: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1071: Incorrect information in file: './mysql/event.frm'
ERROR 1033 (HY000) at line 1111: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1112: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1125: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1141: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1143: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1151: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1154: Incorrect information in file: './mysql/proc.frm'
ERROR 1033 (HY000) at line 1163: Incorrect information in file: './mysql/tables_priv.frm'
FATAL ERROR: Upgrade failed

Anyone that can help us?

Kind regards,

Hans Oele
 
Hello,

Do a clean install of MySQL and restore MySQL bases from dumps. If you need a private assistance feel free to contact me by PM.
 
You must log in or register to reply here.
Back
Top