MySQL Cluster の アップグレード 4 ( トラブルシューティング )

■ mysql_upgrade を実行していないとアップグレード後 myusqld を起動すると、以下のようなエラーが出力される

[[email protected] my_cluster]$ mysqld --defaults-file=conf/my.cnf &
[1] 2898
[[email protected] my_cluster]$ 120804 11:02:34 [Note] Plugin 'FEDERATED' is disabled.
120804 11:02:35 [Note] NDB: NodeID is 51, management server 'vm-nfj-mysqlmn1:1186'
120804 11:03:05 [Note] NDB[0]: NodeID: 51, some storage nodes connected
120804 11:03:05 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
120804 11:03:05 [Note] Starting Cluster Binlog Thread
120804 11:03:05 InnoDB: The InnoDB memory heap is disabled
120804 11:03:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120804 11:03:05 InnoDB: Compressed tables use zlib 1.2.3
120804 11:03:05 InnoDB: Using Linux native AIO
120804 11:03:05 InnoDB: Initializing buffer pool, size = 128.0M
120804 11:03:05 InnoDB: Completed initialization of buffer pool
120804 11:03:05 InnoDB: highest supported file format is Barracuda.
InnoDB: 127 rollback segment(s) active.
120804 11:03:06  InnoDB: Waiting for the background threads to start
120804 11:03:07 InnoDB: 1.1.8 started; log sequence number 44253
120804 11:03:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120804 11:03:07 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120804 11:03:07 [Note] Server socket created on IP: '0.0.0.0'.
120804 11:03:07 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120804 11:03:07 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120804 11:03:07 [Note] Event Scheduler: Loaded 0 events
120804 11:03:07 [Note] mysqld: ready for connections.
Version: '5.5.25a-ndb-7.2.7-gpl'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Cluster Community Server (GPL)
120804 11:03:07 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_schema
120804 11:03:07 [Note] NDB Binlog: logging ./mysql/ndb_schema (UPDATED,USE_WRITE)
120804 11:03:07 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_apply_status
120804 11:03:07 [Note] NDB Binlog: logging ./mysql/ndb_apply_status (UPDATED,USE_WRITE)
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'information_schema'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'blog.neoflow.jp'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'clusterdb'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'mt.neoflow.jp'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'ndbinfo'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'test'
120804 11:03:07 [Note] NDB: Cleaning stray tables from database 'yshop.neoflow.jp'
2012-08-04 11:03:07 [NdbApi] INFO     -- Flushing incomplete GCI:s < 13102530/4
2012-08-04 11:03:07 [NdbApi] INFO     -- Flushing incomplete GCI:s < 13102530/4
120804 11:03:07 [Note] NDB Binlog: starting log at epoch 13102530/4
120804 11:03:07 [Note] NDB Binlog: ndb tables writable
120804 11:03:07 [Note] NDB Binlog: Node: 2, subscribe from node 52, Subscriber bitmask 1000000

■ mysql_upgrade の場所確認

[[email protected] my_cluster]$ which mysql_upgrade
~/mysqlc/bin/mysql_upgrade

■ mysql_upgrade の実行

