Bug #85952 Client Connections breaks for older MySQL dbs
Submitted: 14 Apr 2017 18:43 Modified: 17 Apr 2017 14:09
Reporter: Joe Knize Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:6.3.9 OS:Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[14 Apr 2017 18:43] Joe Knize
Description:
The "Client Connections" functionality is broken when connecting to my db, which is version 5.1.73. It works fine in 6.3.6, but not in 6.3.9.

According to the logs, it's trying to use performance_schema.threads, but that doesn't exist in my version of the db.

How to repeat:
Using 6.3.9, connect to an older MySQL version (maybe anything < 5.6.6), click on Client Connections.

Suggested fix:
Only use the performance_schema if it's in the database; otherwise, go back to however 6.3.6 is doing it ("show full processlist"?).
[14 Apr 2017 18:45] Joe Knize
log file

Attachment: wb.1.log (application/octet-stream, text), 10.96 KiB.

[17 Apr 2017 14:09] MySQL Verification Team
Hello Joe Knize,

Thank you for the report.
Please note that MySQL Workbench fully supports MySQL Server versions 5.5 and above. It may work with older server versions, but full functionality is not available then i.e some features take advantage of MySQL server features, and as such, they require more recent versions of MySQL Server. For example, the Performance Dashboard requires MySQL Server 5.6 or higher.

Thanks,
Umesh