Bug #50922 Running query takes too long and then returns a single column as result

• Submitted: 4 Feb 2010 16:14
• Modified: 4 Mar 2010 17:03
• Reporter: Ola Ajibode
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.15 OSS Beta
• OS: Windows
• CPU Architecture: Any

[4 Feb 2010 16:14] Ola Ajibode

Description:
Exception = System.AccessViolationException
Message = Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
FullText = System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
   at MySQL.Grt.Db.Recordset.sort_by(Int32 column, Int32 direction, Boolean retaining)
   at MySQL.Grt.Db.RecordsetView.gridView_ColumnHeaderMouseClick(Object sender, DataGridViewCellMouseEventArgs e)
   at System.Windows.Forms.DataGridView.OnColumnHeaderMouseClick(DataGridViewCellMouseEventArgs e)
   at System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.DataGridView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Select from a table with over 100,000 records.  Make sure to order the record in descending order

[4 Feb 2010 16:18] Ola Ajibode

Select the "Fetch All" option to retrieve all results returned by select statement

[4 Feb 2010 17:03] MySQL Verification Team

Thank you for the bug report. Could you please provide more details about your environment (MySQL server version, show create table output and hardware description). I couldn't repeat with server 5.1.42 X64 and hardware:

System Type	x64-based PC
Processor	AMD Phenom(tm) 9650 Quad-Core Processor, 2300 Mhz, 4 Core(s), 4 Logical Processor(s)
Installed Physical Memory (RAM)	8,00 GB
Total Physical Memory	7,75 GB
Available Physical Memory	5,56 GB
Total Virtual Memory	15,6 GB

[5 Feb 2010 9:33] Sergei Tkachenko

Please also note if this bug is constantly repeatable or occurs from time to time.

[5 Mar 2010 0: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".