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
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 6.1.4
• OS: Any
• 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] MySQL Verification Team

No sys_55.sql error

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

[2 Apr 2014 7:42] MySQL Verification Team

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.