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: Assigned Account 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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.