Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
- create a dump of 10.5 or earlier including mysql schema etc. A dump of all databases from a freshly bootstrapped server will do (10.5.dump
) - shut down 10.5, bootstrap and start a fresh 10.6+
- load the dump of 10.5 into 10.6
- run mysql_upgrade (it will likely require --force)
- see the output
10.6 70021737
Phase 1/7: Checking and upgrading mysql databaseProcessing databasesmysqlmysql.column_stats OKmysql.columns_priv OKmysql.db OKmysql.event OKmysql.func OKmysql.global_priv OKmysql.gtid_slave_pos OKmysql.help_category OKmysql.help_keyword OKmysql.help_relation OKmysql.help_topic OKmysql.index_stats OKmysql.innodb_index_stats OKmysql.innodb_table_stats OKmysql.plugin OKmysql.proc OKmysql.procs_priv OKmysql.proxies_priv OKmysql.roles_mapping OKmysql.servers OKmysql.table_stats OKmysql.tables_priv OKmysql.time_zone OKmysql.time_zone_leap_second OKmysql.time_zone_name OKmysql.time_zone_transition OKmysql.time_zone_transition_type OKmysql.transaction_registry OKPhase 2/7: Installing used storage engines... SkippedPhase 3/7: Fixing viewsmysql.user OKsys.host_summaryError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.host_summary_by_file_ioError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.host_summary_by_file_io_typeError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.host_summary_by_stagesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.host_summary_by_statement_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.host_summary_by_statement_typeError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.innodb_buffer_stats_by_schemaError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.innodb_buffer_stats_by_tableError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.innodb_lock_waitsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.io_by_thread_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.io_global_by_file_by_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.io_global_by_file_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.io_global_by_wait_by_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.io_global_by_wait_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.latest_file_ioError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.memory_by_host_by_current_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.memory_by_thread_by_current_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.memory_by_user_by_current_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.memory_global_by_current_bytesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.memory_global_totalError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.metrics OKsys.processlistError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.ps_check_lost_instrumentation OKsys.schema_auto_increment_columns OKsys.schema_index_statisticsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.schema_object_overview OKsys.schema_redundant_indexes OKsys.schema_table_lock_waitsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.schema_table_statisticsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.schema_table_statistics_with_bufferError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.schema_tables_with_full_table_scansError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.schema_unused_indexes OKsys.sessionError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.session_ssl_status OKsys.statement_analysisError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.statements_with_errors_or_warningsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.statements_with_full_table_scansError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.statements_with_runtimes_in_95th_percentileError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.statements_with_sortingError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.statements_with_temp_tablesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summaryError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summary_by_file_ioError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summary_by_file_io_typeError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summary_by_stagesError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summary_by_statement_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.user_summary_by_statement_typeError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.version OKsys.wait_classes_global_by_avg_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.wait_classes_global_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.waits_by_host_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.waits_by_user_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.waits_global_by_latencyError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.x$host_summary OKsys.x$host_summary_by_file_io OKsys.x$host_summary_by_file_io_type OKsys.x$host_summary_by_stages OKsys.x$host_summary_by_statement_latency OKsys.x$host_summary_by_statement_type OKsys.x$innodb_buffer_stats_by_schema OKsys.x$innodb_buffer_stats_by_table OKsys.x$innodb_lock_waits OKsys.x$io_by_thread_by_latency OKsys.x$io_global_by_file_by_bytes OKsys.x$io_global_by_file_by_latency OKsys.x$io_global_by_wait_by_bytes OKsys.x$io_global_by_wait_by_latency OKsys.x$latest_file_io OKsys.x$memory_by_host_by_current_bytes OKsys.x$memory_by_thread_by_current_bytes OKsys.x$memory_by_user_by_current_bytes OKsys.x$memory_global_by_current_bytes OKsys.x$memory_global_total OKsys.x$processlist OKsys.x$ps_digest_95th_percentile_by_avg_us OKsys.x$ps_digest_avg_latency_distribution OKsys.x$ps_schema_table_statistics_ioError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.x$schema_flattened_keys OKsys.x$schema_index_statistics OKsys.x$schema_table_lock_waitsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.x$schema_table_statisticsError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.x$schema_table_statistics_with_bufferError : Cannot load from mysql.proc. The table is probably corruptederror : Corruptsys.x$schema_tables_with_full_table_scans OKsys.x$session OKsys.x$statement_analysis OKsys.x$statements_with_errors_or_warnings OKsys.x$statements_with_full_table_scans OKsys.x$statements_with_runtimes_in_95th_percentile OKsys.x$statements_with_sorting OKsys.x$statements_with_temp_tables OKsys.x$user_summary OKsys.x$user_summary_by_file_io OKsys.x$user_summary_by_file_io_type OKsys.x$user_summary_by_stages OKsys.x$user_summary_by_statement_latency OKsys.x$user_summary_by_statement_type OKsys.x$wait_classes_global_by_avg_latency OKsys.x$wait_classes_global_by_latency OKsys.x$waits_by_host_by_latency OKsys.x$waits_by_user_by_latency OKsys.x$waits_global_by_latency OKPhase 4/7: Running 'mysql_fix_privilege_tables'Phase 5/7: Fixing table and database namesPhase 6/7: Checking and upgrading tablesProcessing databasesinformation_schemaperformance_schemasyssys.sys_config OKtesttmpPhase 7/7: Running 'FLUSH PRIVILEGES'OK
The problem here, as far as I can tell, is that first it tries to check views, including sys schema, which survived the dump load because it doesn't exist in 10.5, but its functions cannot be loaded because mysql.proc structure has changed. mysql.proc is upgraded later, and later sys views are even re-created.
So all in all, there seems to be no harm (hence Minor), but the output looks scary.
Attachments
Issue Links
- relates to
-
MDEV-27517 mariadb-upgrade from MySQL 5.7 pollutes stdout on some sys schema views
-
- Open
-
-
MDEV-35602 mysql.proc -> "The table is probably corrupted" is an excessive error
-
- Open
-