MySQL Bugs: #72932: MySQL Workbench Error on accessing Client Connections

Bug #72932	MySQL Workbench Error on accessing Client Connections
Submitted:	10 Jun 2014 9:40	Modified:	10 Jun 2014 17:18
Reporter:	Mark Rouse	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	6.1.6.11834 build 1642	OS:	Windows (Win 7 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	Client Connections, workbench

Description:
When I click on Client Connections, I get an:

Error - An unhandled exception occurred (Error executing 'Select Processlist_ID, if (NAME = 'thread/sql/event_scheduler,'event_scheduler', Proces... PROCESSLIST_USER,PROCESSLIST_HOST,PROCESSLIST.... FROM performance_schema.threads where type <> 'BACKGROUND'  Unknown column PROCESSLIST_USER in field list SQL Error 1054

How to repeat:
Don't know

I check the log and I get the folloiwng errors:

Timestamp, Thread, Type, Details
2014-06-10 10:22:57, 4836, 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).
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'setup_actors' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'setup_objects' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Column count of performance_schema.threads is wrong. Expected 14, found 3. The table is probably corrupted
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_current' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_history' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_current' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_history' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'users' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'accounts' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'hosts' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'socket_instances' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2014-06-10 10:22:57, 4836, ERROR, Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=72876 .

Please see the feedback I requested in the bug report prior mentioned. Thanks.

My environment is MySQL Server 5.6.17 on a Win 7 64-bit PC.  This happens both locally and remotely.  For me it seems that the peformance_schema is corrupted.  I reently upgraded from 5.5 to 5.6.  I followed the instructions. Backed up my data, removed 5.5, restored data, ran mysql_upgrade.  For me the issue occured after running mysql_upgrade, but then why would that affected the performance schema?  Happens even with I log into MySQL through the Workbench with my DBA user credentials

Any idea on how I fix this?