2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [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).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2017-01-17 16:21:10 8154 [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).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2017-01-17 16:21:10 8154 [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).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2017-01-17 16:21:10 8154 [Note] Event Scheduler: Loaded 0 events
2017-01-17 16:21:10 8154 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
Pleaseusemysql_upgradetofixthiserror.
MySQL起来后,运行mysql_upgrade命令升级一下。然后重启即可。
用percona备份出来的数据大版本升级的时候需要升级一下。
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。