It does not show any message just "Connection Terminated" in the client window (shown below)
read_line:##TRIMSCAN: 13810 120=tmp_462 (#0)
fetch next block: start at:8200
MAPI = monetdb@localhost:50000
ACTION= read_line
QUERY = COPY 15000000 RECORDS INTO orders FROM 'C:/tpch/orders.tbl' USING DELIMITERS '|';
ERROR = Connection terminated
closing result set
Timer 589110.000 msec
Also I specified the exact number of records in the COPY statement in this case 15,000,000 (around 1.7GB).
On 27/10/2007, Stefan Manegold <Stefan.Manegold@cwi.nl> wrote:
On Sat, Oct 27, 2007 at 05:45:56AM -0700, algatt wrote:
>
> I am using MonetDB 5.0.0 and 1GB Ram on Windows XP. I am trying to use the
> TPC-H benchmark.
>
> With 1GB of test data everything worked fine, but if I try to load a table
> with more than 1GB of data the server crashes. Does this happen due to the
> 1GB of RAM?
how does the server crash?
Segfault? any error message? ...?
> Also, when I use the number of records with the COPY command it copies more
> records.
more than you specify with the COPY command or more than there are in the
file that you copy/load from?
Stefan
> Any pointers?
>
> Thanks
--
| 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 |
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users