001-008659

パッケージ版 Garoon

関心あり
0人の方が関心を示しています

バージョン 4.0.0のガルーンにバージョンアップすると、MySQLのエラーログにエラーが出力される。

種別
その他の制限事項
機能
  • インストーラー
再現バージョン
  • 4.0.0
改修バージョン
公開日
2015-01-15
更新日
2015-01-15

詳細

【再現手順】

  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での運用には問題ありません。

回避/対応方法

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