- developers-list - monetdb.org

[Monetdb-developers] MAL access to tables created with SQL
by darabi＠web.de 13 Oct '07

13 Oct '07

Hello, how is it possible to access in a MAL client session (mclient -l mal) the BATs of tables which were created previously in sql? I have tried different versions of bat.new, and bbp.bind. I tried different naming schemes (e.g. "tablename_columnname" which was mentioned somewhere in the docs), but I always get Referenced BAT not found And when I try to use sql.bind, I get SQLException:mvc:MAL_SCENARIO_PARSER not initialized Another question: is there a way of seeing the MAL translation of sql queries? EXPLAIN works great for SELECT statements, but it doesn't translate DDL expressions like CREATE TABLE. Many thanks Kambiz

4 8

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugDay_2005-10-06_2.8/Tests MapiClient-dump.SF-905851.SQL.py, SQL_2-20, 1.1.2.1, 1.1.2.2
by Stefan Manegold 13 Oct '07

13 Oct '07

Hi, this any all other tests that were ported from .sh/.bat to .py yesterday now fail on platforms that have a pyhton installed without subprocess; cf., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/index_… To solve the problem, in all newly added .py scripts, ======== import subprocess ======== should be replaced by ======== try: import subprocess except ImportError: # use private copy for old Python versions import MonetDB.subprocess26 as subprocess ======== as in Mtest.py[.in] to fall-back to the subprocess that we provide with MonetDB in case there is none available on the respective system. However, before checking in, please coordinate with Sjoerd, first! Stefan On Fri, Oct 12, 2007 at 09:53:41AM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.8/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31626 > > Modified Files: > Tag: SQL_2-20 > MapiClient-dump.SF-905851.SQL.py > Log Message: > On windows the stdout and stderr of a python subprocess is not automatically redirect to > main process stdout and stderr. > The proper way is to use Popen and then use a PIPE to read the stderr > and stdout from the subprocess. > > NOTE: This script was tested on windows and Linux, and the test became green on both platforms. ;) > > > > Index: MapiClient-dump.SF-905851.SQL.py > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.SQL.py,v > retrieving revision 1.1.2.1 > retrieving revision 1.1.2.2 > diff -u -d -r1.1.2.1 -r1.1.2.2 > --- MapiClient-dump.SF-905851.SQL.py 11 Oct 2007 14:40:50 -0000 1.1.2.1 > +++ MapiClient-dump.SF-905851.SQL.py 12 Oct 2007 09:53:39 -0000 1.1.2.2 > @@ -1,15 +1,21 @@ > -import os, sys > +import os, sys, subprocess > + > + > +def client(cmd): > + clt = subprocess.Popen(cmd, shell=True, stdout=subprocess.PIPE, stderr=subprocess.PIPE) > + sys.stdout.write(clt.stdout.read()) > + clt.stdout.close() > + sys.stderr.write(clt.stderr.read()) > + clt.stderr.close() > + > > > def main(): > clcmd = ("%s/bin/Mlog -x " % os.getenv('MONETDB_PREFIX')) + str(os.getenv('SQL_CLIENT')) + "< %s" % ('%s/JdbcClient_create_tables.sql' % os.getenv('RELSRCDIR')) > clcmd1 = ("%s/bin/Mlog -x " % os.getenv('MONETDB_PREFIX')) + str(os.getenv('SQL_CLIENT')) + "< %s" % ('%s/JdbcClient_inserts_selects.sql' % os.getenv('RELSRCDIR')) > clcmd2 = ("%s/bin/Mlog -x " % os.getenv('MONETDB_PREFIX')) + str(os.getenv('SQL_DUMP')) > - clt = os.popen(clcmd, 'w') > - clt.close() > - clt1 = os.popen(clcmd1, 'w') > - clt1.close() > - clt2 = os.popen(clcmd2, 'w') > - clt2.close() > + client(clcmd) > + client(clcmd1) > + client(clcmd2) > > main() > > > ------------------------------------------------------------------------- > 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-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 1

[Monetdb-developers] clients on windows 32...
by Romulo Goncalves 13 Oct '07

13 Oct '07

Why the option \h - show the readline history mclient.exe -lsql --help Is not available on windows? Is an design feature or a bug? Regards, Romulo

6 16

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/tools mcheckpoint, , 1.2, 1.3
by Sjoerd Mullender 12 Oct '07

12 Oct '07

