MySQL Bugs: #113242: Mysql workbench Data Export lock table for a long time

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:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.29	OS:	MacOS (14.0 (23A344))
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

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

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.

Regards,
Ashwini Patil

My Mac version is 14.0 (23A344)

Please try with latest version i.e 8.0.34 and report us back if issue still persist. Thanks.

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