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

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