- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/backends/monet5 merovingian.mx, , 1.9, 1.10
by Stefan Manegold 25 Nov '07

25 Nov '07

On Sun, Nov 25, 2007 at 10:18:26AM +0000, Fabian wrote: > Update of /cvsroot/monetdb/sql/src/backends/monet5 > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26685 > > Modified Files: > merovingian.mx > Log Message: > Attempt to fix some compiler warnings. I cannot test myself, as I don't > get them, and if I use TestWeb's CFLAGS the code doesn't compile at all > at a much earlier stage. "TestWeb" does not use any (particular) CFLAGS, but just the default that (our) configure uses/provides (with --enable-strict, which is default for the development trunk). In case you have problems with this (or other) settings, please help us fixing them by reporting them ans bug report. The compiler warning is triggered by the following setting in lines 742,3 of buildtools/conf/MonetDB.m4 ======== dnl The default configure invocation when doing an rpmbuild also uses this X_CFLAGS="$X_CFLAGS -Wp,-D_FORTIFY_SOURCE=2" ======== Some functions (system calls) do return, whether they were successful, or not, and the calling ocde should check the respective return values. Ignoring them via (e.g.) (void)write(...); will (most probably) not help. Rather, the code should check the results, e.g., if (write(...) < 0) { ... } or at least pretend to do so, e.g., ssize_t wrt_res = 0; wrt_res = write(...); (void)wrt_res; /* deliberately irgnore portential errors */ Stefan > Index: merovingian.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/backends/monet5/merovingian.mx,v > retrieving revision 1.9 > retrieving revision 1.10 > diff -u -d -r1.9 -r1.10 > --- merovingian.mx 25 Nov 2007 09:55:05 -0000 1.9 > +++ merovingian.mx 25 Nov 2007 10:18:24 -0000 1.10 > @@ -1203,10 +1203,10 @@ > case -1: > /* oops, forking went wrong, cheat a bit in order to write to > * the console */ > - write(oerr, "unable to fork into background: ", > + (void)write(oerr, "unable to fork into background: ", > sizeof("unable to fork into background: ")); > - write(oerr, strerror(errno), strlen(strerror(errno))); > - write(oerr, "\n", 1); > + (void)write(oerr, strerror(errno), strlen(strerror(errno))); > + (void)write(oerr, "\n", 1); > return(1); > case 0: > /* the child, we want to keep it, try to lock, we can only > @@ -1217,17 +1217,17 @@ > * remain available, otherwise we loose the lock */ > if ((ret = MT_lockf(buf, F_TLOCK, 4, 1)) == -1) { > /* locking failed */ > - write(oerr, "another merovingian is already running\n", > + (void)write(oerr, "another merovingian is already running\n", > sizeof("another merovingian is already running\n")); > exit(1); > } else if (ret == -2) { > /* directory or something doesn't exist */ > - write(oerr, "unable to create .merovingian_lock file in ", > + (void)write(oerr, "unable to create .merovingian_lock file in ", > sizeof("unable to create .merovingian_lock file in ")); > - write(oerr, dbfarm, strlen(dbfarm)); > - write(oerr, ": ", 2); > - write(oerr, strerror(errno), strlen(strerror(errno))); > - write(oerr, "\n", 1); > + (void)write(oerr, dbfarm, strlen(dbfarm)); > + (void)write(oerr, ": ", 2); > + (void)write(oerr, strerror(errno), strlen(strerror(errno))); > + (void)write(oerr, "\n", 1); > exit(1); > } > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > -- | 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 |

2 2

[Monetdb-developers] New MonetDB Bug Fix Release
by Sjoerd Mullender 24 Nov '07

24 Nov '07

The MonetDB team at CWI is pleased to announce a new bug fix release of the MonetDB suite of programs. The following packages have been released: MonetDB Clients 1.20.2 MonetDB5 Server 5.2.2 MonetDB SQL 2.20.2 There is of course also a new "Super Source Ball", a tarball containing the combined sources. All this is available on our SourceForge project page. See https://sourceforge.net/project/showfiles.php?group_id=56967 for the downloadable files. See http://monetdb.cwi.nl/projects/monetdb/Development/Releases/Version4.20/ind… for a list of fixes. -- Sjoerd Mullender

1 0

[Monetdb-developers] Start studying MonetDB code
by Marco Antonelli 23 Nov '07

23 Nov '07

Hello everyone, I am an Italian student, and I will work at MonetDB/SPARQL for my master thesis starting from next January, in Amsterdam. Prof. Martin Kersten told to have a look at the code, in particular the SQL->MAL translator. So I downloaded the code, and managed to compile and install it correctly (on Linux). Then I opened the code in Eclipse (do you use it too? do you use some better C IDE?) and started to look at MonetDB5-server. Prof. Kersten told not to worry... but that's impressive! So where do you suggest me to start? Which c files and functions first? Thanks in advance and kind regards, Marco Antonelli

2 2