[[email protected] my_cluster]$ mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
blog.neoflow.jp.wp_2_commentmeta                   OK
blog.neoflow.jp.wp_2_comments                      OK
blog.neoflow.jp.wp_2_links                         OK
blog.neoflow.jp.wp_2_options                       OK
blog.neoflow.jp.wp_2_postmeta                      OK
blog.neoflow.jp.wp_2_posts                         OK
blog.neoflow.jp.wp_2_term_relationships            OK
blog.neoflow.jp.wp_2_term_taxonomy                 OK
blog.neoflow.jp.wp_2_terms                         OK
blog.neoflow.jp.wp_author_adsense                  OK
blog.neoflow.jp.wp_blog_versions                   OK
blog.neoflow.jp.wp_blogs                           OK
blog.neoflow.jp.wp_commentmeta                     OK
blog.neoflow.jp.wp_comments                        OK
blog.neoflow.jp.wp_domain_mapping                  OK
blog.neoflow.jp.wp_domain_mapping_logins           OK
blog.neoflow.jp.wp_links                           OK
blog.neoflow.jp.wp_options                         OK
blog.neoflow.jp.wp_postmeta                        OK
blog.neoflow.jp.wp_posts                           OK
blog.neoflow.jp.wp_registration_log                OK
blog.neoflow.jp.wp_signups                         OK
blog.neoflow.jp.wp_site                            OK
blog.neoflow.jp.wp_sitemeta                        OK
blog.neoflow.jp.wp_term_relationships              OK
blog.neoflow.jp.wp_term_taxonomy                   OK
blog.neoflow.jp.wp_terms                           OK
blog.neoflow.jp.wp_usermeta                        OK
blog.neoflow.jp.wp_users                           OK
clusterdb.simples                                  OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_apply_status                             OK
mysql.ndb_binlog_index                             OK
mysql.ndb_index_stat_head                          OK
mysql.ndb_index_stat_sample                        OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     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.user                                         OK
ndbinfo.blocks                                     OK
ndbinfo.config_params                              OK
yshop.neoflow.jp.categories                        OK
yshop.neoflow.jp.products_c10002                   OK
yshop.neoflow.jp.products_c13457                   OK
yshop.neoflow.jp.products_c2497                    OK
yshop.neoflow.jp.products_c2498                    OK
yshop.neoflow.jp.products_c2500                    OK
yshop.neoflow.jp.products_c2501                    OK
yshop.neoflow.jp.products_c2502                    OK
yshop.neoflow.jp.products_c2503                    OK
yshop.neoflow.jp.products_c2504                    OK
yshop.neoflow.jp.products_c2505                    OK
yshop.neoflow.jp.products_c2506                    OK
yshop.neoflow.jp.products_c2507                    OK
yshop.neoflow.jp.products_c2508                    OK
yshop.neoflow.jp.products_c2509                    OK
yshop.neoflow.jp.products_c2510                    OK
yshop.neoflow.jp.products_c2511                    OK
yshop.neoflow.jp.products_c2512                    OK
yshop.neoflow.jp.products_c2513                    OK
yshop.neoflow.jp.products_c2514                    OK
yshop.neoflow.jp.products_c2516                    OK
yshop.neoflow.jp.products_c2517                    OK
yshop.neoflow.jp.promotion_events                  OK
yshop.neoflow.jp.reviews_c10002                    OK
yshop.neoflow.jp.reviews_c13457                    OK
yshop.neoflow.jp.reviews_c2497                     OK
yshop.neoflow.jp.reviews_c2498                     OK
yshop.neoflow.jp.reviews_c2500                     OK
yshop.neoflow.jp.reviews_c2501                     OK
yshop.neoflow.jp.reviews_c2502                     OK
yshop.neoflow.jp.reviews_c2503                     OK
yshop.neoflow.jp.reviews_c2504                     OK
yshop.neoflow.jp.reviews_c2505                     OK
yshop.neoflow.jp.reviews_c2506                     OK
yshop.neoflow.jp.reviews_c2507                     OK
yshop.neoflow.jp.reviews_c2508                     OK
yshop.neoflow.jp.reviews_c2509                     OK
yshop.neoflow.jp.reviews_c2510                     OK
yshop.neoflow.jp.reviews_c2511                     OK
yshop.neoflow.jp.reviews_c2512                     OK
yshop.neoflow.jp.reviews_c2513                     OK
yshop.neoflow.jp.reviews_c2514                     OK
yshop.neoflow.jp.reviews_c2516                     OK
yshop.neoflow.jp.reviews_c2517                     OK
yshop.neoflow.jp.users                             OK
yshop.neoflow.jp.variables                         OK
Running 'mysql_fix_privilege_tables'...
OK
[[email protected] my_cluster]$ 
スポンサーリンク