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
kelianh