Bug #5200 invalid access errors while performing select sql
Submitted: 25 Aug 2004 9:23 Modified: 1 Dec 2004 13:43
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:mysql-query-browser-1.0.5-alpha-win-noin OS:Windows (Win 2000 ad svr)
Assigned to: Michael G. Zinner CPU Architecture:Any

[25 Aug 2004 9:23] [ name withheld ] 
Description:
While performing select statements (eg. select * from table) on a database with 1 million records, the errors will show.

How to repeat:
create a database with approx 1 million rows. and perform "select * from tablename".

Suggested fix:
i suspect memory leakage.  not sure how to fix it though.
[25 Aug 2004 16:31] Michael G. Zinner 
Did you stop the fetching of the rows after some time or did you try to fetch all 1.000.000 rows? We need to keep all 1.000.000 rows in memory because the server doesn't support updateable cursors yet.

So this might be due to the fact that your machine is running out of memory. Could you open the Task Manager and monitor the memory usage?

Thanks.
[26 Aug 2004 5:36] [ name withheld ] 
there are total about 200k records. i got this error when the query executes halfway.

Attachment: mysqlerr2.jpg (image/pjpeg, text), 93.40 KiB.
[26 Aug 2004 5:41] [ name withheld ] 
the error occured while fetching records. I'm not sure if there is out of memory situation - mem usage barely at 80%. I've attached a snapshot of the error. perhaps it could help.

if it helps, i have > 2gigs of disk space left and using 512mb ram. 

I might be wrong, but it appears the problem occurs more often if i shift the scroller bar while it is running.
[26 Aug 2004 9:52] Michael G. Zinner 
Could you verify if this issue has been addressed in the latest 1.0.6 release of QB that was uploaded yesterday? We improved the synchronisation between the display and the thread fetching new rows.

Thanks a lot!