How does this checkin message cover the change made here? On 2007-10-12 19:40, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/tools > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9755/tools > > Modified Files: > mcheckpoint > Log Message: > Use a stricter runtime test to trap possible BAT bind mismatchs. > > > Index: mcheckpoint > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/tools/mcheckpoint,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > --- mcheckpoint 9 Sep 2007 10:00:17 -0000 1.2 > +++ mcheckpoint 12 Oct 2007 17:40:25 -0000 1.3 > @@ -20,9 +20,8 @@ > function usage() > { > echo "Usage: mcheckpoint [options] " > - echo " --dbname=<database_name>" > + echo " --database=<database_name>" > echo " --ascii=<yes/no> default no" > - echo " --tool=<mapi/jdbc> default mapi" > echo " --dir=<directory>" > echo " --help" > exit 0 > @@ -99,8 +98,8 @@ > die "--tool: '${1#--tool=}' not understood, use 'mapi' or 'jdbc'" > esac > ;; > - --dbname=*) > - DBNAME="${1#--dbname=}" > + --database=*) > + DBNAME="${1#--database=}" > ;; > --dir=*) > CHKPNTDIR="${1#--dir=}" > > > ------------------------------------------------------------------------- > 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 -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] Simple bat operations
by darabi＠web.de 12 Oct '07

12 Oct '07

Hello Nils, OK, then something doesn't work. When I try your suggestion, I get this: user@host$ mclient -d demo -l mal mal>b := bat.new(:int,:int); mal>io.print(b); #-----------------# # h t # name # int int # type #-----------------# mal>bat.setName(b,"test"); mal>bat.setPersistent(b,true); mal>transaction.commit(); mal>\q user@host$ mclient -d demo -l mal mal>b:= bbp.bind("test"); mal>io.print(b); MAPI = monetdb@127.0.0.1:50001 QUERY = io.print(b); ERROR = !TypeException:user.main[1]:'b' may not be used before being initialized mal>\q I have downloaded and compiled MonetDB-Mars-SuperBall-SR3.tar.bz2 on an Ubuntu i686 single cpu system running a 2.6.20 kernel. user@host$ ps auxwww | grep mserver user 12072 0.0 4.3 133232 67268 ? Ssl Oct10 0:01 /opt/monetdb/bin/mserver5 --dbfarm=/opt/monetdb/var/MonetDB5/dbfarm --set daemon yes --set monet_welcome no --dbname=voc --config=/opt/monetdb/var/MonetDB5/dbfarm/voc/.monetdb.conf /opt/monetdb/var/MonetDB5/dbfarm/voc/.mserver5.dbinit user 12479 0.0 3.9 109320 61760 ? Ssl Oct10 0:00 /opt/monetdb/bin/mserver5 --dbfarm=/opt/monetdb/var/MonetDB5/dbfarm --set daemon yes --set monet_welcome no --dbname=demo --config=/opt/monetdb/var/MonetDB5/dbfarm/demo/.monetdb.conf user@host$ mserver5 --version MonetDB Server v5.0.0 Copyright (c) 1993-2007 CWI, all rights reserved Compiled by: sjoerd(a)localhost.localdomain Compilation: gcc -O2 -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt Linking: ld -IPA -m elf_x86_64 I already tried 'mclient -l sql' without any apparent problems, so it appeared unlikely that there were bigger issues. I will try to run the test suite(s). Thank you very much Kambiz ----- Original Message ----- From: "Niels Nes" <Niels.Nes(a)cwi.nl> To: darabi(a)web.de Sent: Donnerstag, 11. Oktober 2007 16.24 Uhr (GMT+0100) Europe/Berlin Subject: Re: [Monetdb-developers] Simple bat operations On Thu, Oct 11, 2007 at 02:34:15PM +0200, darabi(a)web.de wrote: > In the meantime, I have also tried all the bbp functions which > I could think of: > > bbp.find > bbp.bind > bbp.take > > But none of them gives me a bat which I can use. Strangely, none of > them says anything about whether the function call succeeded > or not. okay here a small example then b := bat.new(:int,:int); io.print(b); bat.setName(b,"test"); bat.setPersistent(b,true); transaction.commit(); # after server restart the following should work. b:= bbp.bind("test"); io.print(b); Niels > > > Kambiz > > ----- Original Message ----- > From: darabi(a)web.de > To: monetdb-developers(a)lists.sourceforge.net > Cc: "Niels Nes" <Niels.Nes(a)cwi.nl> > Sent: Donnerstag, 11. Oktober 2007 9.47 Uhr (GMT+0100) Europe/Berlin > Subject: Re: [Monetdb-developers] Simple bat operations > > Niels, > > thank you very much for your help. > > How can I access this bat, when I start a new session? > > bat.load("person_name"); > > doesn't seem to work. io.print(n): > > ERROR = !TypeException:user.main[1]:'n' may not be used before being initialized > > > Thanks > > Kambiz > > ----- Original Message ----- > From: "Niels Nes" > To: darabi(a)web.de > Cc: monetdb-developers(a)lists.sourceforge.net > Sent: Donnerstag, 11. Oktober 2007 9.38 Uhr (GMT+0100) Europe/Berlin > Subject: Re: [Monetdb-developers] Simple bat operations > > On Thu, Oct 11, 2007 at 08:00:36AM +0200, darabi... wrote: > > Hello, > > > > sorry for asking so many dumb questions, but I don't seem > > to be able to find the answers in the docs. > > > > I try to create and persist a bat: > > > > (mclient -d demo -l mal) > > > > n := bat.new(:oid,:str); > > bat.setName(n, "person_name"); > > bat.setPersistent(n, true); > > > > bat.append(n, "John", true); > > bat.append(n, "James", true); > > > > replace this save > > bat.save(n); > by > > transaction.commit(); > > Niels > > (ps later you probably want to switch to subcommit, ie only commit those > bat that changed, for this see the documenation in the transaction module > (src/modules/mal/transaction.mx) > > > > But this doesn't seem to be sufficient. > > > > Or at least I then don't know how to load this bat the next > > time I start mclient. > > > > Is there a file (one of the tests or sth.) which contains > > such basic tests? I tried to find-grep over them, but didn't > > succeed in finding what I was looking for. > > > > > ------------------------------------------------------------------------- > 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-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > > ------------------------------------------------------------------------- > 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-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers -- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl

6 20

Re: [Monetdb-developers] Monetdb-developers Digest, Vol 17, Issue 6
by Peter Boncz 11 Oct '07

11 Oct '07

Dear Stefan, Thanks for your question, but I regret to inform you that your way of communicating technical problems severely falls short of what is required by technical etiquette: (1) ambiguous software version description: you cannot be running MonetDB4 and MonetDB5 at the same time. Even more, I want to know the exact version number of the software, whether it was a 32-bits or 64-bits build (and if so, whether it used 64-bits or 32-bits oids). (2) major omissions in your platform description. I presume you have installed an operating system on your Xeon. Would you care to tell us which operating system that is? (3) ill-described reproduction path. Your bug report suggests being about updates, but as far as I read your email, I doubt you did any updates yet. This is again is crucial information. Thus, my main answer is that you have to retry describing your problem, paying better attention to the above three points. The error you see is the "remap" call failing -- the most probable cause of error is VM space shortage. For MonetDB to work on 20GB size datasets you must use a 64-bits operating system and MonetDB binary, and may even 64-bits oids (because your volume of text nodes is likely to be significant). Peter Boncz

2 3

[Monetdb-developers] Simple bat operations
by darabi＠web.de 11 Oct '07

11 Oct '07

Hello, sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs. I try to create and persist a bat: (mclient -d demo -l mal) n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true); bat.append(n, "John", true); bat.append(n, "James", true); bat.save(n); But this doesn't seem to be sufficient. Or at least I then don't know how to load this bat the next time I start mclient. Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for. Thanks you for your patience. Kambiz

2 3

[Monetdb-developers] Simple bat operations
by Kambiz Darabi 11 Oct '07

11 Oct '07

Hello, sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs. I try to create and persist a bat: (mclient -d demo -l mal) n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true); bat.append(n, "John", true); bat.append(n, "James", true); bat.save(n); But this doesn't seem to be sufficient. Or at least I then don't know how to load this bat the next time I start mclient. Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for. Thanks you for your patience. Kambiz

1 0

[Monetdb-developers] Fixing the update issue for Large XML documents
by Stefan de Konink 11 Oct '07

