March 2007 - developers-list

[Monetdb-developers] Compiling on Darwin 7
by Fabian Groffen 21 Jan '08

21 Jan '08

Is there anyone that can think of a solution for this problem? cc1: warnings being treated as errors /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx: In function 'local_itoa': /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx:1253: warning: format '%zd' expects type 'signed size_t', but argument 4 has type 'ssize_t' I mean... is there a difference between "signed size_t" and "ssize_t"? Ehrm. [Orion:src/modules/plain] fabian% uname -a Darwin Orion.local 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh powerpc PowerBook4,3 Darwin [Orion:src/modules/plain] fabian% gcc --version gcc (GCC) 4.0.1 (Apple Computer, Inc. build 5341) Copyright (C) 2005 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Probably just need to compile without -Werror.

4 5

[Monetdb-developers] Win32 build & prefix
by Steffen Goeldner 12 Apr '07

12 Apr '07

HowToStart-SQL-Win32.txt says In case the install (i.e., prefix) directories of MonetDB and MonetDB/SQL are identical, ... However, it seems that prefix is fixed in NT/Makefile prefix = $(MAKEDIR) Would it be possible to control the prefix via an environment variable? Also, it seems that CLIENTS_PREFIX MONETDB4_PREFIX MONETDB5_PREFIX are required, but HowToStart-SQL-Win32.txt only mentions MONETDB_PREFIX. And a related question: Is it possible to use a build directory outside of the source tree (under Win32)? Steffen Goeldner

2 6

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server sql_parser.mx, 1.231.2.8, 1.231.2.9
by Sjoerd Mullender 31 Mar '07

31 Mar '07

On 03/31/2007 10:38 AM, Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/server > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv24338/server > > Modified Files: > Tag: SQL_2-16 > sql_parser.mx > Log Message: > fixed error message about decimal types > > > > Index: sql_parser.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/server/sql_parser.mx,v > retrieving revision 1.231.2.8 > retrieving revision 1.231.2.9 > diff -u -d -r1.231.2.8 -r1.231.2.9 > --- sql_parser.mx 31 Mar 2007 08:07:47 -0000 1.231.2.8 > +++ sql_parser.mx 31 Mar 2007 08:38:44 -0000 1.231.2.9 > @@ -3972,7 +3972,7 @@ > if ($5 >= $3) > snprintf(buf, BUFSIZ, "scale (%lld) should be less than precision (%lld)", $5, $3); > else > - snprintf(buf, BUFSIZ, "decimal(%lld,%lld) isn't supported", $5, $3); > + snprintf(buf, BUFSIZ, "decimal(%lld,%lld) isn't supported because P=%lld + S=%lld > 18", $3, $5, $3, $5); That should of course be LLFMT, right? > yyerror(buf); > $$.type = NULL; > YYABORT; > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] Win32 build & UnxUtils & bison
by Steffen Goeldner 27 Mar '07

27 Mar '07

HowToStart-*-Win32.txt lists bison from UnxUtils as prerequisite. This version (1.28) seems too old: monet_parse.tab.c monet_parse.y(85) : error C2046: illegal case monet_parse.y(86) : error C2043: illegal break ... Version 2.1 from cygwin works. Steffen Goeldner

2 2

[Monetdb-developers] Mapi slowdown with Java + Linux (4.6.2!)
by Agustin Schapira 26 Mar '07

26 Mar '07

