[MonetDB-users] sql/jdbcclient...Exception in thread "main' java.lang.OutOfMemoryError
I'm using Suse 10.1 with an AMD dual core processor and 850MB memory (note: There's 1000MB of ram but 150MB is shared with the video card thus leaving the system to recognize only 850MB) MonetDB softwares used are the packages presently posted on:
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/SuS...
With the table, "test" having 4 million rows using sql and jdbcclient:
geo->select column1 from test;
It displays the column1 query results for about 10 seconds and then the jdbcclient-1.4.jar crashes leaving the following message before it bugs out:
Exception in thread "main" java.lang.OutOfMemeoryError
I tried many many combinations of java options concerning memory and gc to try to fix it but in my hands, no luck.
I worked around this by switching to the MapiClient which works just fine.
Just thought there might be some interest in these results.
Thanks to everyone again.....George
On 26-09-2006 10:18:15 -0700, George H wrote:
With the table, "test" having 4 million rows using sql and jdbcclient:
geo->select column1 from test;
It displays the column1 query results for about 10 seconds and then the jdbcclient-1.4.jar crashes leaving the following message before it bugs out:
Exception in thread "main" java.lang.OutOfMemeoryError
Does it give a clue in the stack trace? I think I already know what blows it up.
I tried many many combinations of java options concerning memory and gc to try to fix it but in my hands, no luck.
I'll try and see if I can patch it up, with 4 milion rows my anticipatory block size incrementing reaches a point of no more memory :)
I worked around this by switching to the MapiClient which works just fine.
Does it show you the 4 milion rows, or just a subset of it?
participants (2)
-
Fabian Groffen -
George H