Bug #114827 Crash when creating or altering table
Submitted: 30 Apr 2024 16:58 Modified: 2 Jun 2024 11:23
Reporter: John Patterson Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.33 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[30 Apr 2024 16:58] John Patterson
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\cc102275\AppData\Roaming\MySQL\Workbench\log\wb.log]

Created a table with the following characteristics using the "create table" function available in the UI. Creation was successful, but Workbench crashed without warning, no error messages. I reopened Workbench and confirmed the table was created, but when attempting to "alter table" using the UI function, Workbench crashed again. I can select rows from the as yet empty table.

Relevant Windows event viewer logs included below table.

# table_schema, table_name, column_name, column_default, is_nullable, data_type, character_maximum_length, column_type, is_generated
debra, request_type_inputs, id, , NO, int, , int(11), NEVER
debra, request_type_inputs, request_types, NULL, YES, longtext, 4294967295, longtext, NEVER
debra, request_type_inputs, prompt, NULL, YES, varchar, 100, varchar(100), NEVER
debra, request_type_inputs, prompt_class, NULL, YES, varchar, 75, varchar(75), NEVER
debra, request_type_inputs, name, NULL, YES, varchar, 75, varchar(75), NEVER
debra, request_type_inputs, name_class, NULL, YES, varchar, 75, varchar(75), NEVER
debra, request_type_inputs, input_type, NULL, YES, varchar, 75, varchar(75), NEVER
debra, request_type_inputs, input_id, NULL, YES, varchar, 75, varchar(75), NEVER
debra, request_type_inputs, input_attributes, NULL, YES, longtext, 4294967295, longtext, NEVER
debra, request_type_inputs, parent_id, NULL, YES, int, , int(11), NEVER
debra, request_type_inputs, html, NULL, YES, longtext, 4294967295, longtext, NEVER
debra, request_type_inputs, script, NULL, YES, longtext, 4294967295, longtext, NEVER

Log Name:      Application
Source:        .NET Runtime
Date:          4/30/2024 12:21:42 PM
Event ID:      1026
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      [redacted].cc.[redacted].com
Description:
Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
   at <Module>.mforms.MenuItem.callback(mforms.MenuItem*)
   at MenuItemEventTarget.MenuItemClick(System.Object, System.EventArgs)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(System.Object, System.EventArgs)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(System.EventArgs)
   at System.Windows.Forms.ToolStripItem.HandleClick(System.EventArgs)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.ToolStrip.OnMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.ToolStrip.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.ToolStripDropDown.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
   at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)
   at MySQL.GUI.Workbench.Program.Main(System.String[])

Log Name:      Application
Source:        Application Error
Date:          4/30/2024 12:21:42 PM
Event ID:      1000
Task Category: Application Crashing Events
Level:         Error
Keywords:      
User:          CC\[redacted]
Computer:      [redacted].cc.[redacted].com
Description:
Faulting application name: MySQLWorkbench.exe, version: 8.0.33.0, time stamp: 0x641dc5ba
Faulting module name: db.mysql.parser.grt.dll, version: 0.0.0.0, time stamp: 0x641dc53f
Exception code: 0xc0000005
Fault offset: 0x000000000005d9bb
Faulting process id: 0x0x5374
Faulting application start time: 0x0x1DA9B1A62B6DBBB
Faulting application path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
Faulting module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\db.mysql.parser.grt.dll
Report Id: bcfd4ad5-5f01-4f98-86bd-a30e17498b53
Faulting package full name: 
Faulting package-relative application ID: 

How to repeat:
Create the offending table as above using the "create table" function, or, once it's created, select the "alter table" function.
[30 Apr 2024 20:38] John Patterson
I've just added a column with the json data type to a long-standing table and have experienced the same crash. Re-opening Workbench and inspecting the data type, it's listed as "longtext", which is expected.

I dropped the new column and re-added it with the "longtext" data type, and Workbench no longer crashes.
[2 May 2024 11:23] MySQL Verification Team
Hello John Patterson,

Thank you for the bug report.
Please note that we don't fix bugs in old versions, don't backport bug fixes, so you need to check with latest WB version. Hence, please upgrade WB to latest version and inform us if problem still exists.

Regards,
Ashwini Patil
[3 Jun 2024 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".