Bug #113242 Mysql workbench Data Export lock table for a long time
Submitted: 28 Nov 2023 2:32 Modified: 29 Dec 2023 12:58
Reporter: Pham Canh Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.29 OS:MacOS (14.0 (23A344))
Assigned to: MySQL Verification Team CPU Architecture:Any

[28 Nov 2023 2:32] Pham Canh
I utilized the Data Export functionality of MySQL Workbench, with the settings on Dump Structure Only, Export to Self-Contained File, and I did not select the option to Create Dump in Single Transaction. I left the Advanced Options at their default settings, meaning that I did not uncheck the 'skip lock table' option. 

The Data Export occurred in about 10 seconds at around 9:15 AM, so the DB should have only been locked during this brief period. However, my database remained locked until 10:30 AM, which caused the PUT requests to be held up, rendering my system unavailable. After 10:30 AM, once the database released the lock, the system started to function normally again. 

How to repeat:
The issue cannot be reproduced on my staging system.
[28 Nov 2023 13:06] MySQL Verification Team
Hello Pham Canh,

Thank you for the bug report.
Could you please let us know the Mac version you are using?
Also, 8.0.29 is quite an old version. Please try with latest version and report us back if issue persist. Thanks.

Ashwini Patil
[29 Nov 2023 8:48] Pham Canh
My Mac version is 14.0 (23A344)
[29 Nov 2023 12:58] MySQL Verification Team
Please try with latest version i.e 8.0.34 and report us back if issue still persist. Thanks.
[30 Dec 2023 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".