Re: [Monetdb-developers] [Monetdb-checkins] buildtools/conf MonetDB.m4, MonetDB_1-20, 1.37.2.14, 1.37.2.15
by Fabian Groffen 21 Nov '07

21 Nov '07

On 21-11-2007 15:07:04 +0000, Stefan Manegold wrote: > +case "$host-$GCC-$CC-$enableval" in > +ia64*-*-*-32) > + AC_MSG_ERROR([we do not support 32 bits on $host]);; So HPUX's 32-bits support on ia64 is not supported :( > +i?86*-*-*-64) > + AC_MSG_ERROR([$host does not support 64 bits]);; So Darwin's multilib compiler (i386-apple-darwin[89]) is assumed not to handle 64-bits code here :( > +*--icc*-32|*--icc*-64) > + AC_MSG_ERROR([icc does not support a command line option to switch between 32- & 64-bit compilation; use CC & PATH (instead of --enable-bits=$enableval) to point to the $enableval-bit version of icc]);; > +*-*-*-32|*-*-*-64) > ;; > -*) AC_MSG_ERROR(--enable-bits argument must be either 32 or 64);; > +*) > + AC_MSG_ERROR(--enable-bits argument must be either 32 or 64);; Clever one ;)

2 3

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/mapi/Tests All, SQL_2-20, 1.1.2.6, 1.1.2.7
by Stefan Manegold 21 Nov '07

21 Nov '07

On Wed, Nov 21, 2007 at 11:07:47AM +0000, Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/test/mapi/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv25856 > > Modified Files: > Tag: SQL_2-20 > All > Log Message: > disabled python_dbapi_embedded as fixing this problem requires an embedded > api change (ie we should pass more configuration options, ie monetdb_mod_path > too find sql_server/sql in weird places) > > !!! this should not be forwarded to the current branch !!! propagation of this change has been prevented. Stefan > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/mapi/Tests/All,v > retrieving revision 1.1.2.6 > retrieving revision 1.1.2.7 > diff -u -d -r1.1.2.6 -r1.1.2.7 > --- All 22 Oct 2007 19:58:08 -0000 1.1.2.6 > +++ All 21 Nov 2007 11:07:44 -0000 1.1.2.7 > @@ -8,6 +8,6 @@ > mclient-lsql--help > HAVE_PERL_SWIG?perl_dbi > HAVE_PYTHON_SWIG?python_dbapi > -HAVE_PYTHON_SWIG?python_dbapi_embedded > +#HAVE_PYTHON_SWIG?python_dbapi_embedded > HAVE_PHP?php_monetdb > > > -- | 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 |

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker/Tests auto_increment.SF-1834820.sql, SQL_2-20, NONE, 1.1.2.1
by Stefan Manegold 20 Nov '07

20 Nov '07

Please note that this new test will not be executed, unless also added to the repstective "All" file. Stefan On Tue, Nov 20, 2007 at 06:50:31AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29561 > > Added Files: > Tag: SQL_2-20 > auto_increment.SF-1834820.sql > Log Message: > Added the test file. Output needs to be produced. > > > --- NEW FILE: auto_increment.SF-1834820.sql --- > CREATE TABLE testusers ( > id INT NOT NULL AUTO_INCREMENT, > name VARCHAR(40), > fullname VARCHAR(100), > PRIMARY KEY (id) > ); > > > INSERT INTO testusers (id, name, fullname) VALUES (1, 'wendy', 'Wendy > Wones'); > select * from testusers; > > -- This will fail the first time > INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone'); > select * from testusers; > > -- Now it will succeed > INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone'); > select * from testusers; > > drop table testusers; > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > > -- | 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 |

1 0

[Monetdb-developers] bat.new undefined
by darabi＠web.de 15 Nov '07

15 Nov '07

Hello, I am trying to make a small function for creating some persistent bats. Could you point me to my (probably stupid) error? Many thanks Kambiz $ mclient --language=mal -d demo mal> mal>function init_schema():void; mal> mal> bbp.bind("schema_version"); mal> mal> # create schema, if it doesn't exist mal> catch MALException:str; mal> mal> s := bat.new(:void,:oid); mal> bat.setName(s, "schema"); mal> bat.setPersistent(s); mal> mal> s := bat.new(:void,:void); mal> bat.setName(s, "version"); mal> bat.setPersistent(s); mal> mal> sv := bat.new(:oid,:int); mal> bat.setName(sv, "schema_version"); mal> bat.setPersistent(sv); mal> mal> cl := bat.new(:oid,:oid); mal> bat.setName(sv, "schema_class"); mal> bat.setPersistent(sv); mal> mal># etc. etc. etc. mal> mal> transaction.commit(); mal> mal> exit; MAPI = monetdb@localhost:50000 QUERY = exit; ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) mal> MAPI = monetdb@localhost:50000 QUERY = ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[18]:begin 'MALException' without exit in init_schema[19] mal> io.print("Schema tables seem to exist. Will do nothing\n"); MAPI = monetdb@localhost:50000 QUERY = io.print("Schema tables seem to exist. Will do nothing\n"); ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[19]:begin 'MALException' without exit in init_schema[20] mal>end init_schema; MAPI = monetdb@localhost:50000 QUERY = end init_schema; ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[18]:begin 'MALException' without exit in init_schema[19] mal>

