Alternative method works with some hickups [root@monetdb MonetDB]# monetdb create demo created database in maintenance mode: demo [root@monetdb MonetDB]# monetdb set optpipe=inline,remap,deadcode,multiplex demo [root@monetdb MonetDB]# monetdb release demo taken database out of maintenance mode: demo [root@monetdb MonetDB]# mclient -lsql -d demo user(root):monetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.18.3, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>\< /vol2/monetdb_data/masters/trw100_sample.sql auto commit mode: on 5000000 affected rows sql>copy select * from trw100 limit 10000 into '/tmp/f1.txt'; 10000 affected rows sql>\q [root@monetdb MonetDB]# mclient -lsql -d demo user(root):monetdb password: Connection terminated [root@monetdb MonetDB]# mclient -lsql -d demo user(root):monetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.18.3, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>copy select * from trw100 limit 10000 into '/tmp/f1.txt'; 10000 affected rows sql> merovingian.log (partial) [root@monetdb MonetDB]# tail -n100 mero* 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5220000-7f67c541f000 ---p 00004000 fd:00 396354 /usr/lib64/MonetDB5/lib/lib_blob.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c541f000-7f67c5420000 rw-p 00003000 fd:00 396354 /usr/lib64/MonetDB5/lib/lib_blob.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5420000-7f67c52010-04-21 14:35:13 ERR demo[12692]: 425000 r-xp 00000000 fd:00 396441 /usr/lib64/MonetDB5/lib/lib_mkey.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5425000-7f67c5624000 ---p 00005000 fd:00 396441 /usr/lib64/MonetDB5/lib/lib_mkey.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5624000-7f67c5625000 rw-p 00004000 fd:00 396441 /usr/lib64/MonetDB5/lib/lib_mkey.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5625000-7f67c566b000 r-xp 00000000 fd:00 396459 /usr/lib64/MonetDB5/lib/lib_pqueue.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c566b000-7f67c586a000 ---p 00046000 fd:00 396459 /usr/lib64/MonetDB5/lib/lib_pqueue.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c586a000-7f67c586b000 rw-p 00045000 fd:00 396459 /usr/lib64/MonetDB5/lib/lib_pqueue.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c586b000-7f67c5871000 r-xp 00000000 fd:00 396318 /usr/lib64/MonetDB5/lib/lib_array.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5871000-7f67c5a70000 ---p 00006000 fd:00 396318 /usr/lib64/MonetDB5/lib/lib_array.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5a70000-7f67c5a71000 rw-p 00005000 fd:00 396318 /usr/lib64/MonetDB5/lib/lib_array.2010-04-21 14:35:13 ERR demo[12692]: so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5a71000-7f67c5e99000 r-xp 00000000 fd:00 396306 /usr/lib64/MonetDB5/lib/lib_aggr.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c5e99000-7f67c6099000 ---p 00428000 fd:00 396306 /usr/lib64/MonetDB5/lib/lib_aggr.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6099000-7f67c609a000 rw-p 00428000 fd:00 396306 /usr/lib64/MonetDB5/lib/lib_aggr.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c609a000-7f67c615e000 r-xp 00000000 fd:00 396393 /usr/lib64/MonetDB5/lib/lib_group.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c615e000-7f67c635d000 ---p 000c4000 fd:00 396393 /usr/lib64/MonetDB5/lib/lib_group.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c635d000-7f67c635e000 rw-p 000c3000 fd:00 396393 /usr/lib64/MonetDB5/lib/lib_group.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c635e000-7f67c6363000 r-xp 00000000 fd:00 396501 /usr/lib64/MonetDB5/lib/lib_status.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6363000-7f67c6562000 ---p 00005000 fd:00 396501 /usr/lib64/MonetDB5/lib/lib_status.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6562000-7f67c6563000 rw-p 00004000 fd:00 396501 /usr/l2010-04-21 14:35:13 ERR demo[12692]: ib64/MonetDB5/lib/lib_status.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6563000-7f67c658a000 r-xp 00000000 fd:00 396363 /usr/lib64/MonetDB5/lib/lib_calc.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c658a000-7f67c6789000 ---p 00027000 fd:00 396363 /usr/lib64/MonetDB5/lib/lib_calc.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6789000-7f67c678a000 rw-p 00026000 fd:00 396363 /usr/lib64/MonetDB5/lib/lib_calc.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c678a000-7f67c678b000 r-xp 00000000 fd:00 396315 /usr/lib64/MonetDB5/lib/lib_algebraExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c678b000-7f67c698b000 ---p 00001000 fd:00 396315 /usr/lib64/MonetDB5/lib/lib_algebraExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c698b000-7f67c698c000 rw-p 00001000 fd:00 396315 /usr/lib64/MonetDB5/lib/lib_algebraExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c698c000-7f67c6990000 r-xp 00000000 fd:00 396324 /usr/lib64/MonetDB5/lib/lib_batExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6990000-7f67c6b8f000 ---p 00004000 fd:00 396324 /usr/lib64/MonetDB5/lib/lib_batExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6b8f000-7f67c6b90000 rw-p 00003000 fd:00 396324 /usr/lib64/MonetDB5/lib/lib_batExtensions.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6b90000-7f67c6b93000 r-xp 00000000 fd:00 396507 /usr/lib64/MonetDB5/lib/lib_streams.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6b93000-7f67c6d92000 ---p 00003000 fd:00 396507 /usr/lib64/MonetDB5/lib/lib_streams.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6d92000-7f67c6d93000 rw-p 00002000 fd:00 396507 /usr/lib64/MonetDB5/lib/lib_streams.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6d93000-7f67c6d98000 r-xp 00000000 fd:00 396444 /usr/lib64/MonetDB5/lib/lib_mmath.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6d98000-7f67c6f97000 ---p 00005000 fd:00 396444 /usr/lib64/MonetDB5/lib/lib_mmath.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6f97000-7f67c6f98000 rw-p 00004000 fd:00 396444 /usr/lib64/MonetDB5/lib/lib_mmath.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6f98000-7f67c6f99000 r-xp 00000000 fd:00 396495 /usr/lib64/MonetDB5/lib/lib_sema.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c6f99000-7f67c7199000 ---p 00001000 fd:00 396495 /u2010-04-21 14:35:13 ERR demo[12692]: sr/lib64/MonetDB5/lib/lib_sema.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7199000-7f67c719a000 rw-p 00001000 fd:00 396495 /usr/lib64/MonetDB5/lib/lib_sema.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c719a000-7f67c719c000 r-xp 00000000 fd:00 396414 /usr/lib64/MonetDB5/lib/lib_lock.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c719c000-7f67c739b000 ---p 00002000 fd:00 396414 /usr/lib64/MonetDB5/lib/lib_lock.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c739b000-7f67c739c000 rw-p 00001000 fd:00 396414 /usr/lib64/MonetDB5/lib/lib_lock.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c739c000-7f67c739d000 r-xp 00000000 fd:00 396522 /usr/lib64/MonetDB5/lib/lib_unix.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c739d000-7f67c759c000 ---p 00001000 fd:00 396522 /usr/lib64/MonetDB5/lib/lib_unix.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c759c000-7f67c759d000 rw-p 00000000 fd:00 396522 /usr/lib64/MonetDB5/lib/lib_unix.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c759d000-7f67c75e4000 r-xp 00000000 fd:00 396312 /usr/lib64/MonetDB5/lib/lib_algebra.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c75e4000-7f67c77e3000 ---p 00047000 fd:00 3963122010-04-21 14:35:13 ERR demo[12692]: /usr/lib64/MonetDB5/lib/lib_algebra.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c77e3000-7f67c77e4000 rw-p 00046000 fd:00 396312 /usr/lib64/MonetDB5/lib/lib_algebra.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c77e4000-7f67c77fb000 r-xp 00000000 fd:00 396321 /usr/lib64/MonetDB5/lib/lib_bat5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c77fb000-7f67c79fb000 ---p 00017000 fd:00 396321 /usr/lib64/MonetDB5/lib/lib_bat5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c79fb000-7f67c79fc000 rw-p 00017000 fd:00 396321 /usr/lib64/MonetDB5/lib/lib_bat5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c79fc000-7f67c7a01000 r-xp 00000000 fd:00 396435 /usr/lib64/MonetDB5/lib/lib_mdb.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7a01000-7f67c7c00000 ---p 00005000 fd:00 396435 /usr/lib64/MonetDB5/lib/lib_mdb.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c00000-7f67c7c01000 rw-p 00004000 fd:00 396435 /usr/lib64/MonetDB5/lib/lib_mdb.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c01000-7f67c7c21000 rw-s 00000000 fd:00 6000 /var/MonetDB5/dbfarm/demo/bat/14/1414.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c21000-7f67c7c41000 rw2010-04-21 14:35:13 ERR demo[12692]: -s 00000000 fd:00 6045 /var/MonetDB5/dbfarm/demo/bat/17/1700.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c41000-7f67c7c61000 rw-s 00000000 fd:00 6044 /var/MonetDB5/dbfarm/demo/bat/16/1675.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c61000-7f67c7c81000 rw-s 00000000 fd:00 6006 /var/MonetDB5/dbfarm/demo/bat/15/1522.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7c81000-7f67c7ca1000 rw-s 00000000 fd:00 5997 /var/MonetDB5/dbfarm/demo/bat/13/1374.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7ca1000-7f67c7cc1000 rw-s 00000000 fd:00 6038 /var/MonetDB5/dbfarm/demo/bat/17/1703.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7cc1000-7f67c7ce1000 rw-s 00000000 fd:00 6042 /var/MonetDB5/dbfarm/demo/bat/14/1410.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7ce1000-7f67c7d01000 rw-s 00000000 fd:00 6004 /var/MonetDB5/dbfarm/demo/bat/15/1500.theap 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7d01000-7f67c7d02000 ---p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7d02000-7f67c7f2e000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67c7f2e000-7f67cd702000 ---p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67cd702000-7f67d3533000 r--p 00000000 fd:00 263286 /usr/lib/loca2010-04-21 14:35:13 ERR demo[12692]: le/locale-archive 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3533000-7f67d3539000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3539000-7f67d3592000 r-xp 00000000 fd:00 263127 /usr/lib64/libfreebl3.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3592000-7f67d3792000 ---p 00059000 fd:00 263127 /usr/lib64/libfreebl3.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3792000-7f67d3793000 rw-p 00059000 fd:00 263127 /usr/lib64/libfreebl3.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3793000-7f67d379b000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67d379b000-7f67d37a2000 r-xp 00000000 fd:00 1477 /lib64/libcrypt-2.11.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d37a2000-7f67d39a2000 ---p 00007000 fd:00 1477 /lib64/libcrypt-2.11.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d39a2000-7f67d39a3000 r--p 00007000 fd:00 1477 /lib64/libcrypt-2.11.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d39a3000-7f67d39a4000 rw-p 00008000 fd:00 1477 /lib64/libcrypt-2.11.so 2010-04-21 14:35:13 ERR demo[12692]: 7f67d39a4000-7f67d39d6000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67d39d6000-7f67d3a4c000 r-xp 00000000 fd:00 323652 /usr/lib64/libmonetdb5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3a4c000-7f67d3c4c000 ---p 00076000 fd:00 323652 2010-04-21 14:35:13 ERR demo[12692]: /usr/lib64/libmonetdb5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3c4c000-7f67d3c54000 rw-p 00076000 fd:00 323652 /usr/lib64/libmonetdb5.so.5.18.3 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3c54000-7f67d3d01000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3d0e000-7f67d3d10000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3d10000-7f67d3d17000 r--s 00000000 fd:00 262948 /usr/lib64/gconv/gconv-modules.cache 2010-04-21 14:35:13 ERR demo[12692]: 7f67d3d17000-7f67d3d19000 rw-p 00000000 00:00 0 2010-04-21 14:35:13 ERR demo[12692]: 7fff58dc0000-7fff58dd5000 rw-p 00000000 00:00 0 [stack] 2010-04-21 14:35:13 ERR demo[12692]: 7fff58dff000-7fff58e00000 r-xp 00000000 00:00 0 [vdso] 2010-04-21 14:35:13 ERR demo[12692]: ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] 2010-04-21 14:35:13 MSG merovingian[12683]: client localhost:52907 has disconnected from proxy 2010-04-21 14:35:13 MSG merovingian[12683]: database 'demo' (12692) was killed by signal 6 2010-04-21 14:35:48 MSG merovingian[12683]: database 'demo' has crashed after start on 2010-04-21 14:32:37, attempting restart, up min/avg/max: 0s/0s/0s, crash average: 1.00 0.10 0.03 (1-0=1) 2010-04-21 14:35:49 MSG merovingian[12683]: proxying client localhost:52909 for database 'demo' to mapi:monetdb://127.0.0.1:50002/demo 2010-04-21 14:35:49 MSG demo[12723]: arguments: /usr/bin/mserver5 --config=/etc/monetdb5.conf --dbname=demo --dbinit=include sql; --set merovingian_uri=mapi:monetdb://monetdb:50000/demo --set monet_daemon=yes --set mapi_open=false --set mapi_autosense=true --set mapi_port=50001 --set monet_vault_key=/var/MonetDB5/dbfarm/demo/.vaultkey --set sql_optimizer=inline,remap,deadcode,multiplex 2010-04-21 14:35:49 MSG demo[12723]: # MonetDB server v5.18.3, based on kernel v1.36.3 2010-04-21 14:35:49 MSG demo[12723]: # Serving database 'demo', using 16 threads 2010-04-21 14:35:49 MSG demo[12723]: # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked 2010-04-21 14:35:49 MSG demo[12723]: # Found 47.259 GiB available main-memory. 2010-04-21 14:35:49 MSG demo[12723]: # Copyright (c) 1993-July 2008 CWI. 2010-04-21 14:35:49 MSG demo[12723]: # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved 2010-04-21 14:35:49 MSG demo[12723]: # Visit http://monetdb.cwi.nl/ for further information 2010-04-21 14:35:49 MSG demo[12723]: # Listening for connection requests on mapi:monetdb://127.0.0.1:50002/ 2010-04-21 14:35:49 MSG demo[12723]: # MonetDB/SQL module v2.36.3 loaded 2010-04-21 14:36:10 MSG merovingian[12683]: client localhost:52909 has disconnected from proxy dariuszs wrote:
Hi, Single thread works, but what does it really mean? Thanks. Dariusz
Fabian Groffen wrote:
On 21-04-2010 13:51:52 -0400, dariuszs wrote:
Hi, I'm using Fedora 12 on this machine, are you saying you don't have this problem? I've replicated this problem also on Ubuntu 9.10 and Windows 2003. Thanks. Dariusz.
Can you try the following to see if it makes any difference?
monetdb destroy demo monetdb create demo monetdb set nrthreads=1 demo monetdb release demo [load data]
Alternatively try this (but I think it has very little chance of making any difference):
monetdb destroy demo monetdb create demo monetdb set optpipe=inline,remap,deadcode,multiplex demo monetdb release demo [load data]
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users