MySQL Bugs: #60153: Can't run query returning lots of rows

Bug #60153	Can't run query returning lots of rows
Submitted:	16 Feb 2011 22:14	Modified:	21 Mar 2018 22:51
Reporter:	Lee Marshall	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.2.31, 5.2.33	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
I did a query that took a couple minutes and generated several thousand rows--maybe 10,000.  I clicked the toggle to get more than the first 1000.  "Toggle limitation of the records number."  Workbench reported an error--a memory access violation.

I restarted Workbench and now I get, "Invoke or BeginInvoke cannot be called on a control until the window handle has been created.

If it matters, I'm using SSL tunneling. 

It would be nice if the error screen would pass the information it has to the web page.  It would be nice if the text of the error screen were copyable.

I get no meaningful feedback after pressing the button "Toggle limitation of the records number."  Eventually, the cursor changes to an hourglass.

How to repeat:
Well, you may need my data set.  It's about 10GB.  The query I was executing was select count(*), date(date), site_id, slot from impressions
group by 2,3,4;

I don't know what else to say.

Can you ty again with most recent version? While the latest version might still have problems with datasets that large, it should not have problems upon (re-)start. if it happens again, can you check in taskmanager if there are orphaned processes of workbench running which might prevent it from starting again?
thanks in advance

I installed and retested on 5.2.33.  Rather than crashing on clicking the "Toggle limitation of the records number" button, MySQL Workbench hung.  After about an hour, I terminated it.  Workbench started fine.

More data:  In 
select count(*), date(date), site_id, slot from impressions group by 2,3,4;
date(date) has maybe 700-100 values.  Site_id and slot id each have about 5.

This query:
select count(*)
from
(
select count(*), date(date), site_id, slot from impressions group by 2,3,4
) x

returns 17333.  So that's how many rows I was trying to load in Workbench.

Please, send the output of Help > System Info menu item.

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

Sorry for dropping the ball on this.  Here is the information requested.

Please note that I will be leaving my current company in a week and a half and may not be able to provide further follow-up information on this case.

MySQL Workbench CE for Windows version 5.2.33

Configuration Directory: C:\Documents and Settings\lmarshall.ICTV\Application Data\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 2.1.2

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 4x Intel(R) Core(TM)2 Quad  CPU   Q9450  @ 2.66GHz, 2.0 GiB RAM

Active video adapter: NVIDIA GeForce 8600 GT 

Installed video RAM: 256 MB

Current video mode: 1680 x 1050 x 4294967296 colors

Used bit depth: 32

Driver version: 6.14.11.7824

Installed display drivers: nv4_disp.dll

Current user language: English (United States)

Thanks a lot for your input Marshall.

Microsoft crash report

Attachment: Report.wer (application/octet-stream, text), 28.70 KiB.

I'm having a similar crash - but Workbench starts up fine after it dies - might fit on different bug ticket?

30GB database want more than 1000 rows returned 
Click toggle limitation of the records number
Workbench hangs with hourglass top of window ="MySQL Workbench (Not Responding)
Crashes after 5-15 minutes

Doesn't seem to be consuming an unreasonable amount of resources.

Help -> About
-------------------------------------------------

Event Viewer Errors
-------------------------------------------------
Each time it crashes these 2 errors show up:
First this-
Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0000005, exception address 77CB44EC

Followed by this -
Faulting application name: MySQLWorkbench.exe, version: 5.2.40.8790, time stamp: 0x4fa2f938
Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec49b8f
Exception code: 0xc0000005
Fault offset: 0x000344ec
Faulting process id: 0x2558
Faulting application start time: 0x01cd718dabc72f17
Faulting application path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\MySQLWorkbench.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: 7bdbbe0f-dd82-11e1-8d6b-402cf4766a78

Then this Information log-
Fault bucket 2977874972, type 5
Event Name: FaultTolerantHeap
Response: Not available
Cab Id: 0
Problem signature:
P1: MySQLWorkbench.exe
P2: 5.2.40.8790
P3: 4FA2F938
P4: ffffbaad
P5: 
P6: 
P7: 
P8: 
P9: 
P10: 
Attached files:
C:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp\FTHFCF.tmp\fthempty.txt
These files may be available here:
Analysis symbol: 
Rechecking for solution: 0
Report Id: 8dca276e-dd80-11e1-8d6b-402cf4766a78
Report Status: 0

And preceded by this-
Fault bucket 2989598284, type 1
Event Name: APPCRASH
Response: Not available
Cab Id: 0
Problem signature:
P1: MySQLWorkbench.exe
P2: 5.2.40.8790
P3: 4fa2f938
P4: ntdll.dll
P5: 6.1.7601.17725
P6: 4ec49b8f
P7: c0000005
P8: 00033ab3
P9: 
P10: 
Attached files:
C:\Users\ewn3\AppData\Local\Temp\WER3D80.tmp.WERInternalMetadata.xml
These files may be available here:
C:\Users\ewn3\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_MySQLWorkbench.e_3ea7526294b4e801a183aebb293a0411e12931a_137a8bd1
Analysis symbol: 
Rechecking for solution: 0
Report Id: fdc33f30-dcf0-11e1-8d6b-402cf4766a78
Report Status: 0

MSINFO32 
-------------------------------------------------
OS Name	Microsoft Windows 7 Enterprise
Version	6.1.7601 Service Pack 1 Build 7601
Other OS Description 	Not Available
OS Manufacturer	        Microsoft Corporation
System Name	        ERIC-NORD
System Manufacturer	Hewlett-Packard
System Model	        HP EliteBook 8460p
System Type        	x64-based PC
Processor	        Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz, 2301 Mhz, 2 Core(s), 4 Logical Processor(s)
BIOS Version/Date	Hewlett-Packard 68SCF Ver. F.08, 8/26/2011
SMBIOS Version	        2.6
Windows Directory	C:\Windows
System Directory	C:\Windows\system32
Boot Device	        \Device\HarddiskVolume1
Locale	                United States
HAL                	Version = "6.1.7601.17514"
User Name	        BYU\ewn3
Time Zone	        Mountain Daylight Time
Installed Memory (RAM)	8.00 GB
Total Physical Memory	7.95 GB
Available Memory	4.54 GB
Total Virtual Memory	15.9 GB
Avail Virtual Memory	11.9 GB
Page File Space        	7.95 GB
Page File	        C:\pagefile.sys

Help -> About
5/3/40 CE
Revision 8790

Fixed Synopsis

Please try the 64bit package for Windows. This should allow working with larger resultsets.

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

Posted by developer:
 
Bug could not be reproduced. No changelog entry needed.