I have been struggling with this problem for a couple of weeks. We are using Monet 4.6.2 (I know, I know!) to power a web service written in Java. When Monet is running on OS X, I can handle 200+ requests per second, but when I install it on a (much faster) Linux machine, the app only gives me 20 requests per second. The difference happens on the TCP/IP connection. I have the simplest test: var a:=bat(int,int).insert(1,1); a.print(); This takes 4ms on OS X, but 40ms on Linux. I've traced down the system calls, and what happens is that when the server is running on OS X my client reads back the results in one or two calls to recv, whereas when the server is on Linux the client only gets a couple of bytes back from the server and then blocks until the rest arrives. The following is a section of strace's output on the Java application: $ strace -f -ttt java -cp test.java test Monet running on OS X: ---------------------- send(5, "a.print();\n", 12, 0) = 12 recv(5, "#------------\n# h ....", 8192, 0) = 50 ioctl(5, FIONREAD, [45]) = recv(5, " # type ....", 8192, 0) = 45 Monet running on Linux: ----------------------- send(5, "a.print();\n", 12, 0) = 12 recv(5, "#-", 8192, 0) ioctl(5, FIONREAD, [0]) = recv(5, <unfinished...> ==> blocks [... 40ms...] <recv resumed "----------#\n# h ...", 8192, 0) = 93 The sockets are opened in the same way in both cases, just like the MapiClient opens them: connect(5, {sa_family=AF_INET, sin_port=htons(45678), sin_addr=inet_addr("127.0.0.1")}, 16) = 0 setsockopt(5, SOL_SOCKET, SO_KEEPALIVE, [0], 4) = 0 setsockopt(5, SOL_IP, IP_TOS, [8], 4) = 0 setsockopt(5, SOL_TCP, TCP_NODELAY, [1], 4) = 0 This problem does not happen when I use Monet's MapiClient: the response times on OS X and Linux are similar. While inspecting the calls between the server and the MapiClient, then, I realized that the handshake is different from the one used by the Mapi.java class that comes with 4.6.2: the C client sets the 'blocked' flag on. Turning the 'blocked' flag to true in the MapiClient.java class doesn't work. Switching the C client's default mode to be non-blocked (in src/mapi/clients/C/Mapi.mx) does indeed make the connection much slower, as every single character is sent to the client in its own packet (due to TCP_NODELAY?): write(3, "print(a);\n", 10) = 10 read(3, "#", 1) = 1 read(3, "-", 1) = 1 read(3, "-", 1) = 1 ... read(3, "]", 1) = 1 read(3, "\n", 1) = 1 My question is then: is it possible to write a Java client that communicates with the server using the blocked protocol? Do you think that would solve my performance issues? If so, is there any documentation/example code I can follow (since the actual protocol seems to be different in both cases). I've looked at the latest CVS checkins for the the Mapi protocol, and I see that the only option now is the 'blocked' mode, so I guess it's possible to use it from Java.... FYI, I am using - Monet 4.6.2 - Java 5 - OS X 10.4.9 - Linux 2.6.9, 2.6.15, 2.6.17 Thank you very much, -- Agustin

4 4

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Connections/Tests connections.stable.err, NONE, 1.1 connections.stable.out, NONE, 1.1 connections.py, 1.4, 1.5
by Sjoerd Mullender 26 Mar '07

26 Mar '07

