On Tue, Jun 17, 2008 at 07:06:24PM +0100, Sam Mason wrote:
On Fri, Jun 13, 2008 at 06:06:59PM +0200, Niels Nes wrote:
It seems you hit a bug in MonetDB/SQL. Could you file a bug report on the sourceforge bug tracker. This way we can keep track of this issue.
Which bug did this apply to? it looks from the follow-up message that you've fixed the other bug already as well. I've found some other things and I'll report them to the sf bug tracker.
The problem you have with loading should be fixed in the new (bound te be released) version (ie June-2008 release). Please check out that version, for example compile a version using the monetdb-install.sh script (see http://monetdb.cwi.nl/projects/monetdb//download.php?target=/projects/monetd...)
After suffering a disk crash I've finally got back to this. I've built a "nightly" stable version, generated the data again in the correct format and tried to perform the COPY in again. It still fails when running:
COPY INTO source_livestock FROM '/mnt/scratch/smason/source_livestock' DELIMITERS ','; !SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=16/1634, ext=theap !OS: Cannot allocate memory !ERROR: GDKload failed: name=16/1634, ext=theap
Would you expect me to get this still? and hence should I provide more details or should I be building something else?
What could help is to specify your number of records, ie COPY xx RECORDS INTO ... Where xx is the correct number of records ( or some more). This way monet knows directly howmuch memory is needed (ie less allocation and less fragmentation). Niels
Thanks, Sam
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl