Hello:

I tried to load 10000000 records into my table with Monet V4.12.0 in MS Widows 2000 and I received next answer:

 

sql>COPY 10000000 RECORDS INTO modelo FROM "c:/tmp/modelo_10M.txt" USING DELIMITERS ';';

VirtualAlloc(0,80003072,MEM_COMMIT,PAGE_READWRITE): failed

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !GDKvmalloc(80000008) fail => BBPtrim(enter) usage[mem=1534256506,vm=1905000448]

#

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !mallinfo.arena = 14695166

        !mallinfo.ordblks = 24205

        !mallinfo.smblks = 3919

        !mallinfo.hblkhd = 0

        !mallinfo.hblks = 0

        !mallinfo.usmblks = 10975132

        !mallinfo.fsmblks = 2798024

        !mallinfo.uordblks = 856266

        !mallinfo.fordblks = 65744

#BBPTRIM_ENTER: memsize=1534256506,vmsize=1905000448

#BBPTRIM: memtarget=1073741824 vmtarget=1073741824

#TRIMSCAN: mem=1 vm=1, start=1, limit=1

#TRIMSCAN: end at 1 (size=1203)

#TRIMSELECT: dirty = 0

#TRIMSELECT: end

#TRIMSELECT: dirty = 1

#TRIMSELECT: end

#BBPTRIM: no more unload candidates!

#BBPTRIM_EXIT: memsize=1522425108,vmsize=1905000448

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !GDKvmalloc(80000008) fail => BBPtrim(ready) usage[mem=1534256506,vm=1905000448]

#

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !mallinfo.arena = 14695166

        !mallinfo.ordblks = 24205

        !mallinfo.smblks = 3919

        !mallinfo.hblkhd = 0

        !mallinfo.hblks = 0

        !mallinfo.usmblks = 10975132

        !mallinfo.fsmblks = 2798024

        !mallinfo.uordblks = 856266

        !mallinfo.fordblks = 65744

VirtualAlloc(0,80003072,MEM_COMMIT,PAGE_READWRITE): failed

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !GDKmmap(80216064) fail => BBPtrim(enter) usage[mem=1534256506,vm=1905000448]

#

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !mallinfo.arena = 14695184

        !mallinfo.ordblks = 24205

        !mallinfo.smblks = 3919

        !mallinfo.hblkhd = 0

        !mallinfo.hblks = 0

        !mallinfo.usmblks = 10975132

        !mallinfo.fsmblks = 2798024

        !mallinfo.uordblks = 856428

        !mallinfo.fordblks = 65600

#BBPTRIM_ENTER: memsize=1534256506,vmsize=1905000448

#BBPTRIM: memtarget=0 vmtarget=1073741824

#TRIMSCAN: mem=0 vm=1, start=1, limit=1

#TRIMSCAN: end at 1 (size=1203)

#TRIMSELECT: dirty = 0

#TRIMSELECT: end

#TRIMSELECT: dirty = 1

#TRIMSELECT: end

#BBPTRIM: no more unload candidates!

#BBPTRIM_EXIT: memsize=1522425108,vmsize=1905000448

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !GDKmmap(80216064) fail => BBPtrim(ready) usage[mem=1534256506,vm=1905000448]

#

MAPI  = monetdb@localhost:50000

QUERY = COPY 10000000 RECORDS INTO modelo347 FROM "c:/tmp/modelo347_10M.txt" USING DELIMITERS ';';

ERROR = !mallinfo.arena = 14695184

        !mallinfo.ordblks = 24205

        !mallinfo.smblks = 3919

        !mallinfo.hblkhd = 0

        !mallinfo.hblks = 0

        !mallinfo.usmblks = 10975132

        !mallinfo.fsmblks = 2798024

        !mallinfo.uordblks = 856428

        !mallinfo.fordblks = 65600

        !ERROR: HEAPalloc: Insufficient space for HEAP.

        !ERROR: MT_mmap: MapViewOfFile(294, 2, 0, 0, 80216064, 0) failed

        !OS: Not enough space

        !ERROR: MT_mmap: MapViewOfFile(298, 2, 0, 0, 80216064, 0) failed

        !OS: Not enough space

        !ERROR: GDKload: cannot mmap(): name=22\2262, ext=buns.priv

        !OS: Not enough space

        !ERROR: GDKload failed: name=22\2262, ext=buns.priv

        !ERROR: ASCIIcreate_bats: Failed to create bat of size 10000000

        !ERROR: mvc_import_table_wrap: operation failed.

Timer    8938.000 msec

 

My PC has 1 GByte of RAM.

 

Maybe, I need change some configuration parameters.

Any idea?