On 2007-03-26 13:00, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/Connections/Tests > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv4526/Tests > > Modified Files: > connections.py > Added Files: > connections.stable.err connections.stable.out > Log Message: > The connections test now is green. > Thanks Stefan for the help... > > > Index: connections.py > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Connections/Tests/connections.py,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- connections.py 23 Mar 2007 18:24:48 -0000 1.4 > +++ connections.py 26 Mar 2007 11:00:13 -0000 1.5 > @@ -42,12 +42,22 @@ > > def client_load_file(clt, port, file): > f = open(file, 'r') > + sys_err = sys.stderr > + clt_err = open('%s/err.log' % os.getenv('RELSRCDIR'), 'w') > + sys.stderr = clt_err Use os.path.join to join paths (as in os.path.join(os.getenv('RELSRCDIR'), 'err.log')). > for line in f: > line = line.replace('port_num', str(port+1)) > - line = line.replace('port_num_5', str(port+2)) > - line = line.replace('port_num_6', str(port+3)) > + line = line.replace('port_num5', str(port+2)) > clt.write(line) > - > + clt_err.close() > + clt_err = open('%s/err.log' % os.getenv('RELSRCDIR'), 'r') > + for line1 in clt_err: > + sys.stderr.write('%s\n' % (line1.replace('port %s' % str(port+1),'port <mapi_port>'))) > + sys.stderr.write('#%s\n' % line1) > + clt_err.close() > + sys.stderr = sys_err > + os.remove('%s/err.log' % os.getenv('RELSRCDIR')) > + f.close() > > > def client(x,s, c, dbinit, lang, file): > > --- NEW FILE: connections.stable.out --- > stdout of test 'connections` in directory 'src/test/Connections` itself: > > > # 12:08:28 > > # 12:08:28 > Mtimeout -timeout 180 /usr/bin/python connections.py connections > # 12:08:28 > > > > server 11 : "include sql;" > !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. > !WARNING: BBPdir: initializing BBP. > # MonetDB Server v5.0.0_beta2_1 > # Copyright (c) 1993-2007 CWI, all rights reserved > # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked > # dbname:mTests_src_test_Connections > # Visit http://monetdb.cwi.nl/ for further information > > server 12 : "include sql;" > # MonetDB Server v5.0.0_beta2_1 > # Copyright (c) 1993-2007 CWI, all rights reserved > # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked > # dbname:mTests_src_test_Connections_test1 > # Visit http://monetdb.cwi.nl/ for further information > > server 12 : "include sql;", client 1: SQL > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > > server 12 : "include sql;", client 2: SQL > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > > server 12 : "include sql;", client 3: SQL > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > [ "localhost", "mTests_src_test_Connections_test1", "localhost_mTests_src_test_Connections_test1_monetdb", "sql" ] > % sys.connections, sys.connections, sys.connections, sys.connections # table_name > % server, db, db_alias, language # name > % char, char, char, char # type > % 1024, 64, 1024, 1024 # length > > # 12:18:14 > > # 12:18:14 > Done. > # 12:18:14 > > > > --- NEW FILE: connections.stable.err --- > stderr of test 'connections` in directory 'src/test/Connections` itself: > > > # 12:08:28 > > # 12:08:28 > Mtimeout -timeout 180 /usr/bin/python connections.py connections > # 12:08:28 > > > > server 11 : "include sql;" > > mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=<mapi_port> --set xrpc_port=<xrpc_port> --set monet_prompt= --trace --dbname "mTests_src_test_Connections" --dbinit="include sql;"" > #mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=34118 --set xrpc_port=40549 --set monet_prompt= --trace --dbname "mTests_src_test_Connections" --dbinit="include sql;"" > # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu > # builtin opt gdk_version = 1.17.1 > # builtin opt monet_pid = 3601 > # builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB > # builtin opt exec_prefix = ${prefix} > # builtin opt gdk_dbname = tst > # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB > # builtin opt gdk_debug = 8 > # builtin opt gdk_mem_bigsize = 262144 > # builtin opt gdk_vm_minsize = 137438953472 > # builtin opt gdk_alloc_map = yes > # builtin opt gdk_mem_pagebits = 14 > # builtin opt monet_admin = adm > # builtin opt monet_prompt = > > # builtin opt monet_welcome = yes > # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin > # builtin opt monet_daemon = yes > # builtin opt host = localhost > # builtin opt mapi_port = 50000 > # builtin opt mapi_noheaders = no > # builtin opt mapi_debug = 0 > # builtin opt mapi_clients = 2 > # builtin opt sql_debug = 0 > # builtin opt sql_logdir = ${prefix}/var/MonetDB/sql_logs > # builtin opt xquery_logdir = ${prefix}/var/MonetDB/xquery_logs > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > # builtin opt standoff_start = start > # builtin opt standoff_end = end > # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 > # config opt config = ${prefix}/etc/monetdb5.conf > # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 > # config opt exec_prefix = ${prefix} > # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm > # config opt gdk_dbname = demo > # config opt gdk_alloc_map = no > # config opt gdk_embedded = no > # config opt gdk_debug = 0 > # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin > # config opt monet_daemon = no > # config opt monet_welcome = yes > # config opt delay = 120 > # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal > # config opt mal_listing = 15 > # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt > # config opt mapi_port = 0 > # config opt sql_debug = 0 > # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs > # config opt pf_httpd_port = 8080 > # config opt xquery_output = dm > # config opt xquery_cacheMB = 100 > # config opt xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs > # cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf > # cmdline opt gdk_debug = 10 > # cmdline opt monet_mod_path = /ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin > # cmdline opt gdk_dbfarm = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm > # cmdline opt sql_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs > # cmdline opt xquery_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs > # cmdline opt mapi_port = 31021 > # cmdline opt xrpc_port = 44351 > # cmdline opt monet_prompt = > # cmdline opt gdk_dbname = mTests_src_test_Connections > #warning: please don't forget to set your vault key! > #(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf) > > server 12 : "include sql;" > > remote mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=<mapi_port> --set xrpc_port=<xrpc_port> --set monet_prompt= --trace --dbname "mTests_src_test_Connections_test1" --dbinit="include sql;"" > #remote mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=34119 --set xrpc_port=40549 --set monet_prompt= --trace --dbname "mTests_src_test_Connections_test1" --dbinit="include sql;"" > # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu > # builtin opt gdk_version = 1.17.1 > # builtin opt monet_pid = 3611 > # builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB > # builtin opt exec_prefix = ${prefix} > # builtin opt gdk_dbname = tst > # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB > # builtin opt gdk_debug = 8 > # builtin opt gdk_mem_bigsize = 262144 > # builtin opt gdk_vm_minsize = 137438953472 > # builtin opt gdk_alloc_map = yes > # builtin opt gdk_mem_pagebits = 14 > # builtin opt monet_admin = adm > # builtin opt monet_prompt = > > # builtin opt monet_welcome = yes > # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin > # builtin opt monet_daemon = yes > # builtin opt host = localhost > # builtin opt mapi_port = 50000 > # builtin opt mapi_noheaders = no > # builtin opt mapi_debug = 0 > # builtin opt mapi_clients = 2 > # builtin opt sql_debug = 0 > # builtin opt sql_logdir = ${prefix}/var/MonetDB/sql_logs > # builtin opt xquery_logdir = ${prefix}/var/MonetDB/xquery_logs > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > # builtin opt standoff_start = start > # builtin opt standoff_end = end > # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 > # config opt config = ${prefix}/etc/monetdb5.conf > # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 > # config opt exec_prefix = ${prefix} > # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm > # config opt gdk_dbname = demo > # config opt gdk_alloc_map = no > # config opt gdk_embedded = no > # config opt gdk_debug = 0 > # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin > # config opt monet_daemon = no > # config opt monet_welcome = yes > # config opt delay = 120 > # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal > # config opt mal_listing = 15 > # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt > # config opt mapi_port = 0 > # config opt sql_debug = 0 > # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs > # config opt pf_httpd_port = 8080 > # config opt xquery_output = dm > # config opt xquery_cacheMB = 100 > # config opt xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs > # cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf > # cmdline opt gdk_debug = 10 > # cmdline opt monet_mod_path = /ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin > # cmdline opt gdk_dbfarm = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm > # cmdline opt sql_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs > # cmdline opt xquery_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs > # cmdline opt mapi_port = 31022 > # cmdline opt xrpc_port = 44351 > # cmdline opt monet_prompt = > # cmdline opt gdk_dbname = mTests_src_test_Connections_test1 > #warning: please don't forget to set your vault key! > #(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf) > > server 12 : "include sql;", client 1: SQL > > client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " > #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35647 " > !ERROR mapi_reconnect: connect: Connection refused > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 34 database 'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !IOException:mserver.connect:Could not connect: Setup connection failed > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' language 'sql'; > ERROR = !syntax error, unexpected LANGUAGE, expecting USER in: "connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' language" > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' database 'mTests_src_test_Connections_test1'; > ERROR = !syntax error, unexpected SCOLON, expecting USER in: "connect to 'localhost' database 'mTests_src_test_Connections_test1';" > MAPI = monetdb@localhost:34118 > QUERY = connect 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !syntax error, unexpected STRING, expecting TO in: "connect 'localhost'" > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 34119 as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !syntax error, unexpected AS, expecting DATABASE in: "connect to 'localhost' port 34119 as" > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' language 'sql'; > ERROR = !syntax error, unexpected LANGUAGE, expecting PASSWORD in: "connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' language" > MAPI = monetdb@localhost:34118 > QUERY = disconnect 'test_db_1'; > ERROR = !DISCONNECT CATALOG: no such db_alias 'test_db_1' > > server 12 : "include sql;", client 2: SQL > > client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " > #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=34118 " > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 341195 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !CONNECT TO: this connection already exists or the db_alias 'test_db' was already used! > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !CONNECT TO: this connection already exists or the db_alias 'test' was already used! > MAPI = monetdb@localhost:34118 > QUERY = connect to 'localhost' port 4000 database 'dmo' as 'test_db' user 'monetdb' password 'monetdb' language 'sql'; > ERROR = !CONNECT TO: this connection already exists or the db_alias 'test_db' was already used! > MAPI = monetdb@localhost:34118 > QUERY = disconnect 'test_db'; > ERROR = !DISCONNECT CATALOG: no such db_alias 'test_db' > MAPI = monetdb@localhost:34118 > QUERY = disconnect 'test_tb'; > ERROR = !DISCONNECT CATALOG: no such db_alias 'test_tb' > > server 12 : "include sql;", client 3: SQL > > client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " > #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35647 " > > # 12:08:39 > > # 12:08:39 > Done. > # 12:08:39 > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime serialize_dflt.mx, 1.23.2.3, 1.23.2.4
by Jan Rittinger 16 Mar '07

