MySQL Bugs: #72876: MySQL Workbench Client Connections unhandled error

Bug #72876	MySQL Workbench Client Connections unhandled error
Submitted:	4 Jun 2014 14:27	Modified:	28 Feb 2017 13:30
Reporter:	Erin Gallagher	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.1.6	OS:	Windows (Microsoft Windows 7 Service Pack 1 build 7601, 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\egallagher\AppData\Roaming\MySQL\Workbench/log/wb.log]

When you open a connection and select Client Connections in the navigator bar you receive an error.It occurs as the tab opens. As long as you select okay a couple times you are able to exit the Administrator tab. 

"An unhandled exception occurred (Error executing 'SELECT PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',PROCESSLIST_USER,PROCESSLIST_HOST,PROCESSLIST_D... FROM performance_schema.threads WHERE TYPE <> 'BACKGROUND"
Unknown column 'PROCESSLIST_USER' in 'field list'.
SQL Error: 1054). Please refer to log files for details.

How to repeat:
Open a connections, Select Client Connections in the navigator bar (on left side).

log file

Attachment: SQL error.txt (text/plain), 24.19 KiB.

Screen shot of the error

Attachment: SQL_error_screen_shot.png (image/png, text), 48.42 KiB.

Please check with 6.1.6 version. Thanks.

http://bugs.mysql.com/bug.php?id=72932 marked as duplicate of this one.

Has this been resolved?  I'm using 6.1.6 and still getting the same error.

I couldn't repeat and its obvious since the behavior is reported by different
users I lack of something which makes the issue repeatable so I asked you more
info about your environment: you have connected with which MySQL version?
which kind of connection (remote or local), the connected user privileges?. Thanks.

My environment is MySQL Server 5.6.17 on a Win 7 64-bit PC.  This happends 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. Backuped, 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

Please try version 6.1.7. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

wblog

Attachment: WBlog.txt (text/plain), 9.42 KiB.

Was able to reproduce this on a fresh MySQL 5.6.17 openSUSE package install on openSUSE 12.3 x64 using Mac OSX 10.8.4 MySQL Workbench 6.2.3.12313 Build 2282 32bit

{code}
An unhandled exception occurred (Error executing 'SELECT THREAD_ID, NAME, TYPE, PROCESSLIST_ID, PROCESSLIST_USER,PROCESSLIST_HOST, PROCESSLIST_DB, PROCESSLIST_COMMAND, PROCESSLIST_TIME,PROCESSLIST_STATE, SUBSTRING(PROCESSLIST_INFO, 1, 80) AS INFO,PARENT_THREAD_ID,ROLE, INSTRUMENTED FROM performance_schema.threads'
Unknown column 'TYPE' in 'field list'.
SQL Error: 1054). Please refer to the log files for details.
{code}

I had a slightly older version of workbench 6.2 installed before (sorry, I cannot recall the exact version) from which I ran the performance schema setup tool initially.  After the update (spurred by reading this bug) it asked me to update the performance schema extensions which I did.  Unfortunately this didnt change the error.

I also receive another error stemming from missing columns in the performance_schema.threads table.  This occurs when selecting "Client Connections" from the management tab.  I have enabled SSH management for the server.  

Also, in Workbench preferences under "Modeling --> MySQL" I have selected Default Target MySQL Version = 5.6.  Not sure if this matters in this case.

{code}
An unhandled exception occurred (Error executing 'SELECT t.PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USER,t.PROCESSLIST_HOST,t.PROCESSLIST_DB,t.PROCESSLIST_COMMAND,t.PROCESSLIST_TIME,t.PROCESSLIST_STATE,t.THREAD_ID,t.TYPE,t.NAME,t.PARENT_THREAD_ID,t.INSTRUMENTED,t.PROCESSLIST_INFO,a.ATTR_VALUE FROM performance_schema.threads t  LEFT OUTER JOIN performance_schema.session_connect_attrs a ON t.processlist_id = a.processlist_id AND (a.attr_name IS NULL OR a.attr_name = 'program_name') WHERE t.TYPE <> 'BACKGROUND''
Table 'performance_schema.session_connect_attrs' doesn't exist.
SQL Error: 1146). Please refer to the log files for details.
{code}

Oddly, while writing this I know I had previously seen a performance_schema listed in the schemas section of workbench.  This is now gone, however the data base remains if accessed through query:

show databases;
use performance_schema;
desc performance_schema.threads;

# Field, Type, Null, Key, Default, Extra
THREAD_ID, int(11), NO, , , 
PROCESSLIST_ID, int(11), YES, , , 
NAME, varchar(128), NO, , , 

The attached is the contents of the wb.log file when re-creating the above errors.  Unfortunately WB seems to roll these logs on each restart but it reuses the filename so the old log is gone.  If someone can reproduce and grab the wb.log file after clicking to add / install the performance schema extensions without restarting workbench it might show what failed during the creation (if there was a failure).

The latest release is 6.2.3 please check with it. Thanks.

@Miguel - I tried with this version:
MySQL Workbench 6.2.3.12313 Build 2282 32bit

There does not appear to be a newer version available for mac?

@Kyle,

I couldn't repeat on MacBook Pro (Yosemite) so could you provide the steps or trick actions to be repeatable on my side?. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Same error:
Ubuntu 14.10 
mysql Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using  EditLine wrapper
mysql-workbench 6.2.5.0 build 367 (64 bits) Community

Fixed it
run mysqld --performance_schema
and restart mysql

Hello,
I have the described problem using WB6.2.5 against MySQL 5.6.22 on Debian.
Is there anything I can about it right now?
Thanks,
Tomas

Please try version 6.3.4. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hello,

I encountered the same problem with Mysql Workbench 6.3.8 on Mysql 5.6.19
For help, I also used Mysql workbench 5.2 and it works.
Now, with new version I can't kill thread by workbench. Must I uninstall new version and use Workbench 5.2 ?

Regards,

Not exactly the same output : 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.py", line 1025, in refresh
    query_result = self.get_process_list()
  File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.py", line 813, in get_process_list
    return self.get_process_list_new()
  File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.py", line 837, in get_process_list_new
    result = self.ctrl_be.exec_query("SELECT %s FROM performance_schema.threads t %s WHERE 1=1" % (",".join(cols), JOIN))
  File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_control.py", line 624, in exec_query
    raise e
workbench.db_utils.QueryError: Error executing 'SELECT t.PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USER,t.PROCESSLIST_HOST,t.PROCESSLIST_DB,t.PROCESSLIST_COMMAND,t.PROCESSLIST_TIME,t.PROCESSLIST_STATE,t.THREAD_ID,t.TYPE,t.NAME,t.PARENT_THREAD_ID,t.INSTRUMENTED,t.PROCESSLIST_INFO,a.ATTR_VALUE FROM performance_schema.threads t  LEFT OUTER JOIN performance_schema.session_connect_attrs a ON t.processlist_id = a.processlist_id AND (a.attr_name IS NULL OR a.attr_name = 'program_name') WHERE 1=1'
SELECT command denied to user 'myUser'@'myserver' for table 'threads'.
SQL Error: 1142

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".