Bug #72201 WB 6.1 try to load my_sys55.sql for PERFORMANCE tab, but failed.
Submitted: 1 Apr 2014 20:12 Modified: 14 May 2014 15:29
Reporter: Meiji Kimura Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.1.4 OS:Any
Assigned to: CPU Architecture:Any

[1 Apr 2014 20:12] Meiji Kimura
Description:
Workbench 6.1.x introduce new 'PERFORMANCE' section. It use my-sys for graph.

When WB try to install my-sys for using 'PERFROMANCE' at first time. With MySQL 5.6 (or 5.7) will sucess to install. But with MySQL 5.5 with performance_schema=on, it failed.

Because there is no sys_55.sql

2014/04/02  03:31    <DIR>          .
2014/04/02  03:31    <DIR>          ..
2014/03/26  16:00               114 after_setup.sql
2014/03/26  16:00               317 before_setup.sql
2014/04/02  03:31    <DIR>          functions
2014/04/02  03:31    <DIR>          procedures
2014/03/26  16:00             2,868 sys_56.sql
2014/03/26  16:00             3,016 sys_57.sql
2014/03/26  16:00            20,083 sys_reports.js
2014/04/02  03:31    <DIR>          views
 

How to repeat:
(1) Install WB 6.1.4
(2) Make connection to MySQL 5.5. with performance_schema=on
(3) Try to use 'PERFORMANCE' section in Navigator.

Suggested fix:
Print proper error (e.g. MySQL 5.5 is not supported) or 
Prepare sys_55.sql for MySQL 5.5 connection
[1 Apr 2014 20:12] Meiji Kimura
No sys_55.sql error

Attachment: wb61_no_sys_55.png (image/png, text), 16.82 KiB.

[2 Apr 2014 7:42] Umesh Shastry
Hello Meiji-San,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[23 Apr 2014 17:50] Alfredo Kojima
The SYS schema no longer supports MySQL 5.5, we will update WB to not show the option to install it in MySQL 5.5
[27 Apr 2014 1:49] ouints klints
Bug reproduced too!!
I've copied the file sys_56.sql and name it sys_55.sql, re-run the Performance schema setup and it works...
[14 May 2014 15:29] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.6 release, and here's the changelog entry:

The "PERFORMANCE" schema navigator tab was disabled for MySQL server 5.5
(and below) MySQL connections, as the system requires a MySQL server 5.6
(and above) connection. Attempting a MySQL server 5.5 would report an
error about a missing "sys_55.sql" configuration file.

Thank you for the bug report.