Bug #108451 Performance Reports and Performance Schema Setup not work
Submitted: 9 Sep 2022 16:10 Modified: 9 Sep 2022 20:40
Reporter: Dinh Hieu Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:8.0.17 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[9 Sep 2022 16:10] Dinh Hieu
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\ilantic\AppData\Roaming\MySQL\Workbench\log\wb.log]

I connect to the MySQL 8.0.17 server with the root user, but when I click to Performance Reports or Performance Schema Setup, there was error:
Unable to access Peformance Schema helper (sys)
not enough value to unpack (expected 3, got 1)
If the sys schema is already installed, make sure you have SELECT privileges on it.
If not, you will need to create the `sys` schema and populate it with the views and stored procedures for PERFORMANCE_SCHEMA.

The error in log file:
[ERR][wb_admin_perfschema.py:validate:394]: Error checking for PS helper: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_perfschema.py", line 370, in validate
    ix, iy, iz = [int(i) for i in installed_version.split(".")]
ValueError: not enough values to unpack (expected 3, got 1)

As I checked, the performance schema is correctly configured on the server side.

How to repeat:
Use MySQL Community Server 8.0.17-1.el7.x86_64
And MySQL Workbench 8.0.30
[9 Sep 2022 16:11] Dinh Hieu
wb log file

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

[9 Sep 2022 20:40] MySQL Verification Team
Thank you for the bug report. Your server version 8.0.17 is quite older and so unsupported, please test current release 8.0.30 and if the issue still exist file a new bug report com repeatable test case.