MySQL Forums
Forum List  »  NDB clusters

mysql_upgrade fails
Posted by: Roger Hill
Date: September 03, 2013 12:50PM

When trying to run mysql_upgrade while upgrading from Cluster 7.2.12 to Cluster 7.3.2, I receive the following error:

mysql_upgrade -u xxxxx -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql.sock'
mysqlcheck: unknown option '--fix-db-names'
FATAL ERROR: Upgrade failed

The 5.6 Reference manual indicates that mysql_upgrade will run mysqlcheck with the option --fix-db-names.

In the log for mysqld, I see the following errors at start up.

2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [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).
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2013-09-03 18:02:04 2268 [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).
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2013-09-03 18:02:04 2268 [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).
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50529, now running 50611. Please use mysql_upgrade to fix this error.
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2013-09-03 18:02:04 2268 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

I am assuming that mysql_upgrade should resolve these errors, but it will not run due to the above error.

I'm not understanding why mysqlcheck is throwing this error.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql_upgrade fails
6659
September 03, 2013 12:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.