I'm been trying to insert from file for over 322 files, totally 12GB with over 600 million rows. The RJDBC connection hangs after 350 million row. I noticed the VSIZE in Activity Monitor is 30.85GB, closer to 32GB system memory. Is this the reason that I cannot connect to the database? What should I do?
# MonetDB server v5.8.4, based on kernel v1.26.4
# Serving database 'bigdata', using 8 threads
# Compiled for i386-apple-darwin9.6.0/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008- MonetDB B.V., all rights reserved
#warning: please don't forget to set your vault key!
#(see /Users/someuser/MonetDB64/etc/monetdb5.conf)
# MonetDB/SQL module v2.26.4 loaded
>!ERROR: GDKsave: failed name=24/2460, ext=tail, mode 0
!ERROR: GDKsave: failed name=23/2317, ext=tail, mode 0
!ERROR: GDKsave: failed name=25/2503, ext=tail, mode 0
!ERROR: GDKsave: failed name=26/2657, ext=tail, mode 0
!ERROR: GDKsave: failed name=22/2274, ext=tail, mode 0
!ERROR: GDKsave: failed name=22/2224, ext=tail, mode 0
!ERROR: GDKsave: failed name=01/112, ext=head, mode 0
!ERROR: logger_exit: could not open /Users/someuser/MonetDB64/var/MonetDB5/sql_logs/bigdata/sql/log
Many thanks.