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: | |
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 |
[10 Jun 2014 9:40]
Mark Rouse
[10 Jun 2014 9:42]
Mark Rouse
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
[10 Jun 2014 11:28]
MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=72876 .
[10 Jun 2014 13:04]
MySQL Verification Team
Please see the feedback I requested in the bug report prior mentioned. Thanks.
[10 Jun 2014 13:28]
Mark Rouse
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
[10 Jun 2014 17:18]
Mark Rouse
Any idea on how I fix this?