11 Oct '07

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hello, A short introduction. I'm Stefan de Konink, one of the students in the ADT course at the University of Amsterdam. I have a degree in Advanced Computer Science, so I know what C looks like ;) Currently I can use MonetDB on a rather heavy machine, basically to benchmark the storage of this machine. And look for bottle necks. I am also a participant of OpenStreetMap NL, as datacollector from already existing GIS data. OpenStreetMap runs on MySQL in the UK, and I wanted to find out if I could run it more efficiently on MonetDB. For compatibility reasons OSM publishes an XML file containing the current view of the database daily. My 'job' to see if I could get the same results on this XML file (using XQuery) as the active MySQL/Ruby implementation. Importing a 20GB XML file was great, but now the 'lessons' progressed we should update the data. So I took a recent version of the document (they migrated from one format to another this week), allocated 5% slackspace and run the pf:add-doc. This went ok, but the trick to count all nodes ended up in: > xquery> > more> fn:count(doc("planet.osm")//*) > more>MAPI = monetdb@localhost:50000 > QUERY = fn:count(doc("planet.osm")//*) > ERROR = !ERROR: [remap]: 5 times inserted nil due to errors at tuples > 1@0, 2@0, 3@0, 4@0, 5@0. > !ERROR: [remap]: first error was: > !ERROR: CMDremap: operation failed. > !ERROR: interpret_unpin: [remap] bat=492,stamp=-729 OVERWRITTEN > !ERROR: BBPdecref: 1000000001_rid_nid does not have pointer fixes. > !ERROR: interpret_params: leftfetchjoin(param 2): evaluation error. (As posted to the bugtracker and privately to the lecturer.) My first guess was that the 1..5 maybe had something to do with the 'slackspace' that was five also. Today I imported the same document readonly without any problems. To confirm 'import-updating' in general works I took the data from only The Netherlands and imported this. (143MB) Which worked like a charm. I'm running MonetDB4/5 (SR3) on a Quad Xeon, 8GB memory. Storage is a bit variable ;) But currently on local raid5. Are there any suggestions from the developers to catch this bug? Upgrading to CVS could be an option. Trying again with CVS is an option, trying again with a smaller document too, or if someone instantly comes up with a solution that could be nice too ;) Yours Sincerely, Stefan de Konink -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHDXXIYH1+F2Rqwn0RCk/VAJwLpXp0Yl1ENToPMRFgIJy2No/BMgCdFv7C dGQzJgoGmwM9ucPxrohIkFk= =sHEr -----END PGP SIGNATURE-----

1 0

Re: [Monetdb-developers] Object persistence using MonetDB
by darabi＠web.de 10 Oct '07

10 Oct '07

Thank you for the information. So, does that mean that you generally do not recommend the use of MonetDB beyond the realms of > datawarehouses, information retrieval, and data mining ? >From the result of the web application contest in the ct magazine, I had the impression that 'normal' applications could also benefit from the architecture of MonetDB: http://sourceforge.net/forum/forum.php?forum_id=584739 What I would like to do is to create a persistence engine for a Prolog like language which has a type system. Which means that data is to be stored in tuples. To experiment with MAL, I would have to use the MapiClient, right? I think I will try to play with it. Thank you Kambiz ----- Original Message ----- From: "Martin Kersten" <Martin.Kersten(a)cwi.nl> To: darabi(a)web.de, monetdb-developers-bounces(a)lists.sourceforge.net Sent: Mittwoch, 10. Oktober 2007 11.01 Uhr (GMT+0100) Europe/Berlin Subject: Re: [Monetdb-developers] Object persistence using MonetDB darabi(a)web.de wrote: > Hello, > > I'm a developer located in Germany with a current interest in > object persistence for a dynamically typed language. > Hello, thank you for your interest in the MonetDB software. > I was experimenting with something along the lines of the > decomposed storage model when I found out that it was (of course) > decades old and found the papers about it and MonetDB. > > Many thanks for your efforts and for this great piece of software. > > I was reading the 1995 CWI report 'High Performance support for > OO traversals in monet' and was wondering whether the ideas > in it are still present in today's MonetDB. And if not, how > much effort would it take to implement OO persistence using > MAL. I would also appreciate any pointer to papers, code samples > etc. in this direction. > Between 1995 and 2003 MonetDB was used in the company Data Distilleries (now part of SPSS) where the interaction between application and DBMS was based on persistent objects. However, the thrust of the development is not on individual object access, but bulk processing as it emerges from datawarehouses, information retrieval, and data mining. > If I understand correctly, in the beginning, MonetDB was rather > heading towards a OODBMS. Was there any reason why you didn't > pursue that goal? Is there any road block? > There are (have been) attempts to hook up Hibernate and MonetDB. I don't know their status. If ultra-high performance is your target, I question if a DBMS is the right way to go. However, I also think that most o-o applications might better benefit from relational view on data. regards, Martin > > Thank you very much for your help. > > > Kambiz Darabi >

2 1