Bug #104062 SP Code Lost when the Setup is Not Responding even after executing the SP

• Submitted: 20 Jun 2021 8:39
• Modified: 21 Jun 2021 12:18
• Reporter: Meghana Kanchikar
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.22
• OS: Windows (Microsoft Windows Server 2012 R2 Standard)
• CPU Architecture: Any
• Tags: WBBugReporter

[20 Jun 2021 8:39] Meghana Kanchikar

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\meghank04426\AppData\Roaming\MySQL\Workbench\log\wb.log]

I wrote an Stored Procesdure and executed it.
Closed and reopend the sp multiple times in the Same Session and the SP(Stored Procedure was fine.
When the Application gave not responding error it closed and on restarting the application the SP code written was lost only lank sp was seen and also an existing SP was modified which was had lost all the modification made in that session.

How to repeat:
Create a new stored procedure or update existing Stored Procedure and Execute it.
After that select * from table(A table which has large amount of data) .
This gives Application not Responding error and the application get closed.
On restarting the application the new created SP is lost / the modification done in the sp is lost.

Suggested fix:
The Changes done should not be lost.
Due to this unexpected error. the Entire day code was lost.

[21 Jun 2021 12:18] MySQL Verification Team

Hello Meghana,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.25 but I am not seeing any issues at my end. Please upgrade to latest version. Thanks.

Regards,
Ashwini Patil