Bug #98857 MySQL Workbench 8.0.19 (build 15713499 CE 64 bits) crash (Windows 10)
Submitted: 6 Mar 2020 12:41 Modified: 21 May 2020 12:16
Reporter: Hector Hernandez Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.19 OS:Windows (Windows 10 x64)
Assigned to: MySQL Verification Team CPU Architecture:Other (x64 corei7-7700K)
Tags: MySQL;MySql Workbench;Windows 10 x64

[6 Mar 2020 12:41] Hector Hernandez
Description:
After build a temporary table, with near 260000 records, I leave to build a text file (it takes near 3 hours).  Fortunately the file was full built, but after few minutes, MySQL Workbench was closed in unexpected way.  When I saw the windows event logs, I saw the crash report due System.AccessViolationException.

How to repeat:
The script is like follows:

CREATE TEMPORARY TABLE IF NOT EXISTS Lista_Expedientes AS
( SELECT distinct Expediente, RUC FROM companylist );

-- La generaciĆ³n del archivo puede tomar 3 horas.
SELECT A.expediente, B.RUC, CONCAT(A.expediente, A.identificacion), 0, A.identificacion, A.nombreaccionista, 
       A.nacionalidad, A.tipoinversion, FORMAT(A.valor, 2, 'en_US'), A.restriccion, '2020-03-05 23:12:00'
  FROM socios_directo_temp as A LEFT JOIN Lista_Expedientes AS B ON (A.expediente = B.Expediente)
  -- GROUP BY A.expediente
  ORDER BY A.expediente
INTO OUTFILE 'E:/ProgramData/MySQL/MySQL Server 8.0/Uploads/ArmajeDeSocios_20200305.tsv'
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

DROP TABLE Lista_Expedientes;

The temporary table has near 260000 unique records.

The text file takes, in generation, near 3 hours, then I mark this script and run.  Of course, I leave the program alone during the execution.

----------------------------------------------------
Details for the windows application event log:

(reported on 2020/03/06 01:52:23) source: .NET Runtime, EventID: 1026
Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
   at MySQL.Grt.GridModelWrapper.get_field_repr(MySQL.Grt.NodeIdWrapper, Int32, System.String ByRef)
   at MySQL.Controls.GridView.OnCellValueNeeded(System.Windows.Forms.DataGridViewCellValueEventArgs)
   at System.Windows.Forms.DataGridView.OnCellValueNeeded(Int32, Int32)
   at System.Windows.Forms.DataGridViewCell.GetValue(Int32)
   at System.Windows.Forms.DataGridView.OnCellValidating(System.Windows.Forms.DataGridViewCell ByRef, Int32, Int32, System.Windows.Forms.DataGridViewDataErrorContexts)
   at System.Windows.Forms.DataGridView.CommitEdit(System.Windows.Forms.DataGridViewCell ByRef, System.Windows.Forms.DataGridViewDataErrorContexts, DataGridViewValidateCellInternal, Boolean, Boolean, Boolean, Boolean, Boolean)
   at System.Windows.Forms.DataGridView.EndEdit(System.Windows.Forms.DataGridViewDataErrorContexts, DataGridViewValidateCellInternal, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean)
   at System.Windows.Forms.DataGridView.CommitEditForOperation(Int32, Int32, Boolean)
   at System.Windows.Forms.DataGridView.ScrollIntoView(Int32, Int32, Boolean)
   at System.Windows.Forms.DataGridView.set_CurrentCell(System.Windows.Forms.DataGridViewCell)
   at MySQL.Controls.GridView.ProcessModelRowsChange()
   at <Module>.boost.detail.function.void_function_invoker0<void (__cdecl*)(void),void>.invoke(__cdecl*)(void),void>.invoke(boost.detail.function.function_buffer*)
   at <Module>.DbSqlEditorHistory.current_entry(DbSqlEditorHistory*, Int32)
   at MySQL.GUI.Workbench.SqlIdeForm.historyEntriesView_RowEnter(System.Object, System.Windows.Forms.DataGridViewCellEventArgs)
   at System.Windows.Forms.DataGridView.OnRowEnter(System.Windows.Forms.DataGridViewCellEventArgs)
   at System.Windows.Forms.DataGridView.OnRowEnter(System.Windows.Forms.DataGridViewCell ByRef, Int32, Int32, Boolean, Boolean)
   at System.Windows.Forms.DataGridView.SetCurrentCellAddressCore(Int32, Int32, Boolean, Boolean, Boolean)
   at System.Windows.Forms.DataGridView.set_CurrentCell(System.Windows.Forms.DataGridViewCell)
   at MySQL.Controls.GridView.ProcessModelRowsChange()
   at MySQL.GUI.Workbench.SqlIdeForm.ProcessModelHistoryEntryRowsChange()
   at <Module>.boost.detail.function.void_function_invoker0<void (__cdecl*)(void),void>.invoke(__cdecl*)(void),void>.invoke(boost.detail.function.function_buffer*)
   at <Module>.wb.WBContext.flush_idle_tasks(wb.WBContext*, Boolean)
   at MySQL.Workbench.WbContext.flush_idle_tasks(Boolean)
   at MySQL.GUI.Workbench.Program.timer_Tick(System.Object, System.EventArgs)
   at System.Windows.Forms.Timer.OnTick(System.EventArgs)
   at System.Windows.Forms.Timer+TimerNativeWindow.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[])

(reported on 2020/03/06 01:52:23) source: Application Error, EventID: 1000
Faulting application name: MySQLWorkbench.exe, version: 8.0.19.0, time stamp: 0x5df6944b
Faulting module name: wbpublic.be.dll, version: 0.0.0.0, time stamp: 0x5df691dd
Exception code: 0xc0000005
Fault offset: 0x0000000000160c74
Faulting process id: 0x630
Faulting application start time: 0x01d5f317db2ff7b5
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\wbpublic.be.dll
Report Id: 41d0d72e-c77f-46bc-a180-bd7d8ab986bd
Faulting package full name: 
Faulting package-relative application ID: 

Suggested fix:
Perhaps a new MySQL Workbench 8.0.19 update.
[21 Apr 2020 12:16] MySQL Verification Team
Hello Hector Hernandez,

Thank you for the bug report.
Please provide us sample data demonstrating the problem, table with insert statements. Thanks.

Regards,
Ashwini Patil
[22 May 2020 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".