Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

[ERROR]Native table performance schema has the wrong structure

150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
150814  9:09:14 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
150814  9:09:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-cll-lve'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp

Then I run

mysql_upgrade

It shows:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

FATAL ERROR: Upgrade failed

like image 390
Cherry Avatar asked Aug 14 '15 01:08

Cherry


2 Answers

It seems this happens after you have done upgrade. Simply restart mysql:

service mysql restart

and the error should now have disappeared.

like image 72
Berend de Boer Avatar answered Oct 26 '22 17:10

Berend de Boer


If you're running MySQL on your local device, you need to upgrade your mysql and then restart:

Upgrade:

$ mysql_upgrade -u root  

Restart:

$ mysql.server restart
like image 35
Tenzin Chemi Avatar answered Oct 26 '22 19:10

Tenzin Chemi