[MonetDB-users] Can not allocate memory, MonetDB5
Hi I've just downloaded a new version of MonetDB a few days ago and started testing it.. I tried inserting a 2.6G data file (12 columns, 32 million rows) and it works fine. But when I added 4 more columns of data to that data file (of type bigint, bringing the file size up to 3.9G), it fails saying !SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=20/2023, ext=tail.priv !OS: Cannot allocate memory !ERROR: GDKload failed: name=20/2023, ext=tail.priv I tried searching for similar problem, but only found it for older versions of MonetDB. Is this still an issue in the current version? Thank you. -- View this message in context: http://www.nabble.com/Can-not-allocate-memory%2C-MonetDB5-tp16019364p1601936... Sent from the monetdb-users mailing list archive at Nabble.com.
On 12-03-2008 18:24:09 -0700, forte712 wrote:
Hi
I've just downloaded a new version of MonetDB a few days ago and started testing it..
I tried inserting a 2.6G data file (12 columns, 32 million rows) and it works fine.
But when I added 4 more columns of data to that data file (of type bigint, bringing the file size up to 3.9G), it fails saying
!SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=20/2023, ext=tail.priv !OS: Cannot allocate memory !ERROR: GDKload failed: name=20/2023, ext=tail.priv
Can you post the output of `mserver5 --version` please?
On Thu, Mar 13, 2008 at 10:05:22AM +0100, Fabian Groffen wrote:
On 12-03-2008 18:24:09 -0700, forte712 wrote:
Hi
I've just downloaded a new version of MonetDB a few days ago and started testing it..
I tried inserting a 2.6G data file (12 columns, 32 million rows) and it works fine.
But when I added 4 more columns of data to that data file (of type bigint, bringing the file size up to 3.9G), it fails saying
!SQLException:importTable:failed to import table !ERROR: GDKload: cannot mmap(): name=20/2023, ext=tail.priv !OS: Cannot allocate memory !ERROR: GDKload failed: name=20/2023, ext=tail.priv
Can you post the output of `mserver5 --version` please?
In addition, please also provide us with some information about the system you're using, in particular: operating system, 32-bit or 64-bit architecture, main memory size, available disk space. Stefan -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
Thanks for the replies MonetDB server v5.4.0 (32-bit), based on kernel v1.22.0 (32-bit oids) Copyright (c) 1993-2007 CWI, all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /root/MonetDB Libraries: openssl: OpenSSL 0.9.7a Feb 19 2003 (compiled with OpenSSL 0.9.7a Feb 19 2003) Compiled by: root@AppMon9001 Compilation: gcc -g -O2 -std=c99 Linking : /usr/bin/ld Operating system is Fedora Core Release 3 (32-bit) Memory: 2G Disk Size: 200G, Used: ~110G -- View this message in context: http://www.nabble.com/Can-not-allocate-memory%2C-MonetDB5-tp16019364p1603952... Sent from the monetdb-users mailing list archive at Nabble.com.
On Thu, Mar 13, 2008 at 03:09:33PM -0700, forte712 wrote:
Thanks for the replies
MonetDB server v5.4.0 (32-bit), based on kernel v1.22.0 (32-bit oids) Copyright (c) 1993-2007 CWI, all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /root/MonetDB Libraries: openssl: OpenSSL 0.9.7a Feb 19 2003 (compiled with OpenSSL 0.9.7a Feb 19 2003) Compiled by: root@AppMon9001 Compilation: gcc -g -O2 -std=c99 Linking : /usr/bin/ld
Operating system is Fedora Core Release 3 (32-bit) Memory: 2G Disk Size: 200G, Used: ~110G
The 32 bit is the problem here, a too limited adress space. Niels
-- View this message in context: http://www.nabble.com/Can-not-allocate-memory%2C-MonetDB5-tp16019364p1603952... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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
participants (4)
-
Fabian Groffen -
forte712 -
Niels Nes -
Stefan Manegold