Re: developers-list Digest, Vol 9, Issue 6

15 May 2013

      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

Re: developers-list Digest, Vol 9, Issue 6

kelianh