[MonetDB-users] copy into from a file hangs

Hi, I am evaluating MonetDB server v5.8.4, based on kernel v1.26.4 on FreeBSD 6.2 Loading data into a table from a file seem to hang, with mserver using high CPU. The file has only 10 records. If I use stdin instead of a file name the data can be loaded. Here is the debug output. openRead(nil) does not seem right. shouldn't it be openRead('/tmp/head.txt') ? sql>debug copy 10 records into "log_0" from '/tmp/head.txt' using delimiters '|'; mdb># mdb.start(); mdb>n mdb># user.s0_2(); mdb>n mdb># _2 := streams.openRead(nil); mdb>n What am I doing wrong? Thanks for your help, -VG

Hi Venu, On Tue, May 05, 2009 at 05:36:54PM -0700, Venu Alatzeth wrote:
Hi,
I am evaluating MonetDB server v5.8.4, based on kernel v1.26.4 on FreeBSD 6.2
MonetDB server v5.8.4, based on kernel v1.26.4, i.e., the Nov2008-SP2 release is rather old. I'd recommend to upgrade to the latest Feb2009-SP2 release; cf., http://monetdb.cwi.nl/Development/Releases/Feb2009/ and http://monetdb.cwi.nl/Download/
Loading data into a table from a file seem to hang, with mserver using high CPU.
The file has only 10 records. If I use stdin instead of a file name the data can be loaded.
Here is the debug output. openRead(nil) does not seem right. shouldn't it be openRead('/tmp/head.txt') ?
sql>debug copy 10 records into "log_0" from '/tmp/head.txt' using delimiters '|'; mdb># mdb.start(); mdb>n mdb># user.s0_2(); mdb>n mdb># _2 := streams.openRead(nil); mdb>n
What am I doing wrong?
Nothing obvious --- you might ust hit a "strange" bug in the Nov2008-SP2 release. Please upgrade to the latest Feb2009-SP2 release, try again, and report your findings. Stefan
Thanks for your help,
-VG
------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | 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 |
participants (2)
-
Stefan Manegold
-
Venu Alatzeth