16 Mar '07

Jan, character references should be printed as decimal (not as octal) numbers. Cheers, Jan On 03/16/2007 11:20 AM, Jan Flokstra wrote with possible deletions: > Update of /cvsroot/monetdb/pathfinder/runtime > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv28663/runtime > > Modified Files: > Tag: XQuery_0-16 > serialize_dflt.mx > Log Message: > * Fix for Jens bug monetdb-Bugs-1681921 ] XQ: Character escaping is bogus > > echo '""' | MapiClient -lx -o xml > > Now results correctly in: > > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult></XQueryResult> > > > > Index: serialize_dflt.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/serialize_dflt.mx,v > retrieving revision 1.23.2.3 > retrieving revision 1.23.2.4 > diff -u -d -r1.23.2.3 -r1.23.2.4 > --- serialize_dflt.mx 15 Feb 2007 01:46:12 -0000 1.23.2.3 > +++ serialize_dflt.mx 16 Mar 2007 10:20:47 -0000 1.23.2.4 > @@ -180,7 +180,7 @@ > start = end + 1; > > if ( isspecial_ch == 1 ) { /* print octal */ > - stream_printf(ctx->out,"\\%03o",(unsigned char)src[end]); > + stream_printf(ctx->out,"&#%o;",(unsigned char)src[end]); > } else { > char *emit_val = dflt_ws->special_val[(int)isspecial_ch]; > int emit_len = dflt_ws->special_len[(int)isspecial_ch]; > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > -- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime serialize_dflt.mx, 1.31, 1.32
by Jan Rittinger 16 Mar '07

16 Mar '07

Hi Peter, your checkin message does not match your checkin: your change only ensures that the following four characters are not escaped anymore: '\"', '\'', '\t', and '\\'. Entities however were already escaped in the previous version. Cheers, Jan On 03/16/2007 02:08 AM, Peter Boncz wrote with possible deletions: > Update of /cvsroot/monetdb/pathfinder/runtime > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv18198 > > Modified Files: > serialize_dflt.mx > Log Message: > - XRPC strings should also escape entities > > > > Index: serialize_dflt.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/serialize_dflt.mx,v > retrieving revision 1.31 > retrieving revision 1.32 > diff -u -d -r1.31 -r1.32 > --- serialize_dflt.mx 15 Mar 2007 21:07:17 -0000 1.31 > +++ serialize_dflt.mx 16 Mar 2007 01:08:16 -0000 1.32 > @@ -1228,7 +1228,7 @@ > dflt_seqEmitBool, > dflt_seqEmitInt, > dflt_seqEmitDbl, > - dflt_seqEmitStr, > + dflt_handle_characters, > dflt_handle_attribute, > dflt_handle_characters, > > @@ -1264,7 +1264,7 @@ > dflt_seqEmitBool, > dflt_seqEmitInt, > dflt_seqEmitDbl, > - dflt_seqEmitStr, > + dflt_handle_characters, > dflt_handle_attribute, > dflt_handle_characters, > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > -- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

1 0

Re: [Monetdb-developers] Monetdb-developers Digest, Vol 10, Issue 2
by p.a.boncz 12 Mar '07

12 Mar '07

Martin, Please be more specific. Peter Message: 7 Date: Sat, 03 Mar 2007 07:53:28 +0100 From: Martin Kersten <Martin.Kersten(a)cwi.nl> Subject: [Monetdb-developers] MonetDB/src/gdk gdk_posix.mx brook testing To: monetdb-developers(a)lists.sourceforge.net Cc: Niels Nes <Niels.Nes(a)cwi.nl>, Fabian <Fabian.Groffen(a)cwi.nl>, Sjoerd Mullender <Sjoerd.Mullender(a)cwi.nl>, Stefan Manegold <Stefan.Manegold(a)cwi.nl> Message-ID: <45E91B68.1080408(a)cwi.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Peter, Good to see that you got old functionality in the heart of the system working on Windows. Its a pity that it completely broke tests on all other platforms due to our strict compilation scheme :-( A simple Mtest could have avoided it. regards, Martin

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler compile.c, 1.96.2.4, 1.96.2.5
by Ying Zhang 11 Mar '07

11 Mar '07

On Fri, Mar 09, 2007 at 01:27:44PM +0000, Peter Boncz wrote: > Update of /cvsroot/monetdb/pathfinder/compiler > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv5468/compiler > > Modified Files: > Tag: XQuery_0-16 > compile.c > Log Message: > FIX #1677094: compiler warning an weird 'sigmod' code in mps > > (plus, some minor xprc stuff) > > > > Index: compile.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/compile.c,v > retrieving revision 1.96.2.4 > retrieving revision 1.96.2.5 > diff -u -d -r1.96.2.4 -r1.96.2.5 > --- compile.c 17 Feb 2007 01:10:37 -0000 1.96.2.4 > +++ compile.c 9 Mar 2007 13:27:42 -0000 1.96.2.5 > @@ -196,26 +196,17 @@ > xmlParserInputBufferPtr buf; > char *ret, url[1024]; > > - /* support for the xrpc://x.y.z/URI naming scheme (maps to http://x.y.z:<xrpc_port>[/xrpc]/URI) */ > + /* support for the xrpc://x.y.z/URI naming scheme (maps to http://x.y.z:<xrpc_port>/URI) */ Hi Peter, I don't understand this change. With "/xrpc" the request will be directed to our own file request handler which retrieves 'URI' from MXQ, instead of from disk. What is your intention here? Jennie > if (strncmp(uri, "xrpc://", 7) == 0) { > - char *xrpc = ""; > char *p = strchr(uri+7, '/'); > char *q = strchr(uri+7, ':'); > int port = xrpc_port; > - if (p) { > - char *suffix = p + strlen(p) - 4; > - if (suffix > p && !(strcmp(suffix,".xml") && strcmp(suffix,".XML"))) { > - /* GET requests on XML get magically mapped on fn:doc(). Add xrpc/ to URI. */ > - xrpc = "/xrpc"; > - } /* else: request is simply redirected to xrpc HTTP server (file serving) */ > - *p = 0; > - } > - if (q) { > + if (q && (p == NULL || p > q)) { > /* if a specific port is omitted, we use the current xrpcd port number */ > port = atoi(q+1); > *q = 0; > } > - snprintf(url, 1024, "http://%s:%d%s/%s", uri+7, port, xrpc, p?(p+1):""); > + snprintf(url, 1024, "http://%s:%d/%s", uri+7, port, p?(p+1):""); > if (p) *p = '/'; > if (q) *q = ':'; > } else { > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins

1 1