3 5

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder MonetDB-XQuery.spec.in, , 1.42, 1.43
by Sjoerd Mullender 13 Nov '07

13 Nov '07

Please spell check. Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27856 > > Modified Files: > MonetDB-XQuery.spec.in > Log Message: > - added a separate JAR package for the XRPC java API files > - added the new file for 'make rpm' as well > > > > > Index: MonetDB-XQuery.spec.in > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/MonetDB-XQuery.spec.in,v > retrieving revision 1.42 > retrieving revision 1.43 > diff -u -d -r1.42 -r1.43 > --- MonetDB-XQuery.spec.in 15 Oct 2007 15:39:06 -0000 1.42 > +++ MonetDB-XQuery.spec.in 13 Nov 2007 13:56:50 -0000 1.43 > @@ -90,14 +90,21 @@ > automatic index management, extensibility of data types and search > accelerators, SQL- and XQuery- frontends. > > -This package contains an XRPC Wrapper (xrpcwrapper.jar), a stand-alone > -Java program that can be pluged in on top of an XQuery engine to handle > -non-nested XRPC requests (i.e. requests that do not trigger another XRPC > -request). > +This package contains three Java Archieves > +- xrpcwrapper.jar: the XRPC Wrapper, which is a stand-alone Java program > + that can be pluged in on top of an XQuery engine to handle non-nested > + XRPC requests (i.e. requests that do not trigger another XRPC > + request). > > -This package also contains an example client program > -(xrpcwrapper-test.jar), which (i) can be used to test the XRPC Wrapper, > -and (ii) shows how to write an XRPC Java client. > +- xrpcwrapper-test.jar: an example client program, which (i) can be used > + to test the XRPC Wrapper, and (ii) shows how to write an XRPC Java > + client. > + > +- xrpcutil.jar: the XRPC Java API, which includes funcionts for > + -- creating XRPC request messages, > + -- parsing XRPC response messages, > + -- send and/or receive XRPC messages using HTTP connection, > + -- XRPC specific exception classes > > %endif > > @@ -162,7 +169,7 @@ > %files xrpcwrapper > %defattr(-,root,root) > %dir %{_datadir}/MonetDB/lib > -%{_datadir}/MonetDB/lib/xrpcwrapper*.jar > +%{_datadir}/MonetDB/lib/xrpc*.jar > %endif > > %files devel > > > ------------------------------------------------------------------------- > 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-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] Physical stack space
by Maurice van Keulen 12 Nov '07

12 Nov '07

Hi, When writing recursive xqueries that that manipulate somewhat larger documents, MonetDB frequently quits with the error message !ERROR: interpret: running out of physical stack space! Is there a way to increase the physical stack space? I found no parameter to set in MonetDB.conf, perhaps in the source somewhere? Maurice. -- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Assistant Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW: http://www.cs.utwente.nl/~keulen

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/testing Mtest.py.in, , 1.320, 1.321
by Stefan Manegold 07 Nov '07

07 Nov '07

On Wed, Nov 07, 2007 at 03:44:26PM +0000, Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB/src/testing > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21513 > > Modified Files: > Mtest.py.in > Log Message: > > added pythonlibdir (obtained from monetdb-config and monetdb-clients-config) > into the PYTHONPATH (in an attempt to fix the problems with tests using > MonetSQLdb) should the respective test do this locally? I recall addint something like this to (some of) the MonetSQLdb tests ... Stefan > > > > Index: Mtest.py.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/testing/Mtest.py.in,v > retrieving revision 1.320 > retrieving revision 1.321 > diff -u -d -r1.320 -r1.321 > --- Mtest.py.in 2 Nov 2007 07:31:36 -0000 1.320 > +++ Mtest.py.in 7 Nov 2007 15:44:24 -0000 1.321 > @@ -102,6 +102,17 @@ > import distutils.sysconfig > p = _configure(os.path.join('@QXprefix@',distutils.sysconfig.get_python_lib(1,0,""))) > sys.path.insert(0, p) > + try: > + q = GetConfig('monetdb-config', '--pythonlibdir') > + p = p + os.pathsep + q > + except: > + None > + try: > + q = GetConfig('monetdb-clients-config', '--pythonlibdir') > + p = p + os.pathsep + q > + p = p + os.pathsep + q + os.sep + 'MonetDB' > + except: > + None > from MonetDB import monet_options > if os.environ.has_key('PYTHONPATH'): > p = p + os.pathsep + os.environ['PYTHONPATH'] > > > ------------------------------------------------------------------------- > 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-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > > -- | 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 |

2 1