詳細

【再現手順】

1. バージョン 3.7.0～3.7.5のガルーンをインストールします。
   
   
2. バージョン 4.0.0以降のガルーンへバージョンアップします。
   
   

→現象発生：

 MySQLのエラーログに次のエラーが出力されます。

 例：

 Windows版の場合：

 ------------------------------

 2015-03-01 12:00:00 26480 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
 2015-03-01 12:00:00 26480 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 26480 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 26480 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 26480 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 26480 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 68e4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
 2015-03-01 12:00:00 68e4 InnoDB: Error: Fetch of persistent statistics requested for table "cb_cbgrn"."tab_cb_profiledata___system" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

 ------------------------------

 Linux版の場合：
 ------------------------------

 2015-03-01 12:00:00 7367 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
 2015-03-01 12:00:00 7367 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50529, now running 50621. Please use mysql_upgrade to fix this error.
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
 2015-03-01 12:00:00 7367 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

 2015-03-01 12:00:00 7f41a6908710 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
 2015-03-01 12:00:00 7f41a6908710 InnoDB: Error: Fetch of persistent statistics requested for table "cb_cbgrn"."tab_cb_profiledata___system" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
 ------------------------------

補足：

• MySQLのエラーログは、次のディレクトリーに出力されます。
  
  • (インストールディレクトリ)/mysql-5.0/data/error.log
    
    
• バージョンアップは正常に完了しています。
  
  
• エラーが出力された状態でも、バージョン 4.0.0での運用には問題ありません。

回避/対応方法

申し訳ありません。本現象は制限事項です。

関連記事