- users-list - monetdb.org

[MonetDB-users] MonetDB/XQuery with Java/Perl
by listanand＠gmail.com 09 Oct '09

09 Oct '09

Hi all, I am new to MonetDB/XQuery, and have a question to ask. Actually, I am new to MonetDB/XQuery, XML, SOAP, RPC, and XQuery also, and so you can very well imagine how overwhelmed I must be at this point :( I do not need super efficient query processing, but what I do certainly need is a convenient hassle free programmatic access to the XQuery database. I looked at the documentation and it appears that the Perl and Java APIs still need some work, and are not ready for prime time. Is that correct? Also, do I need to learn SOAP, RPC etc to be able to issue XQueries from my program? Thanks in advance. Sorry if I seem grumpy (I am!). Andy

1 0

[MonetDB-users] mapilib latin1
by wilfried＠hafner.ws 09 Oct '09

09 Oct '09

Hi! I have a table with a varchar(100) column, when I connect to the server with mclient.bat -Elatin1 option I'm able to insert and display characters like ä and ö correctly. But I have problems to do the same with a c++ app and the mapilib. Does anyone have some hints? regards, Wilfried

2 2

[MonetDB-users] Help with table sizes
by david85 08 Oct '09

08 Oct '09

Hello, I am currently trying to figure out how I can determine the size, i.e. the disk space, of the different tables. I know that they are stored in the dbfarm/database_name/bat folder, but I don't know which folder holds the data for which table. I looked at the manual but the bbp.getDiskSpace command didn't work (or maybe I used it wrong). I have also searched for this topic, but there was no concrete answer. Thank you in advance. Best Regards -- View this message in context: http://www.nabble.com/Help-with-table-sizes-tp25728470p25728470.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Support for ANSI 1992/99 BIT
by McKennirey.Matthew 08 Oct '09

08 Oct '09

Although ANSI 2003 eliminated the BIT data type, I was wondering if anyone has developed support for this in MonetDB. Specifically we would like to store UUIDs in a column, as a 128 bit BIT type. Storing a UUID in its canonical string form (36 characters = 288 bits) seems inefficient. We would also like to consider using bit masks for access control. Thanks

1 0

[MonetDB-users] mapilib on windows
by wilfried＠hafner.ws 08 Oct '09

08 Oct '09

Hello! I have a question on getting the mapi working on windows... I downloaded the MonetDB-client-1.32.2.zip from the sources directory. I tried now to open the solution file in the NT directory but its not possible, I use vc++ 2008 express. What version of vc++ should I use? Is there an existing .lib in one of the other downloadable packages? I would like to create a sql driver for qt4 in c++... Kind Regards, Wilfried

2 2

[MonetDB-users] Insert slowdown
by Guillaume Theoret 08 Oct '09

08 Oct '09

Hi, I have a question about insert performance. At first, with an empty table, it took a little over 1 second (around 1.5) to insert 1000 rows. Now, with 5.2MM rows, it's taking ~65s. Is this to be expected? Thanks, Guillaume

2 4

[MonetDB-users] Segmentation fault on insert
by Guillaume Theoret 07 Oct '09

07 Oct '09

This has happened twice in two days so far. All I do is insert rows in a loop and eventually I hit a segmentation fault. [...] 160000 done - 2.1121% in 432.97 (0.0026 avg) 161000 done - 2.1253% in 435.68 (0.0027 avg) 162000 done - 2.1385% in 438.28 (0.0026 avg) 163000 done - 2.1517% in 442.37 (0.0041 avg) Segmentation fault monetdb@dev3:~$ MonetDB/bin/monetdb status name state uptime health last crash test running 2m 56s 34%, 0s 2009-10-06 15:45:01 Is there any way to recover from this? I tried stopping the db but it would just hang. I tried restarting monetdb/merovingian and starting the db again but it said this: starting database 'test'... FAILED: starting 'test' failed: database 'test' has inconsistent state (running but dead), review merovingian's logfile for any peculiarities This seems to be the log from when the crash occured: 2009-10-07 12:47:20 MSG merovingian[3081]: client localhost:40950 has disconnected from proxy 2009-10-07 12:47:20 MSG merovingian[3081]: client localhost:38976 has disconnected from proxy 2009-10-07 12:47:20 MSG merovingian[3081]: database 'test' (3865) was killed by signal 11 2009-10-07 14:03:29 MSG merovingian[3081]: database 'test' has crashed after start on 2009-10-06 15:45:01, attempting restart, up min/avg/max: 0s/0s/0s, crash average: 1.00 0.20 0.07 (2-0=2) 2009-10-07 14:03:30 MSG test[6042]: arguments: /home/guillaume/MonetDB/bin/mserver5 --config=/home/guillaume/MonetDB/etc/monetdb5.conf --dbnam e=test --dbinit=include sql; --set monet_daemon=yes --set mapi_open=false --set mapi_autosense=true --set mapi_port=50001 --set monet_vault_key=/home/guillaume/MonetDB/var/MonetDB5/dbfarm/test/.vaultkey And this is the log when I tried to start it: 2009-10-07 14:08:39 ERR merovingian[6059]: failed to fork mserver: database 'test' has inconsistent state (running but dead), review merovingian's logfile for any peculiarities If I recompile with debug mode enabled will it dump a stack trace somewhere when it segfaults? Thanks, Guillaume

1 1

[MonetDB-users] Restarting embedded connection
by Sebastian Ohl 06 Oct '09

06 Oct '09

Hi, i'am using the embedded version of monetdb sql server in one of my projects. now i want to write tests for several functions using a normal test framework. in theses frameworks it is normal to setup your test environment before every testcase. for me, that means that i have to start the embedded monetdb server. after every testcase i want to shutdown to server so that i have a clean environment again. after disconnecting from the server by mapi_disconnect/destroy, i tried to start a new embedded sql server, but at the first call it has lost its connection and my application dies. i digged a little bit in monetdb's code an there are a lot of static variables. it is even possible to restart an embedded sql server? if it is, how can i safely do this? regards sebastian

1 0

[MonetDB-users] Restarting embedded connection
by Sebastian Ohl 06 Oct '09

06 Oct '09

Hi, i'am using the embedded version of monetdb sql server in one of my projects. now i want to write tests for several functions using a normal test framework. in theses frameworks it is normal to setup your test environment before every testcase. for me, that means that i have to start the embedded monetdb server. after every testcase i want to shutdown to server so that i have a clean environment again. after disconnecting from the server by mapi_disconnect/destroy, i tried to start a new embedded sql server, but at the first call it has lost its connection and my application dies. i digged a little bit in monetdb's code an there are a lot of static variables. it is even possible to restart an embedded sql server? if it is, how can i safely do this? regards sebastian

1 0

[MonetDB-users] Optimizer exception in Aug09-SP1
by Alex Bo. 06 Oct '09

06 Oct '09

Hi, I got this exception while running a not so special query: ExecuteReader failed: !SQLException:optimizer: 'multiplex' should be the last !SQLException:optimizer: 'deadcode' should be used at least once !SQLException:optimizer: pipeline set to 'inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex' I haven't been able to reproduce it since. What does it mean? Is it something to worry about? Thanks. -- View this message in context: http://www.nabble.com/Optimizer-exception-in-Aug09-SP1-tp25736590p25736590.… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] gdk_single_user
by Matthew Jones 06 Oct '09

06 Oct '09

Is this option still required to keep the database from corrupting itself on shutdown? I've also noticed when running in this mode that I see a lot of duplicate tables and when attempting to drop a table it doesn't disappear from my table list... what gives? 73, Matthew W. Jones (KI4ZIB) http://matburt.net

2 2

[MonetDB-users] Unique constraint on char column
by Guillaume Theoret 06 Oct '09

06 Oct '09

Is the unique constraint supposed to work on a char column? I wanted to add a constraint such that a combination of two columns (date_added and hash_key) was always unique but although the constraint seems to have been added successfully, it seemingly has no effect: (please disregard timer measurements, I'm doing lots of concurrent inserts at the same time) sql>CREATE TABLE test.keytest ( more> date_added int NOT NULL, more> hash_key char(32) NOT NULL, more> dimension1 int NOT NULL, more> dimension2 int NOT NULL, more> metric1 int NOT NULL, more> metric2 int NOT NULL, more> more> CONSTRAINT key_test UNIQUE (hash_key,date_added) more>); Operation successful Timer 1855.919 msec 0 rows sql> 0 tuples Timer 368.076 msec 0 rows sql>select * from test.keytest; 0 tuples Timer 294.551 msec 0 rows sql>insert into test.keytest (date_added, hash_key, dimension1, dimension2, metric1, metric2) VALUES (1, a, 1, 1, 2, 2); !SELECT: identifier 'a' unknown 0 tuples Timer 22.811 msec 0 rows sql>insert into test.keytest (date_added, hash_key, dimension1, dimension2, metric1, metric2) VALUES (1, 'a', 1, 1, 2, 2); Rows affected 1 Timer 12.126 msec 0 rows sql>insert into test.keytest (date_added, hash_key, dimension1, dimension2, metric1, metric2) VALUES (1, 'a', 1, 1, 2, 2); Rows affected 1 Timer 18.345 msec 0 rows sql>select * from test.keytest; select * from test.keytest; +------------+----------------------------------+------------+------------+---------+---------+ | date_added | hash_key | dimension1 | dimension2 | metric1 | metric2 | +============+==================================+============+============+=========+=========+ | 1 | a | 1 | 1 | 2 | 2 | | 1 | a | 1 | 1 | 2 | 2 | +------------+----------------------------------+------------+------------+---------+---------+ 2 tuples Timer 1.997 msec 2 rows sql>CREATE UNIQUE INDEX unique_key_test ON test.keytest (date_added, hash_key); Operation successful Timer 25.904 msec 2 rows sql>insert into test.keytest (date_added, hash_key, dimension1, dimension2, metric1, metric2) VALUES (1, 'a', 1, 1, 2, 2); Rows affected 1 Timer 78.637 msec 2 rows sql>insert into test.keytest (date_added, hash_key, dimension1, dimension2, metric1, metric2) VALUES (1, 'a', 1, 1, 2, 2); Rows affected 1 Timer 31.788 msec 2 rows sql>select * from test.keytest; select * from test.keytest; +------------+----------------------------------+------------+------------+---------+---------+ | date_added | hash_key | dimension1 | dimension2 | metric1 | metric2 | +============+==================================+============+============+=========+=========+ | 1 | a | 1 | 1 | 2 | 2 | | 1 | a | 1 | 1 | 2 | 2 | | 1 | a | 1 | 1 | 2 | 2 | | 1 | a | 1 | 1 | 2 | 2 | +------------+----------------------------------+------------+------------+---------+---------+ 4 tuples Timer 18.083 msec 4 rows I can't seem to get monetdb to refuse to add the rows. I then tried: sql>CREATE TABLE test.keytest2 ( more> date_added int NOT NULL, more> key int NOT NULL, more> dimension1 int NOT NULL, more> dimension2 int NOT NULL, more> metric1 int NOT NULL, more> metric2 int NOT NULL, more> more> CONSTRAINT key_test2 UNIQUE (key,date_added) more>); Operation successful Timer 167.384 msec 0 rows sql>insert into test.keytest2 (date_added, key, dimension1, dimension2, metric1, metric2) VALUES (1, 1, 1, 1, 2, 2); Rows affected 1 Timer 1.693 msec 0 rows sql>insert into test.keytest2 (date_added, key, dimension1, dimension2, metric1, metric2) VALUES (1, 1, 1, 1, 2, 2); !SQLException:assert:INSERT INTO: UNIQUE constraint 'keytest2.key_test2' violated 0 tuples Timer 66.634 msec 0 rows sql>select * from test.keytest2; select * from test.keytest2; +------------+-------+------------+------------+---------+---------+ | date_added | key | dimension1 | dimension2 | metric1 | metric2 | +============+=======+============+============+=========+=========+ | 1 | 1 | 1 | 1 | 2 | 2 | +------------+-------+------------+------------+---------+---------+ 1 tuple Timer 140.707 msec 1 rows Which worked as expected. Is this a bug or is it by design? Thanks, Guillaume

2 2

[MonetDB-users] segmentation fault at startup
by Matthew Jones 06 Oct '09

06 Oct '09

After a spontaneous reboot while the database was idle, it now won't come back up due to a segmentation fault.... is there any way to recover from this? # /usr/bin/mserver5 --config=/etc/monetdb5.conf --dbname=qa-test-1 --dbinit="include sql;" --set monet_daemon=yes --set mapi_open=false --set mapi_autosense=true --set mapi_port=50001 --set monet_vault_key=/var/MonetDB5/dbfarm/qa-test-1/.vaultkey # MonetDB server v5.14.0, based on kernel v1.32.0 # Serving database 'qa-test-1', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50002/ # MonetDB/SQL module v2.32.0 loaded Segmentation fault Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7fe8592906e0 (LWP 5538)] 0x00007fe8582faa29 in strPut () from /usr/lib/libbat.so.1 (gdb) (gdb) bt #0 0x00007fe8582faa29 in strPut () from /usr/lib/libbat.so.1 #1 0x00007fe858259288 in BATappend () from /usr/lib/libbat.so.1 #2 0x00007fe858571e83 in ?? () from /usr/lib/libbat.so.1 #3 0x00007fe8585729e9 in ?? () from /usr/lib/libbat.so.1 #4 0x00007fe858573dc4 in logger_create () from /usr/lib/libbat.so.1 #5 0x00007fe84744f0c5 in ?? () from /usr/lib/MonetDB5/lib/lib_sql.so #6 0x00007fe847449245 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00007fe847415346 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00007fe8473d6b9b in SQLprelude () from /usr/lib/MonetDB5/lib/lib_sql.so #9 0x00007fe858d80ef1 in ?? () from /usr/lib/libmonetdb5.so.5 #10 0x00007fe858d8c471 in runMAL () from /usr/lib/libmonetdb5.so.5 #11 0x00007fe858d7aa74 in MALengine () from /usr/lib/libmonetdb5.so.5 #12 0x00007fe858d797b1 in callString () from /usr/lib/libmonetdb5.so.5 #13 0x0000000000402976 in main () 73, Matthew W. Jones (KI4ZIB) http://matburt.net

1 0

[MonetDB-users] 'deadcode' should be used at least once
by Guillaume Theoret 06 Oct '09

06 Oct '09

I was doing concurrent inserts (just running monetdb_query('INSERT INTO ...'); in a loop) with 2 workers. After ~172,000 inserts on the first worker I got this message: Error: SQLException:optimizer: 'deadcode' should be used at least once !SQLException:optimizer: pipeline set to 'inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex' And at the same time on the second worker I got: Error: SQLException:optimizer: 'multiplex' should be the last !SQLException:optimizer: 'deadcode' should be used at least once !SQLException:optimizer: pipeline set to 'inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex' Does anyone know what this might mean? At first I thought I may have made too big of a transaction but it seems monetdb runs in autocommit mode by default. Thanks, Guillaume

1 0

[MonetDB-users] loading RDF data in MonetDB
by Medha Atre 06 Oct '09

06 Oct '09

Hi, I intend to use MonetDB for some of my experimental work using RDF data. I was wondering if there is an easy way to load RDF data (in NTriples format) in MonetDB making use of the column-wise vertical partitioning of the RDF data, based on properties/predicates in the RDF data. Some pointers or help regarding this is much appreciated. I am sorry if this is not the correct forum to post this message. Thanks. Medha

2 1

[MonetDB-users] Download link broken?
by Guillaume Theoret 05 Oct '09

05 Oct '09

Hi, I tried to download the linux version of MonetDB/SQL on this page http://monetdb.cwi.nl/projects/monetdb//Download/ but both the lzma and bz2 links 404. I instead followed the Ubuntu instructions available here: http://monetdb.cwi.nl/downloads/Ubuntu/ and it worked fine but I thought I'd point out the above. Thanks, Guillaume

3 4

[MonetDB-users] Query time problem
by Chris Baros 05 Oct '09

05 Oct '09

Hi I am using Monetdb xquery in a Windows platform, I want to measure the timing in some queries. But every time I run a query, I see that the "Query time" increases. If I restart the server, then again at the first time the Query time is normall, and by the second and after, increases again.. Do you have any ideas whats the problem? _________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx

2 2

[MonetDB-users] current_timestamp in windows is wrong
by Alex Bo. 04 Oct '09

04 Oct '09

Hi, I am running Feb09 and Aug09 on Windows. If I use CURRENT_TIMESTAMP / LOCALTIME / LOCALTIMESTAMP then I get the correct date but the time is 2 hours early. (I am running from time zone UTC +02:00) Is this a bug? -- View this message in context: http://www.nabble.com/current_timestamp-in-windows-is-wrong-tp25736255p2573… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Announcement: New Aug2009-SP1 bugfix release of MonetDB suite
by Sjoerd Mullender 30 Sep '09

30 Sep '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2009-SP1 bug fix release of the MonetDB suite of programs. This is the first bug fix release for the Aug2009 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb//Development/Releases/Aug2009/#Aug20…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

2 2

[MonetDB-users] xqueries from web apps and cgi scripts: ruby mapi interface ?
by Axel Belinfante 24 Sep '09

24 Sep '09

First of all, I'm a monetdb/xquery/ruby novice. I'm trying to do xqueries from the web in two ways: from a ruby-on-rails application, and from a cgi script. For the cgi script I use (a perl wrapper around) mclient, which seems to work ok. The remainder of this mail is about the access from ruby-on-rails. For the ruby-on-rails application, I typically have to do relatively small queries. The heart of the xqueries is in xquery module files (partly 'static', partly generated 'dynamically' from user data entered in web forms) and thus the queries to be done from ruby-on-rails are rather small: import the module, and invoke the right function with some parameters. I started using xrpc. However, I'm encountering issues that might be related to the fact that xrpc uses one backend, and mclient (by default) uses another one. (Being an xquery novice) I've also encountered some differences between the xquery support by both backends. I then started looking at the mapi interface, because that would allow the use of the same backend from both webapp an cgi scripts. To my understanding there are a couple of different routes possible, and I'm not sure what would be the best way. - use the native ruby code present in the MonetDB distribution this I tried, but it seems to not fully up-to-date/working in the Aug-2009 distribution at least, I had to hack MonetDBConnection.rb to make it work - use the swig mapi wrapper (via http://rubyforge.org/projects/monetdb-ror) I did not try that yet - somehow wrap mclient (using something like fork/exec from ruby) did not try that yet, but I have been using mclient to try queries - use libmapi to build my own translation daemon/program, that is kind of like mclient but e.g. without the prompts etc, that receives/sends xqueries/responses as strings on a socket (or so), and talks mapi to the database. I did not try this; I did compile and run the sample mapi program, which could be used as a start, I guess I'm kind of looking for comments, and in particular I'm curious about the status of the native ruby code included in the distribution - I would prefer to use that, but for some of the basic things I looked at the mapi C library seems to do things in a more involved way than the ruby code, which makes me wonder. On the other hand, it seems that for xquery support the library mainly has to pass strings around - not all the complicated things that seem to be necessary for, for example, the sql support. Thanks, Axel.

2 2

[MonetDB-users] functions in group by
by mkurtulus 22 Sep '09

22 Sep '09

Hello, in our attempt to use monetdb as a backend for Mondrian, we are running into trouble with queries that Mondrian generates where functions are used in group by. eg. select substring('string',1,2) from mytable group by substring('string',1,2); Monet complains about a syntax error... On the contrary, using this syntax works: select substring('string',1,2) as col from mytable group by col; We have found a closed bug (http://sourceforge.net/tracker/index.php?func=detail&aid=946935&group_id=56…) in sourceforge that says it is not a bug, as using functions in group by is not supported in standard sql'99. We have thought of modifying Mondrian query generator to use the supported syntax... but the supported syntax is _not_ supported by Oracle ! So not supporting Oracle in favor of Monet is not (yet :) an option... Also notice that MS Sqlserver does not support aliases in group by either. Some even state that it is not standard sql... Reading the BNF was not of great help to me :-) Would you think supporting functions in group by could be done ? Mehmet -- Open WebMail Project (http://openwebmail.org)

5 7

[MonetDB-users] dump & restore errors
by Alex Bo. 21 Sep '09

21 Sep '09

Hi, I'm failing to restore a dump from Feb09 to Aug09. I get these errors continuously when I try to restore: 0 tuples !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) !current transaction is aborted (please ROLLBACK) The problem is that the error messages aren't descriptive, I can't know what's going on. Any ideas? Thanks, Alex. -- View this message in context: http://www.nabble.com/dump---restore-errors-tp25530320p25530320.html Sent from the monetdb-users mailing list archive at Nabble.com.

4 3

[MonetDB-users] Two count(*) in query with LIMIT crashes Monet
by Alex Bo. 17 Sep '09

17 Sep '09

Hi, I am running FebSP2 on Windows. The following query crashes Monet: SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2 limit 100 The following queries do work: 1. Same but with only 1 aggregation field: SELECT COUNT (*) AS c1 FROM t2 limit 100 2. Same but without LIMIT: SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2 This seems like a bug. Thanks, Alex. -- View this message in context: http://www.nabble.com/Two-count%28*%29-in-query-with-LIMIT-crashes-Monet-tp… Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Aug2009 - ubuntu/out of memory
by dariuszs 15 Sep '09

15 Sep '09

Hi, I've installed the Aug2009 release on Ubuntu 64bit and it brings my system to a halt - 'out of memory', every time I try to load file into a table? Previous releases work fine. Dariusz.

2 3

[MonetDB-users] server crashes (may2009-sp2)
by Lazaros Koromilas 11 Sep '09

11 Sep '09

the scenario is: - create a large document with xmlgen: http://www.ins.cwi.nl/projects/xmark/Assets/unix.c - load it _updatable_ into monetdb/xquery - query many times with the current setup, it always segfaults the server at the 4th attempt. re-produce with: # xmlgen -f 1 > xmlgen-f1.xml -rw-r--r-- 112M 2009-09-11 18:24 xmlgen-f1.xml # echo 'pf:add-doc("'$PWD'/xmlgen-f1.xml", "xmlgen-f1", "xmlac", 10)' \ | mclient -lx # echo 'doc("xmlgen-f1")//africa//item' | mclient -lx > /dev/null # echo 'doc("xmlgen-f1")//africa//item' | mclient -lx > /dev/null # echo 'doc("xmlgen-f1")//africa//item' | mclient -lx > /dev/null # echo 'doc("xmlgen-f1")//africa//item' | mclient -lx > /dev/null MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = doc("xmlgen-f1")//africa//item ERROR = Connection terminated other info: # uname -a Linux redrawn 2.6.30-ARCH #1 SMP PREEMPT Wed Sep 9 12:37:32 UTC 2009 i686 Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz GenuineIntel GNU/Linux # Mserver --version MonetDB server v4.30.4 (32-bit), based on kernel v1.30.4 (32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /usr/local Libraries: libpcre: 7.9 2009-04-11 (compiled with 7.9) openssl: OpenSSL 0.9.8k 25 Mar 2009 (compiled with OpenSSL 0.9.8k 25 Mar 2009) Compiled by: root@redrawn Compilation: gcc -O2 Linking : /usr/bin/ld i'll try the latest stable also. i think there was no problem with august2008 release. any help is appreciated. thanx, lazaros. -- http://www.ics.forth.gr/~koromil

1 0