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] 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.