July 2009 - developers-list

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server rel_select.mx, May2009, 1.143.2.4, 1.143.2.5
by Stefan de Konink 31 Jul '09

31 Jul '09

On Fri, 31 Jul 2009, Niels Nes wrote: Here you still asign something that could be NULL. > dnode *n = selection->h; > > - (void) where; > + if (!selection) > + return sql_error(sql, 02, "SELECT: the selection or from part is missing"); So the asignment should be after the check. Stefan

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal/Tests All, , 1.73, 1.74
by Stefan Manegold 30 Jul '09

30 Jul '09

On Thu, Jul 30, 2009 at 06:36:20PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv7859 > > Modified Files: > All > Log Message: > Move remote88 out of sight. It needs sql. maybe, it [cs]ould be move to the SQL tree, then? Stefan > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests/All,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- All 14 Jul 2009 15:21:04 -0000 1.73 > +++ All 30 Jul 2009 18:36:16 -0000 1.74 > @@ -30,8 +30,8 @@ > remote03 > remote04 > remote06 > -remote88 > -# needs Merovingian > +# needs Merovingian and aims at SQL > +#remote88 > #remote89 > remote99 > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/optimizer opt_datacyclotron.mx, , 1.10, 1.11
by Stefan Manegold 30 Jul '09

30 Jul '09

On Thu, Jul 30, 2009 at 06:34:36PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/optimizer > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv7647 > > Modified Files: > opt_datacyclotron.mx > Log Message: > Use the proper length for symbols. > > > U opt_datacyclotron.mx > Index: opt_datacyclotron.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/opt_datacyclotron.mx,v > retrieving revision 1.10 > retrieving revision 1.11 > diff -u -d -r1.10 -r1.11 > --- opt_datacyclotron.mx 14 Jul 2009 09:09:09 -0000 1.10 > +++ opt_datacyclotron.mx 30 Jul 2009 18:34:34 -0000 1.11 > @@ -88,7 +88,7 @@ > #ifdef BIND_DATAFLOW_OPT > setFunctionId(p, putName("bind",7)); ^^^^ ^ > #else > - setFunctionId(p, putName("copy",7)); > + setFunctionId(p, putName("copy",4)); ^^^^ ^ non-educated question: why is "bind" longer than "copy" ? ... or is that parameter not the length of that symbol? Stefan > #endif > used[getArg(p,0)] = 1; > actions++; > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/optimizer opt_octopus.mx, , 1.57, 1.58 opt_macro.mx, , 1.47, 1.48
by Martin Kersten 30 Jul '09

30 Jul '09

Fabian Groffen wrote: > On 29-07-2009 20:19:48 +0000, Martin Kersten wrote: >> octopus - check if the head is managed by merovingian > >> - if (list == NULL || needed == NULL){ >> + /* check if the head is properly administered for Octopus */ >> + SABAOTHgetLocalConnection(&name); > > This check will (almost) always succeed, setting name to non-NULL and > by no means checks for merovingian. Is this what you intended to > happen? well, OPCinitcode uses this call and got a null pointer in the situation that 1) 2 legs were created through monetdb and 2) the head was an mserver5 started separately and not createdb with monetdb. So, the test was for this null string and abandon octopus code. Otherwise, the final derived code would contain a remoter.connect(nil,"monetdb",.... > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

2 1

[Monetdb-developers] Announcement: May2009-SP2 bug fix release
by Sjoerd Mullender 29 Jul '09

29 Jul '09

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

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal algebraExtensions.mx, , 1.60, 1.61
by Martin Kersten 28 Jul '09

28 Jul '09

Should i restart the 400Mx400M experiment? I see a lot of BBPtrims passing by Stefan Manegold wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1551/MonetDB5/src/modules/mal > > Modified Files: > algebraExtensions.mx > Log Message: > > revive 1Gx1G by creating less partitions in the first step > > > U algebraExtensions.mx > Index: algebraExtensions.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/algebraExtensions.mx,v > retrieving revision 1.60 > retrieving revision 1.61 > diff -u -d -r1.60 -r1.61 > --- algebraExtensions.mx 28 Jul 2009 17:01:05 -0000 1.60 > +++ algebraExtensions.mx 28 Jul 2009 18:45:50 -0000 1.61 > @@ -780,7 +780,6 @@ > } > else > { > - int n = 0; > /* smaller exceeds L2 > * => partition for L2 in n steps (depth-first) such that no step > * generates more than 1024 new partitions per partition > @@ -803,8 +802,10 @@ > parts <<= 1; > } > @) > - n = ((p - 1) / 10) + 1; > - p /= n; > + p = p % 10; > + if (p == 0) { > + p = 10; > + } > parts = 1 << p; > } > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/kernel unix.mx, , 1.24, 1.25
by Sjoerd Mullender 28 Jul '09

28 Jul '09

Why do you want to be able to flush all changed files to disk? MonetDB already does flushes when they are needed for transaction support. I don't think we need to tell the kernel to synchronize any other files with the disk. This function doesn't do anything with memory management within the process. Furthermore, this function is not available on Windows. Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/kernel > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv20459 > > Modified Files: > unix.mx > Log Message: > We want to experiment with complete flushing memory in out of memory > queries. > > > U unix.mx > Index: unix.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/kernel/unix.mx,v > retrieving revision 1.24 > retrieving revision 1.25 > diff -u -d -r1.24 -r1.25 > --- unix.mx 7 Jan 2009 14:15:12 -0000 1.24 > +++ unix.mx 27 Jul 2009 06:29:44 -0000 1.25 > @@ -35,6 +35,10 @@ > address UNIXsetenv > comment "Set the environment variable string."; > > +command sync() :void > +address UNIXsync > +comment "Flush memory, expensive but sometimes needed"; > + > @- Implementation > The remainder is a straight forward mapping to the underlying > facilities > @@ -113,4 +117,10 @@ > return MAL_SUCCEED; > } > > +unix_export str UNIXsync(int *res); > +str UNIXsync(int *res){ > + (void) res; > + sync(); > + return MAL_SUCCEED; > +} > @} > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

2 1

[Monetdb-developers] Connection fails
by Riham Abdel Kader 27 Jul '09

27 Jul '09

Hi all, I have lately re-installed the Jun2008 release of MonetDB/XQuery. I can start Mserver successfully and connect to it with mclient to execute XQueries. When I try to connect to it using a MapiSocket from my java program, I get the following error: "java.net.ConnectException: Connection refused". I also tried: > telnet localhost 50000 and I get: Trying ::1... telnet: connect to address ::1: Connection refused Any idea what I could be doing wrong? Thanks for your time, Riham

3 3

[Monetdb-developers] Suggestion to ditch SHA-1, and embrace SHA-2
by Stefan de Konink 24 Jul '09

24 Jul '09

As already found in the news SHA-1 is advised to migrated off by 2010. I would suggest SHA-2 in protocol 9. Stefan

6 19

Re: [Monetdb-developers] [ monetdb-Bugs-2787825 ] mclient: stdin + statement
by Wouter Alink 23 Jul '09

23 Jul '09

The bug (#2787825) seems to be closed for comments, but I think this bug should not be closed until the documentation gets updated. typing "man mclient" on the stable branch tells me: --statement=stmt (-s stmt) Execute the specified query. The query is run before any queries from files specified on the command line are run, and before the interactive session is started (if the --interactive option is given). This is not in line with Martin's latest comment. Martin, could you re-open the bug (I don't have the permissions to do so)? Greetings, Wouter 2009/7/20 SourceForge.net <noreply(a)sourceforge.net>: > Bugs item #2787825, was opened at 2009-05-06 14:21 > Message generated for change (Comment added) made by mlkersten > You can respond by visiting: > https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787825&group_… > > Please note that this message will contain a full copy of the comment thread, > including the initial issue submission, for this request, > not just the latest update. > Category: Mapi > Group: Clients CVS Head >>Status: Closed >>Resolution: Wont Fix > Priority: 5 > Private: No > Submitted By: Wouter Alink (vzzzbx) > Assigned to: Nobody/Anonymous (nobody) > Summary: mclient: stdin + statement > > Initial Comment: > It seems that there is a problem with both providing data via stdin and via the -s feature in mclient. (see example below). > > A possible solution could perhaps be to forbid this use. Another solution would be to define a behaviour: either read the '-s' first or the stdin first. (perhaps this already is the case, but I couldn't find any documentation about it) > > $ cat data.dat > 1 > 2 > 3 > 4 > 5 > $ N=4; head -n $N data.dat | mclient -lsql -p50151 -dtest -s "copy $N records into aap from STDIN;" > MAPI = monetdb@localhost:50151 > QUERY = copy 4 records into aap from STDIN; > ERROR = !SQLException:sql:value ';' while parsing ';' from line 0 field 0 not inserted, expecting type int > !SQLException:importTable:failed to import table > > > ---------------------------------------------------------------------- > >>Comment By: Martin Kersten (mlkersten) > Date: 2009-07-20 21:48 > > Message: > Standard input is ignored in combination with -s. > Closing it as at best it can be considered a niche feature request. > > ---------------------------------------------------------------------- > > Comment By: Wouter Alink (vzzzbx) > Date: 2009-05-07 21:55 > > Message: > as discussed on the monetdb-users list, using either the -s _or_ the stdin > works fine (except for other reported/unreported bugs), but the combination > fails. (stefan's example works fine). > > I can very well imagine that using a combination should not be allowed > (and should not even become a feature request), but I feel that the current > message is not very helpful. > > And, actually (I hadn't thought of this option before), if I would have > specified "-i" then the documentation (mclient --help) says it reads from > stdin _after_ reading the command line args, but it generates the same > error. > > After some more tests I discovered that: > - when using the command line args + stdin + mentioning '-i', the > semi-colon after "copy $N records into aap from STDIN;" should be left out, > so the following does work: > > $ echo "1 > 2 > 3 > 4 > 5" | mclient -lsql -dtest -hskadi -p50151 -i -s "COPY 5 RECORDS INTO aap > FROM STDIN" > > (notice the omission of ';' after the COPY statement) > > If I do exactly the same, but leave out the '-i', no error is displayed, > but nothing gets inserted either. > > If I use only stdin only: > > $ echo "COPY 5 RECORDS INTO aap FROM STDIN; > 1 > 2 > 3 > 4 > 5" | mclient -lsql -dtest -hskadi -p50151 > > then this works (only if the ';' after the COPY statement is present). > > I don't know whether there are two different bugs mentioned in this > explanation, but I think there definitely is something wrong. > > by the way: the create statement for aap is: "CREATE TABLE aap (x int);" > > ---------------------------------------------------------------------- > > Comment By: Stefan Manegold (stmane) > Date: 2009-05-07 19:30 > > Message: > What about: > > { N=4 ; echo "copy $N records into aap from STDIN;" ; head -n $N data.dat > ; } | mclient -lsql -p50151 -dtest > > ? > > > ---------------------------------------------------------------------- > > Comment By: Sjoerd Mullender (sjoerd) > Date: 2009-05-07 14:26 > > Message: > Where does it say that this is supported? > If it doesn't say anywhere, this is a feature request, not a bug. > > ---------------------------------------------------------------------- > > You can respond by visiting: > https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787825&group_… >

2 3