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