[root@monetdb MonetDB]# more mero* 2010-04-21 13:21:12 MSG merovingian[12373]: Merovingian 1.2 starting 2010-04-21 13:21:12 MSG merovingian[12373]: monitoring dbfarm /var/MonetDB5/db farm 2010-04-21 13:21:12 MSG merovingian[12373]: listening for TCP connections on 0 .0.0.0:50000 2010-04-21 13:21:12 MSG discovery[12373]: listening for UDP messages on 0.0.0. 0:50000 2010-04-21 13:21:12 MSG control[12373]: handling commands over UNIX socket /va r/MonetDB5/dbfarm/.merovingian_control 2010-04-21 13:21:12 MSG control[12373]: listening for TCP connections on 0.0.0 .0:50001 2010-04-21 13:21:16 MSG control[12373]: (local): created database 'demo' 2010-04-21 13:21:21 MSG control[12373]: (local): released database 'demo' 2010-04-21 13:21:33 MSG merovingian[12373]: starting database 'demo', up min/a vg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0) 2010-04-21 13:21:33 MSG merovingian[12373]: proxying client localhost:44278 fo r database 'demo' to mapi:monetdb://127.0.0.1:50002/demo 2010-04-21 13:21:33 MSG demo[12380]: arguments: /usr/bin/mserver5 --config=/et c/monetdb5.conf --dbname=demo --dbinit=include sql; --set merovingian_uri=mapi :monetdb://monetdb:50000/demo --set monet_daemon=yes --set mapi_open=false --s et mapi_autosense=true --set mapi_port=50001 --set monet_vault_key=/var/MonetD B5/dbfarm/demo/.vaultkey --set sql_optimizer=default_pipe 2010-04-21 13:21:33 MSG demo[12380]: # MonetDB server v5.18.3, based on kernel v1.36.3 2010-04-21 13:21:33 MSG demo[12380]: # Serving database 'demo', using 16 threa ds 2010-04-21 13:21:33 MSG demo[12380]: # Compiled for x86_64-redhat-linux-gnu/64 bit with 64bit OIDs dynamically linked 2010-04-21 13:21:33 MSG demo[12380]: # Found 47.259 GiB available main-memory. 2010-04-21 13:21:33 MSG demo[12380]: # Copyright (c) 1993-July 2008 CWI. 2010-04-21 13:21:33 MSG demo[12380]: # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved 2010-04-21 13:21:33 MSG demo[12380]: # Visit http://monetdb.cwi.nl/ for furthe r information 2010-04-21 13:21:33 MSG demo[12380]: # Listening for connection requests on ma pi:monetdb://127.0.0.1:50002/ 2010-04-21 13:21:33 MSG demo[12380]: # MonetDB/SQL module v2.36.3 loaded 2010-04-21 13:24:01 MSG merovingian[12373]: client localhost:44278 has disconn ected from proxy 2010-04-21 13:24:07 MSG merovingian[12373]: proxying client localhost:53092 fo r database 'demo' to mapi:monetdb://127.0.0.1:50002/demo 2010-04-21 13:24:21 MSG merovingian[12373]: client localhost:53092 has disconn ected from proxy 2010-04-21 13:24:21 MSG merovingian[12373]: database 'demo' (12380) was killed by signal 11 [root@monetdb MonetDB]# (using merovingian) Thanks. Dariusz. Fabian Groffen wrote:
On 21-04-2010 13:07:37 -0400, dariuszs wrote:
Hi, It looks like the same problem exists no matter what the OS (Fedora 12 or Ubuntu 9.10 or Windows) and this worked in Nov2009-SP1 release. When you try: sql>copy select * from table1 limit 1000 into '/tmp/output.txt'; MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select * from table1 limit 1000 into '/tmp/output.txt'; ERROR = !Connection terminated Timer 1105.876 msec
please check your merovingian.log or provide us with the console output of the mserver5 process.
[root@monetdb /]# mserver5 --version MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 47.3GiB available memory, 16 available cpu cores Configured for prefix: /usr Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0-beta4 10 Nov 2009 (compiled with OpenSSL 1.0.0-fips-beta4 10 Nov 2009) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: mockbuild@ (x86_64-redhat-linux-gnu) Compilation: gcc -O2 -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize Linking : ld -IPA -m elf_x86_64
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users