Bug #108903 MySQL Workbench freezes when starting/stopping server
Submitted: 27 Oct 2022 18:34 Modified: 28 Oct 2022 12:13
Reporter: John Green Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.31 OS:Windows (11 Pro Insider Preview 22623.870)
Assigned to: CPU Architecture:Other (x64)

[27 Oct 2022 18:34] John Green 
Description:
When I click to start or stop MYSQL server and give wbadminhelper.exe administrator privileges, the Workbench freezes, and I have to kill the process. The state of the MySQL server does not change. 

How to repeat:
1. Open MySQL Workbench
2. Connect to local MySQL server
3. Open "Startup / Shutdown" tab at the "Administration tab"
4. Press "Stop server" or "Start server" button, depending on the state of MySQL server
5. If "User Account Control" window appears, click "Yes"

Suggested fix:
I really don't know
[27 Oct 2022 18:38] John Green 
/

Attachment: Screenshot 2022-10-27 213703.png (image/png, text), 336.14 KiB.
[28 Oct 2022 9:16] John Green 
upd:
I found that one of the reasons is that wbadminhelper.py crashes because of import error. Here is traceback:

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\wbadminhelper.py", line 25, in <module>
    from workbench.os_utils import FileUtils, OSUtils
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\os_utils.py", line 31, in <module>
    from wb_common import PermissionDeniedError
ModuleNotFoundError: No module named 'wb_common'

I fixed that error and after that I can start and stop the server with MySQL Workbench, but the Workbench still freezes
[28 Oct 2022 10:40] John Green 
upd2:
I can only start/stop the server if I don't run client.start() in wbadminhelper.py

client.start() does not work because wbadminhelper.py crashes due to an error in /workbench/tcp_utils.py on line 346. Here is the error: a bytes-like object is required, not 'str'. This occurs because self._handshake is a str type, and the "send" function requires a ReadableBuffer
[28 Oct 2022 12:03] MySQL Verification Team 
Hello John Green,

Thank you for the bug report.
Imho this is duplicate of Bug #103753, please see Bug #103753.

Regards,
Ashwini Patil
[28 Oct 2022 12:06] MySQL Verification Team 
Also, see Bug #91676
[28 Oct 2022 12:13] John Green 
Bug #91676 does not apply to my case. I have clean install. It's really sad that a big company like Oracle can't fix this bug for over a year now