Bug #117515 MySQL Workbench can't open processlist in MySQL 8.4

• Submitted: 19 Feb 15:02
• Modified: 20 Feb 9:05
• Reporter: IGG t
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.41
• OS: Windows
• CPU Architecture: Any

[19 Feb 15:02] IGG t

Description:
I have just started to look at upgrading to MySQL 8.4, however it seems that MySQL workbench has an issue with the "client connections"

I have tried this with several MySQL 8.4.4 databases now, all with the same result.

How to repeat:
Take a MySQL 8.4 database, 8.4.4 in my case
Open MySQL Workbench, 8.0.41
Connect to the MySQL 8.4. database
Go to Management > client Connections

and you get an error:

"Unhandled Exception:
DbMySQLQuery.resultFieldStringValueByName(): 
MySQL_ResultSet::isNull: invalid value of 'columnLabel'"

From the wb.log:

14:57:40 [ERR][      WBContext]: Unsupported server version: MySQL Community Server - GPL 8.4.4
14:57:40 [INF][        WQE.net]: Launching SQL IDE
14:57:41 [INF][        WQE.net]: SQL IDE UI is ready
14:57:43 [ERR][wb_admin_utils.py:page_activated:353]: Exception activating the page - DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel'Exception activating the page - DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel'Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_connections.py", line 1055, in refresh
    query_result = self.get_process_list()
                   ^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_connections.py", line 845, in get_process_list
    return self.get_process_list_old()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_connections.py", line 887, in get_process_list_old
    value = result.stringByName(field)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_utils.py", line 214, in stringByName
    return modules.DbMySQLQuery.resultFieldStringValueByName(self.result, name)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel'

Suggested fix:
make it so you can open the processlist in MySQL 8.4

[20 Feb 9:05] MySQL Verification Team

Hello IGG t,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh