- developers-list - monetdb.org

[Monetdb-developers] release show stopper
by Sjoerd Mullender 27 May '09

27 May '09

I have a serious problem with the release on Windows. If I first install the old (April 2009, ie Feb2009-SP2) version, create a table and insert a value (the latter probably not necessary): create table foo (s varchar (10)); insert into foo values ('test'); exit client and server, then upgrade to new version, the table gets lost: sq1>select * from foo; !SELECT: no such table 'foo' When I tried this on Linux, it worked. select * from tables; works and looks good, except that there is no mention of the foo table. So far I've only tried this on 32 bit Windows and 64 bit Fedora 10. It could be that the problem is a 32/64 bit problem, or a Windows/Linux problem. In any case, this is a show stopper. The problem persists if I first have the logger flush itself before the upgrade, so I don't think it's a logger problem. (On Windows, the log directory is moved automatically by the command script. This works.) -- Sjoerd Mullender

1 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/algebra algebra_cse.c, , 1.82, 1.83
by Jan Rittinger 27 May '09

27 May '09

Tom, please include all semantical information (also tcols) in this test. On May 27, 2009, at 16:02, Tom Schreiber wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/algebra > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv27564/compiler/ > algebra > > Modified Files: > algebra_cse.c > Log Message: > -- Fixed the equality-check for the referenced-table-operator > (la_ref_tbl). > > U algebra_cse.c > Index: algebra_cse.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/algebra/algebra_cse.c,v > retrieving revision 1.82 > retrieving revision 1.83 > diff -u -d -r1.82 -r1.83 > --- algebra_cse.c 7 May 2009 14:22:39 -0000 1.82 > +++ algebra_cse.c 27 May 2009 14:02:41 -0000 1.83 > @@ -183,11 +183,20 @@ > return true; > break; > > - > - case la_ref_tbl: > - > - return (strcmp(a->sem.ref_tbl.name, b- > >sem.ref_tbl.name) == 0); > - break; > + case la_ref_tbl: > + > + if (strcmp(a->sem.ref_tbl.name, b->sem.ref_tbl.name) != 0) > + return false; > + > + if (a->schema.count != b->schema.count) > + return false; > + > + for (unsigned int i = 0; i < a->schema.count; i++) > + if (a->schema.items[i].name != b->schema.items[i].name || > + a->schema.items[i].type != b->schema.items[i].type) > + return false; > + return true; > + break; > > case la_attach: > return (a->sem.attach.res == b->sem.attach.res && > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity > professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp as they present alongside digital heavyweights like > Barbarian > Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Jan Rittinger Lehrstuhl Datenbanken und Informationssysteme Wilhelm-Schickard-Institut für Informatik Eberhard-Karls-Universität Tübingen http://www-db.informatik.uni-tuebingen.de/team/rittinger

1 0

Re: [Monetdb-developers] autogen.py
by RichardGUO Fei 26 May '09

26 May '09

The problem is resolved. I just edited the Makefile.am directly and then use automake. From: gladiatorcn(a)hotmail.com To: monetdb-developers(a)lists.sourceforge.net Subject: autogen.py Date: Mon, 25 May 2009 17:52:00 +0000 Hi, I am new to MonetDB development. I add some source files to MonetDB/MonetDB/src/gdk, which rely on the external libraries. When I try to modify Makefile.am in order to add the relevant link information. It says that it was generated by autogen.py. To be honest, I do not know autogen.py and I could not find any useful information from Google. Could you guys give a little hint please? Thank you very much! Fei 把MSN装进手机，更多聊天乐趣等你挖掘！立刻下载！ _________________________________________________________________ 打工，挣钱，买房子，快来MClub一起”金屋藏娇”！ http://club.msn.cn/?from=10

2 2

[Monetdb-developers] autogen.py
by RichardGUO Fei 25 May '09

25 May '09

Hi, I am new to MonetDB development. I add some source files to MonetDB/MonetDB/src/gdk, which rely on the external libraries. When I try to modify Makefile.am in order to add the relevant link information. It says that it was generated by autogen.py. To be honest, I do not know autogen.py and I could not find any useful information from Google. Could you guys give a little hint please? Thank you very much! Fei _________________________________________________________________ 打工，挣钱，买房子，快来MClub一起”金屋藏娇”！ http://club.msn.cn/?from=10

1 0

Re: [Monetdb-developers] Installing MonetDB5 (Stable) failed on Int.32.32.d.1-Windows5.1 Mic.32.32.d.1-Windows5.1 Int.64.32.d.1-Windows5.2 Mic.64.32.d.1-Windows5.2 Mic.64.64.d.1-Windows5.2
by Stefan Manegold 25 May '09

25 May '09

Dear all, removing the *_export macro definitions from .c source files seems to have broken M5 compilation on Windows --- I'm busy fixing it by re-adding these definitions in .h header files... Stefan On Mon, May 25, 2009 at 05:06:19AM +0200, Testweb Compilation wrote: > copy "lib_streams.lib" "g:\monet\monet.Int.32.32.d.1.28441\MonetDB5\.Int.32.32.d.1-Windows5.1\lib\MonetDB5\lib_streams.lib" > The system cannot find the file specified. > NMAKE : fatal error U1077: 'copy' : return code '0x1' > > http://www.ins.cwi.nl/~monet/permastore/2009-05-25/Stable/install-MonetDB5-… > > CVS committers: manegold(a)cwi.nl mk(a)cwi.nl niels(a)cwi.nl > > module maintainers: mk(a)cwi.nl niels(a)cwi.nl > > An identical error message was detected on the following systems: > Int.32.32.d.1-Windows5.1 Mic.32.32.d.1-Windows5.1 Int.64.32.d.1-Windows5.2 Mic.64.32.d.1-Windows5.2 Mic.64.64.d.1-Windows5.2 > > -- > At this time you cannot configure Testing mail, sorry > You are receiving this mail because: > - you checked in some code on MonetDB5 (Stable) > - you are a fixed recipient > -- | 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 4

[Monetdb-developers] GDK::BAT_select_ problem
by RichardGUO Fei 24 May '09

24 May '09

Hi, I am doing some developments in GDK. More concretely, I want to modify the behavior of a SQL select statement. I print some messages in BAT_select_ as I think that most of SQL selects would be compiled into plusieur BATselects. Is that right? I used mserver --dbinit 'include sql;' to start, and saw some messages coming out (BAT_select_ is also used for authentication). However, after I logged in by using mclient -l sql, no matter what kind of SELECT I performed, there was just no message. Was BAT_select_ called after all in this case? Thank you very much for your responses. Regards, Richard _________________________________________________________________ MSN 表情魔法书，改变你的对话时代！ http://im.live.cn/emoticons/

2 2

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Tests All, May2009, 1.61, 1.61.2.1
by Sjoerd Mullender 24 May '09

24 May '09

On 2009-05-24 11:43, Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/test/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15423/src/test/Tests I took care of the (non-)propagation of this and the other three All files. > Modified Files: > Tag: May2009 > All > Log Message: > disabled tests (should not be propagated!) > > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Tests/All,v > retrieving revision 1.61 > retrieving revision 1.61.2.1 > diff -u -d -r1.61 -r1.61.2.1 > --- All 9 Apr 2009 18:48:49 -0000 1.61 > +++ All 24 May 2009 09:43:11 -0000 1.61.2.1 > @@ -87,7 +87,7 @@ > setoptimizer > load_dec_as_int > string > -NOT_WIN32?crashme > +#NOT_WIN32?crashme > 50ways > load_with_offset > copy_into > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > _______________________________________________ > 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-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.303, 1.304
by Sjoerd Mullender 23 May '09

23 May '09

Is this a bug fix? On 2009-05-23 11:56, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19871 > > Modified Files: > mal_interpreter.mx > Log Message: > We better protect global variables in the interpreter. > > > U mal_interpreter.mx > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.303 > retrieving revision 1.304 > diff -u -d -r1.303 -r1.304 > --- mal_interpreter.mx 16 May 2009 18:26:23 -0000 1.303 > +++ mal_interpreter.mx 23 May 2009 09:55:57 -0000 1.304 > @@ -734,11 +734,12 @@ > #endif > @:performanceVariables@ > > -#ifdef DEBUG_FLOW2 > + pci = getInstrPtr(flow->mb, stkpc); > +#ifdef DEBUG_FLOW > stream_printf(cntxt->fdout,"#execute thread %d \n", tid); > + printInstruction(GDKstdout, flow->mb, 0, pci, LIST_MAL_ALL); > #endif > THRset_errbuf(THRget(THRgettid()), cntxt->errbuf); /* where to leave errors */ > - pci = getInstrPtr(flow->mb, stkpc); > if (stk->cmd || mb->trap) { > lng tm = 0; > if( oldtimer) > @@ -857,9 +858,13 @@ > { > int i; > > - assert(worker == NULL); > + mal_set_lock(mal_contextLock, "DFLOWcreate"); > + if ( work != NULL){ > + mal_unset_lock(mal_contextLock, "DFLOWcreate"); > + return; > + } > > - work = q_create(256); > + work = q_create(256); /* seems enough for the time being */ > > nway = GDKnr_threads; > worker = (FlowTask *) GDKzalloc(sizeof(FlowTask)*nway); > @@ -868,6 +873,7 @@ > /* create the thread and let it wait */ > MT_create_thread(&worker[i].tid, runDFLOWworker, worker+i); > } > + mal_unset_lock(mal_contextLock, "DFLOWcreate"); > } > > static void > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

2 1

[Monetdb-developers] ODBC windows build script
by Stefan de Konink 23 May '09

23 May '09

Is there any 'asset' available that allows to build the Windows ODBC driver from within Linux or a howto to build it in Windows? Especially related to the recent authentication changes. Stefan

3 3

[Monetdb-developers] DBSlayer for MonetDB
by Stefan de Konink 22 May '09

22 May '09

Hi, I have set up a development server for OpenStreetMap that allows 'Joe Regular' to perform /any/ SQL request on a dataset limited to the borders of The Netherlands, Belgium and Luxembourgh. That means around 700MB of data. Because OpenStreetMap mainly targets webdevelopment, making it easy-to-use and efficient-to-parse become key issues. Because my favorite webserver [1] implemented DBSlayer [2] technology for MySQL; I could plugin an architecture layer to support different databases. MonetDB is in beta phase, and PostgreSQL is coded. The output is available in native PHP, Python and Ruby arrays; JSON, and XML-RPC is coded but not yet in production. The attached script shows a trivial example how to query a database farm over the web. Hanging more servers under the webserver, automatically increases performance and redundancy. I configured the webserver in such way that a rewrite takes place if no LIMIT was specified. Because the requests are URIs, every request is logged, what makes it possible to analyse the performance and benchmark the test set against new releases. With this platform I am able to plugin my multicolumn 'optimizer' idea, so we all benefit. To the outside Mapi is available, for accessing it by our mclient or ODBC client. If our 'native' Ruby/Python MAPI implementations are ready for testing, I can promote them on the site, or provide a sandbox. The site itself is still boring; http://xapi.openstreet.nl:8000/ Stefan [1] http://www.cherokee-project.com/ [2] http://code.nytimes.com/projects/dbslayer #!/usr/bin/env python import urllib sql="SELECT lat, long FROM nodes_legacy, node_tags WHERE id = node AND k = 'amenity' and v = 'atm';" query = urllib.quote(sql) print 'Original:', sql print 'Encoded:', query url = 'http://xapi.openstreet.nl:8000/python/%s'%(query) response = urllib.urlopen(url) print 'RESPONSE:', response print 'URL :', response.geturl() headers = response.info() print 'DATE :', headers['date'] print 'HEADERS :' print '---------' print headers data = response.read() print 'LENGTH :', len(data) print 'DATA :' print '---------' obj = eval(data) print obj

1 0