'events_stages_history' has the wrong structure

Posts regarding the MySQL database server
Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

'events_stages_history' has the wrong structure

Post by mister_v »

I get the following error messages in my log file '/var/log/mysql/mysqld.err '

Code: Select all

2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-11-16 20:07:12 28575 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure

What i it and what can I do about it?
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

Re: 'events_stages_history' has the wrong structure

Post by chris »

Well there is something wrong with your database.
Could be File system that is corrupted, or an upgrade of mysql that went wrong.

I suggest you first do a backup of your databases.

and you can try the following command:

Code: Select all

sudo mysql_upgrade -u root -p
If you recently upgrade your MYSQL server,
it can cause the "wrong structure error".
The command should solve it.
Post Reply