hello, The tables do not have any constrains. And the disk space used only 5%,the total size is 1.2TB. This error relates to the mmap function , when I type 'ulimit -a': I find the virtual memory was set only 20GB by default. So I change it to unlimited. Then I load sf100 again. It works. Thx, keliang 在 2013-5-15，18:00，developers-list-request@monetdb.org 写道：

Send developers-list mailing list submissions to developers-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit http://mail.monetdb.org/mailman/listinfo/developers-list or, via email, send a message with subject or body 'help' to developers-list-request@monetdb.org

You can reach the person managing the list at developers-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of developers-list digest..."

Today's Topics:

1. The crash of loading data (??) 2. Re: The crash of loading data (Sjoerd Mullender) 3. Re: The crash of loading data (Stefan Manegold) 4. In SQL functions, how to fetch table field value to a variable and how to execute dynamic statement? (liyuesen 00108910) 5. Re: In SQL functions, how to fetch table field value to a variable and how to execute dynamic statement? (Niels Nes)

----------------------------------------------------------------------

Message: 1 Date: Tue, 14 May 2013 20:29:08 +0800 From: ?? To: developers-list@monetdb.org Subject: The crash of loading data Message-ID: Content-Type: text/plain; charset="iso-8859-1"

Hello, I'm trying to load SF100 data into MonetDB but it crashed. My server:

64bit openSUSE 11.3 mem: 47GB swap: 1GB disk: 1.2T monetDB: 11.15.3

I use DBgen to generate my data. when I'm in a client I execute a script, after a few minutes, the monetDB was crashed.

get some error msg like this: HEAPextend failed to extend to XXX for XXXX

my script file : COPY records into from nation.tbl using ...; COPY records into from region.tbl using ...; COPY records into from customer.tbl using ...; COPY records into from part.tbl using ...; COPY records into from ...; COPY records into from ...; COPY records into from ...;

Does anybody know what's reason for this error ? and how can i overcome this error? Any help would be most welcome:)

Thx, keliang